mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 01:13:40 +00:00
Mark Baker
f51c19c125
* First steps toward refactoring Statistical Distributions into smaller classes: BETA() and GAMMA() (and related functions) to start with... they all need a lot of tidying up, and more testing; but it's a start * Add basic datatype validations to Beta and Gamma Excel function implementations * Switch to using a trait with the validation methods to provide easier sharing between distribution classes * Additional unit tests for Beta and Gamma functions, including unhappy path for validations * Extract ChiSquared functions * Additional argument validation checks with unit tests for Chi Squared functions * Extract Fisher * Move MEDIAN() and MODE() to the Averages class * Extract filters for Median and Mode for common usage
16 lines
336 B
PHP
16 lines
336 B
PHP
<?php
|
|
|
|
return [
|
|
[1.329340388179, 2.5],
|
|
[0.267865934620, -3.75],
|
|
[9.513507698669, 0.1],
|
|
[1.0, 1.0],
|
|
[0.886226925453, 1.5],
|
|
[1.3293403881791, 2.5],
|
|
[17.837861981813, 4.8],
|
|
[52.342777784553, 5.5],
|
|
'Zero value' => ['#NUM!', 0.0],
|
|
'Negative integer value' => ['#NUM!', -1],
|
|
['#VALUE!', 'NAN'],
|
|
];
|