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
61 lines
741 B
PHP
61 lines
741 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
32,
|
|
100, 0.3, 0.7,
|
|
],
|
|
[
|
|
4,
|
|
6, 0.5, 0.75,
|
|
],
|
|
[
|
|
7,
|
|
12, 0.5, 0.75,
|
|
],
|
|
[
|
|
46,
|
|
100, 0.5, 0.2,
|
|
],
|
|
[
|
|
50,
|
|
100, 0.5, 0.5,
|
|
],
|
|
[
|
|
56,
|
|
100, 0.5, 0.9,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN', 0.5, 0.9,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
100, 'NaN', 0.9,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
100, 0.5, 'NaN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
-1, 0.5, 0.9,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
100, -0.5, 0.9,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
100, 1.5, 0.9,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
100, 0.5, -0.9,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
100, 0.5, 1.9,
|
|
],
|
|
];
|