mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 15:13:41 +00:00
Mark Baker
029f345987
* Extract Binomial Distribution functions from Statistical Replace the old MS algorithm for CRITBINOM() (which has now been replaced with te BINOM.INV() function) with a brute force approach - I'll look to refine it later. The MS algorithm is no longer documented, and the implementation produced erroneous results anyway * Exract the NEGBINOMDIST() function as well; still need to add a cumulative flag to support the additional argument for the newer NEGBINOM.DIST() function * Rationalise validation of probability arguments
81 lines
1.2 KiB
PHP
81 lines
1.2 KiB
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
0.706399436132,
|
|
3, 8, 0.35, true,
|
|
],
|
|
[
|
|
0.2785857790625,
|
|
3, 8, 0.35, false,
|
|
],
|
|
[
|
|
0.538748204875,
|
|
50, 125, 0.4, true,
|
|
],
|
|
[
|
|
0.278585779062,
|
|
3, 8, 0.35, false,
|
|
],
|
|
[
|
|
0.205078125,
|
|
6, 10, 0.5, false,
|
|
],
|
|
[
|
|
1.36554E-17,
|
|
10, 100, 0.5, false,
|
|
],
|
|
[
|
|
0.079589237387,
|
|
50, 100, 0.5, false,
|
|
],
|
|
[
|
|
0.0008638556657,
|
|
65, 100, 0.5, false,
|
|
],
|
|
[
|
|
1.53165E-17,
|
|
10, 100, 0.5, true,
|
|
],
|
|
[
|
|
0.539794618694,
|
|
50, 100, 0.5, true,
|
|
],
|
|
[
|
|
0.999105034804,
|
|
65, 100, 0.5, true,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NAN', 100, 0.5, true,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
65, 'NAN', 0.5, true,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
65, 100, 'NAN', true,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
65, 100, 0.5, 'NAN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
-5, 100, 0.5, true,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
105, 100, 0.5, true,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
65, 100, -0.5, true,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
65, 100, 1.5, true,
|
|
],
|
|
];
|