mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 17:33:55 +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
53 lines
741 B
PHP
53 lines
741 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
3.5,
|
|
[1, 2, 4, 7, 8, 9, 10, 12, 1],
|
|
],
|
|
[
|
|
5.4,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 0],
|
|
],
|
|
[
|
|
7.2,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 1],
|
|
],
|
|
[
|
|
8.1,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 2],
|
|
],
|
|
[
|
|
10.5,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 3],
|
|
],
|
|
[
|
|
200,
|
|
[10.5, 7.2, 200, 5.4, 8.1, 4],
|
|
],
|
|
[
|
|
7.75,
|
|
[7, 8, 9, 10, 1],
|
|
],
|
|
[
|
|
8.5,
|
|
[7, 8, 9, 10, 2],
|
|
],
|
|
[
|
|
9.25,
|
|
[7, 8, 9, 10, 3],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[7, 8, 9, 10, -1],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[7, 8, 9, 10, 5],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[7, 8, 9, 10, 'X'],
|
|
],
|
|
];
|