StdDevP
Calculates the population standard deviation of the values in a list of values, ranges and/or lists, i.e. the square root of the variance.
Syntax
StdDevP(param1, param2, ...)EcarTypeP(param1, param2, ...)
param1 = first parameter (value, range, or list) of the set whose population standard deviation you want to calculate
param2 = second parameter (value, range, or list) of the set whose population standard deviation you want to calculate
... = nth parameter (value, range, or list) of the set whose population standard deviation you want to calculate
Remarks
This function accepts an unlimited number of parameters.
Empty cells and values are not counted when determining the total number of elements in the calculation.
To calculate the standard score, see StdDev.
Examples
StdDevP(1, 2) = 0.5EcarTypeP(A1:B3) = population standard deviation for all of the numerical values in the A1:B3 range