mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 11:04:05 +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
61 lines
836 B
PHP
61 lines
836 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
1.9,
|
|
[1, 2, 3, 4, 0.3],
|
|
],
|
|
[
|
|
3.4,
|
|
[1, 2, 3, 4, 0.8],
|
|
],
|
|
[
|
|
3.25,
|
|
[1, 2, 3, 4, 0.75],
|
|
],
|
|
[
|
|
8.05,
|
|
[7, 8, 9, 20, 0.35],
|
|
],
|
|
[
|
|
8.1,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 0.5],
|
|
],
|
|
[
|
|
48.4,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 0.8],
|
|
],
|
|
[
|
|
2,
|
|
[2, 1, 6, 4, 3, 5, 0.2],
|
|
],
|
|
[
|
|
4,
|
|
[2, 1, 6, 4, 3, 5, 0.6],
|
|
],
|
|
[
|
|
3.5,
|
|
[2, 1, 6, 4, 3, 5, 0.5],
|
|
],
|
|
[
|
|
5.75,
|
|
[2, 1, 6, 4, 3, 5, 0.95],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[1, 2, 3, 4, -0.3],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[1, 2, 3, 4, 1.5],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
['A', 'B', 0.5],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[1, 2, 3, 4, 'NaN'],
|
|
],
|
|
];
|