mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 12:58:32 +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
53 lines
694 B
PHP
53 lines
694 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
0.05504866037517786,
|
|
10, 5, 0.25,
|
|
],
|
|
[
|
|
0.047210693359375,
|
|
6, 12, 0.5,
|
|
],
|
|
[
|
|
0.0805901288986206,
|
|
12, 12, 0.5,
|
|
],
|
|
[
|
|
0.057564377784729004,
|
|
15, 12, 0.5,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN', 12, 0.5,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
15, 'NaN', 0.5,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
15, 12, 'NaN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
15, 12, -0.25,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
-1, 1, 0.25,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
1, 0.5, 0.25,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
6, 12, -0.25,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
1, 12, 1.25,
|
|
],
|
|
];
|