Files
PhpSpreadsheet/tests/data/Calculation/Statistical/HYPGEOMDIST.php
Mark Baker 17af13281b Extract a few more Distribution functions from Statistical (#1975)
* Extract a few more Distribution functions from Statistical; this time EXPONDIST() and HYPGEOMDIST()

* Extract the F Distribution (although only F.DIST() is implemented so far

* Updae docblocks

* PHPCS
2021-03-31 21:45:06 +02:00

69 lines
902 B
PHP

<?php
return [
[
0.3632610939112,
1, 4, 8, 20,
],
[
0.4525252525252,
1, 4, 4, 12,
],
[
0.3393939393939,
2, 4, 4, 12,
],
[
0.0646464646465,
3, 4, 4, 12,
],
[
0.0020202020202,
4, 4, 4, 12,
],
[
'#VALUE!',
'NAN', 4, 4, 12,
],
[
'#VALUE!',
4, 'NAN', 4, 12,
],
[
'#VALUE!',
4, 4, 'NAN', 12,
],
[
'#VALUE!',
4, 4, 4, 'NAN',
],
[
'#NUM!',
-1, 4, 4, 12,
],
[
'#NUM!',
0, 0, 4, 12,
],
[
'#NUM!',
4, 15, 4, 12,
],
[
'#NUM!',
5, 4, 4, 12,
],
[
'#NUM!',
5, 5, 4, 12,
],
[
'#NUM!',
5, 5, -4, 12,
],
[
'#NUM!',
5, 5, 15, 12,
],
];