Syntax:
DSTDP(range, condition)
Returns the population standard deviation of the contents of the cells in the range for which the condition is satisfied. This is the square root of the population variance.
The formula used is:
√( (n·Σi=n (xi2) − (Σi=n xi)2) ÷ n2 )
where xi is each value and n is the number of values.
Example:
DSTDP(A1:A15, B1:B15>0)
returns the population standard deviation of those cells in the range A1
to A15
whose equivalents in the range B1
to B15
are greater than zero.
See DAVG
for more examples of how to use the condition to control which cells are included.