StatisticalTest::providerAVEDEV() - Code Metrics - Inspection of "Extended unit tests (#1087)" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5f7ed9...f1e82a )

by Mark

created 2019-07-16 14:18 UTC

StatisticalTest::providerAVEDEV() A

↳ Parent: StatisticalTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	1
nc	1
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php

namespace PhpOffice\PhpSpreadsheetTests\Calculation;

use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical;
use PHPUnit\Framework\TestCase;

class StatisticalTest extends TestCase
{
    public function setUp()
    {
        Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
    }

    /**
     * @dataProvider providerAVEDEV
     *
     * @param mixed $expectedResult
     */
    public function testAVEDEV($expectedResult, ...$args)
    {
        $result = Statistical::AVEDEV(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerAVEDEV()
    {
        return require 'data/Calculation/Statistical/AVEDEV.php';
    }

    /**
     * @dataProvider providerAVERAGE
     *
     * @param mixed $expectedResult
     */
    public function testAVERAGE($expectedResult, ...$args)
    {
        $result = Statistical::AVERAGE(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerAVERAGE()
    {
        return require 'data/Calculation/Statistical/AVERAGE.php';
    }

    /**
     * @dataProvider providerAVERAGEA
     *
     * @param mixed $expectedResult
     */
    public function testAVERAGEA($expectedResult, ...$args)
    {
        $result = Statistical::AVERAGEA(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerAVERAGEA()
    {
        return require 'data/Calculation/Statistical/AVERAGEA.php';
    }

    /**
     * @dataProvider providerAVERAGEIF
     *
     * @param mixed $expectedResult
     */
    public function testAVERAGEIF($expectedResult, ...$args)
    {
        $result = Statistical::AVERAGEIF(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerAVERAGEIF()
    {
        return require 'data/Calculation/Statistical/AVERAGEIF.php';
    }

    /**
     * @dataProvider providerBETADIST
     *
     * @param mixed $expectedResult
     */
    public function testBETADIST($expectedResult, ...$args)
    {
        $result = Statistical::BETADIST(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerBETADIST()
    {
        return require 'data/Calculation/Statistical/BETADIST.php';
    }

    /**
     * @dataProvider providerBETAINV
     *
     * @param mixed $expectedResult
     */
    public function testBETAINV($expectedResult, ...$args)
    {
        $result = Statistical::BETAINV(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerBETAINV()
    {
        return require 'data/Calculation/Statistical/BETAINV.php';
    }

    /**
     * @dataProvider providerCOUNTIF
     *
     * @param mixed $expectedResult
     */
    public function testCOUNTIF($expectedResult, ...$args)
    {
        $result = Statistical::COUNTIF(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerCOUNTIF()
    {
        return require 'data/Calculation/Statistical/COUNTIF.php';
    }

    /**
     * @dataProvider providerCOUNTIFS
     *
     * @param mixed $expectedResult
     */
    public function testCOUNTIFS($expectedResult, ...$args)
    {
        $result = Statistical::COUNTIFS(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerCOUNTIFS()
    {
        return require 'data/Calculation/Statistical/COUNTIFS.php';
    }

    /**
     * @dataProvider providerMAXIFS
     *
     * @param mixed $expectedResult
     */
    public function testMAXIFS($expectedResult, ...$args)
    {
        $result = Statistical::MAXIFS(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerMAXIFS()
    {
        return require 'data/Calculation/Statistical/MAXIFS.php';
    }

    /**
     * @dataProvider providerMINIFS
     *
     * @param mixed $expectedResult
     */
    public function testMINIFS($expectedResult, ...$args)
    {
        $result = Statistical::MINIFS(...$args);
        self::assertEquals($expectedResult, $result, '', 1E-12);
    }

    public function providerMINIFS()
    {
        return require 'data/Calculation/Statistical/MINIFS.php';
    }
}


1			<?php
2
3			namespace PhpOffice\PhpSpreadsheetTests\Calculation;
4
5			use PhpOffice\PhpSpreadsheet\Calculation\Functions;
6			use PhpOffice\PhpSpreadsheet\Calculation\Statistical;
7			use PHPUnit\Framework\TestCase;
8
9			class StatisticalTest extends TestCase
10			{
11			public function setUp()
12			{
13			Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
14			}
15
16			/**
17			* @dataProvider providerAVEDEV
18			*
19			* @param mixed $expectedResult
20			*/
21			public function testAVEDEV($expectedResult, ...$args)
22			{
23			$result = Statistical::AVEDEV(...$args);
24			self::assertEquals($expectedResult, $result, '', 1E-12);
25			}
26
27			public function providerAVEDEV()
28			{
29			return require 'data/Calculation/Statistical/AVEDEV.php';
30			}
31
32			/**
33			* @dataProvider providerAVERAGE
34			*
35			* @param mixed $expectedResult
36			*/
37			public function testAVERAGE($expectedResult, ...$args)
38			{
39			$result = Statistical::AVERAGE(...$args);
40			self::assertEquals($expectedResult, $result, '', 1E-12);
41			}
42
43			public function providerAVERAGE()
44			{
45			return require 'data/Calculation/Statistical/AVERAGE.php';
46			}
47
48			/**
49			* @dataProvider providerAVERAGEA
50			*
51			* @param mixed $expectedResult
52			*/
53			public function testAVERAGEA($expectedResult, ...$args)
54			{
55			$result = Statistical::AVERAGEA(...$args);
56			self::assertEquals($expectedResult, $result, '', 1E-12);
57			}
58
59			public function providerAVERAGEA()
60			{
61			return require 'data/Calculation/Statistical/AVERAGEA.php';
62			}
63
64			/**
65			* @dataProvider providerAVERAGEIF
66			*
67			* @param mixed $expectedResult
68			*/
69			public function testAVERAGEIF($expectedResult, ...$args)
70			{
71			$result = Statistical::AVERAGEIF(...$args);
72			self::assertEquals($expectedResult, $result, '', 1E-12);
73			}
74
75			public function providerAVERAGEIF()
76			{
77			return require 'data/Calculation/Statistical/AVERAGEIF.php';
78			}
79
80			/**
81			* @dataProvider providerBETADIST
82			*
83			* @param mixed $expectedResult
84			*/
85			public function testBETADIST($expectedResult, ...$args)
86			{
87			$result = Statistical::BETADIST(...$args);
88			self::assertEquals($expectedResult, $result, '', 1E-12);
89			}
90
91			public function providerBETADIST()
92			{
93			return require 'data/Calculation/Statistical/BETADIST.php';
94			}
95
96			/**
97			* @dataProvider providerBETAINV
98			*
99			* @param mixed $expectedResult
100			*/
101			public function testBETAINV($expectedResult, ...$args)
102			{
103			$result = Statistical::BETAINV(...$args);
104			self::assertEquals($expectedResult, $result, '', 1E-12);
105			}
106
107			public function providerBETAINV()
108			{
109			return require 'data/Calculation/Statistical/BETAINV.php';
110			}
111
112			/**
113			* @dataProvider providerCOUNTIF
114			*
115			* @param mixed $expectedResult
116			*/
117			public function testCOUNTIF($expectedResult, ...$args)
118			{
119			$result = Statistical::COUNTIF(...$args);
120			self::assertEquals($expectedResult, $result, '', 1E-12);
121			}
122
123			public function providerCOUNTIF()
124			{
125			return require 'data/Calculation/Statistical/COUNTIF.php';
126			}
127
128			/**
129			* @dataProvider providerCOUNTIFS
130			*
131			* @param mixed $expectedResult
132			*/
133			public function testCOUNTIFS($expectedResult, ...$args)
134			{
135			$result = Statistical::COUNTIFS(...$args);
136			self::assertEquals($expectedResult, $result, '', 1E-12);
137			}
138
139			public function providerCOUNTIFS()
140			{
141			return require 'data/Calculation/Statistical/COUNTIFS.php';
142			}
143
144			/**
145			* @dataProvider providerMAXIFS
146			*
147			* @param mixed $expectedResult
148			*/
149			public function testMAXIFS($expectedResult, ...$args)
150			{
151			$result = Statistical::MAXIFS(...$args);
152			self::assertEquals($expectedResult, $result, '', 1E-12);
153			}
154
155			public function providerMAXIFS()
156			{
157			return require 'data/Calculation/Statistical/MAXIFS.php';
158			}
159
160			/**
161			* @dataProvider providerMINIFS
162			*
163			* @param mixed $expectedResult
164			*/
165			public function testMINIFS($expectedResult, ...$args)
166			{
167			$result = Statistical::MINIFS(...$args);
168			self::assertEquals($expectedResult, $result, '', 1E-12);
169			}
170
171			public function providerMINIFS()
172			{
173			return require 'data/Calculation/Statistical/MINIFS.php';
174			}
175			}
176

PHPOffice / PhpSpreadsheet

Push — master ( 5f7ed9...f1e82a )

StatisticalTest::providerAVEDEV() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like