Files
MarkBaker e41c4280f6 Initial creation of the version 2.0 Development branch
Start removing some of the deprecations, starting with the old Excel Function implementations.
2022-04-25 10:30:45 +02:00

33 lines
875 B
PHP

<?php
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Statistical;
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Averages\Mean;
use PHPUnit\Framework\TestCase;
class TrimMeanTest extends TestCase
{
protected function setUp(): void
{
Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
}
/**
* @dataProvider providerTRIMMEAN
*
* @param mixed $expectedResult
* @param mixed $percentage
*/
public function testTRIMMEAN($expectedResult, array $args, $percentage): void
{
$result = Mean::trim($args, $percentage);
self::assertEqualsWithDelta($expectedResult, $result, 1E-12);
}
public function providerTRIMMEAN(): array
{
return require 'tests/data/Calculation/Statistical/TRIMMEAN.php';
}
}