mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 08:23:43 +00:00
Mark Baker
a34dd71cce
* Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice * Simplify STDEV() function logic by remembering that STDEV() is simply the square root of VAR(), so we can simply use the VAR() calculaion rather than duplicating the basic logic... and also allow for the differences between Excel/Gnumeric and Open/LibreOffice
58 lines
1.0 KiB
PHP
58 lines
1.0 KiB
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
11,
|
|
[10, 7, 9, 27, 2],
|
|
],
|
|
[
|
|
10,
|
|
[10, 7, 9, 27, 2, 5],
|
|
],
|
|
[
|
|
19,
|
|
[10, 15, 32],
|
|
],
|
|
[
|
|
8.85,
|
|
[10.5, 7.2],
|
|
],
|
|
[
|
|
19.2,
|
|
[7.2, 5.4, 45],
|
|
],
|
|
[
|
|
46.24,
|
|
[10.5, 7.2, 200, 5.4, 8.1],
|
|
],
|
|
[
|
|
4.025,
|
|
[
|
|
// The index simulates a cell value
|
|
// Numbers and Booleans are both counted
|
|
'0.1.A' => 1,
|
|
'0.2.A' => '2',
|
|
'0.3.A' => 3.4,
|
|
'0.4.A' => true,
|
|
'0.5.A' => 5,
|
|
'0.6.A' => null,
|
|
'0.7.A' => 6.7,
|
|
'0.8.A' => 'STRING',
|
|
'0.9.A' => '',
|
|
],
|
|
],
|
|
[
|
|
3.183333333333,
|
|
[1, '2', 3.4, true, 5, 6.7],
|
|
],
|
|
[
|
|
// When non-numeric strings are passed directly, then a #VALUE! error is raised
|
|
'#VALUE!',
|
|
[1, '2', 3.4, true, 5, null, 6.7, 'STRING', ''],
|
|
],
|
|
[
|
|
'#DIV/0!',
|
|
[],
|
|
],
|
|
];
|