Calculates the population standard deviation[1] of the values in a data set.
This is the square root of the population variance.
Syntax:
STDEVPA( list )
Returns the population standard deviation of the values in the list.
list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).
Note that numeric values and text cells are included in the calculation - with text being treated as zero - but that blank elements still do not upset the average.
Formula:
STDEVPA, σ = √ ( ( n⋅i ∑1n (xi2) − (i ∑1n xi)2 ) ∕ n2 )
where n is the number of values and xi is the i‑th value.
Example:
STDEVPA(A1:A15)
returns the population standard deviation of cells in the range A1:A15
.
Revisions:
This function was added in Fireworkz 2.00.