mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 11:53:44 +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
21 lines
297 B
PHP
21 lines
297 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
26.0545581424825,
|
|
[1345, 1301, 1368, 1322, 1310, 1370, 1318, 1350, 1303, 1299],
|
|
],
|
|
[
|
|
'#DIV/0!',
|
|
['A', 'B', 'C'],
|
|
],
|
|
[
|
|
0.5,
|
|
[true, false],
|
|
],
|
|
[
|
|
0.471404520791,
|
|
[true, false, 1],
|
|
],
|
|
];
|