DSTDEVP
Calculates the standard deviation based on the entire population of selected database entries.
Database
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DSTDEVP.php:64:
array (size=7)
4 =>
array (size=5)
'A' => string 'Tree' (length=4)
'B' => string 'Height' (length=6)
'C' => string 'Age' (length=3)
'D' => string 'Yield' (length=5)
'E' => string 'Profit' (length=6)
5 =>
array (size=5)
'A' => string 'Apple' (length=5)
'B' => float 18
'C' => float 20
'D' => float 14
'E' => float 105
6 =>
array (size=5)
'A' => string 'Pear' (length=4)
'B' => float 12
'C' => float 12
'D' => float 10
'E' => float 96
7 =>
array (size=5)
'A' => string 'Cherry' (length=6)
'B' => float 13
'C' => float 14
'D' => float 9
'E' => float 105
8 =>
array (size=5)
'A' => string 'Apple' (length=5)
'B' => float 14
'C' => float 15
'D' => float 10
'E' => float 75
9 =>
array (size=5)
'A' => string 'Pear' (length=4)
'B' => float 9
'C' => float 8
'D' => float 8
'E' => float 76.8
10 =>
array (size=5)
'A' => string 'Apple' (length=5)
'B' => float 8
'C' => float 9
'D' => float 6
'E' => float 45
Criteria
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DSTDEVP.php:74:
array (size=3)
1 =>
array (size=1)
'A' => string 'Tree' (length=4)
2 =>
array (size=1)
'A' => string '=Apple' (length=6)
3 =>
array (size=1)
'A' => string '=Pear' (length=5)
The standard deviation in the yield of Apple and Pear trees
DSTDEVP() Result is 2.6532998322843
Criteria
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DSTDEVP.php:82:
array (size=3)
1 =>
array (size=1)
'A' => string 'Tree' (length=4)
2 =>
array (size=1)
'A' => string '=Apple' (length=6)
3 =>
array (size=1)
'A' => string '=Pear' (length=5)
The standard deviation in height of Apple and Pear trees
DSTDEVP() Result is 3.6