mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 13:25:18 +00:00
Mark Baker
1c92b7611a
* Extract Percentile-type functions from Statistics (e.g. PERCENTILE(), PERCENTRANK(), QUARTILE(), and RANK()) * Unit test for PERCENTILE() with an empty (of numbers) dataset
37 lines
371 B
PHP
37 lines
371 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
5,
|
|
5, 1,
|
|
],
|
|
[
|
|
2,
|
|
2.2, 1.1,
|
|
],
|
|
[
|
|
5,
|
|
5.1, 1.9,
|
|
],
|
|
[
|
|
1,
|
|
1, 2,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
-1, 2,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
1, -2,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN', 31,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
49, 'NaN',
|
|
],
|
|
];
|