| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- <?php
- namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Statistical;
- use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
- use PhpOffice\PhpSpreadsheet\Calculation\Statistical;
- use PHPUnit\Framework\TestCase;
- class GammaTest extends TestCase
- {
- /**
- * @dataProvider providerGAMMA
- *
- * @param mixed $expectedResult
- * @param mixed $testValue
- */
- public function testGAMMA($expectedResult, $testValue): void
- {
- $result = Statistical::GAMMAFunction($testValue);
- self::assertEqualsWithDelta($expectedResult, $result, 1E-12);
- }
- public function providerGAMMA(): array
- {
- return require 'tests/data/Calculation/Statistical/GAMMA.php';
- }
- /**
- * @dataProvider providerGammaArray
- */
- public function testGammaArray(array $expectedResult, string $values): void
- {
- $calculation = Calculation::getInstance();
- $formula = "=GAMMA({$values})";
- $result = $calculation->_calculateFormulaValue($formula);
- self::assertEqualsWithDelta($expectedResult, $result, 1.0e-14);
- }
- public function providerGammaArray(): array
- {
- return [
- 'matrix' => [
- [[2.363271800901467, 4.590843711999102], [1.2254167024651963, 17.837861981813575]],
- '{-1.5, 0.2; 0.75, 4.8}',
- ],
- ];
- }
- }
|