StdDev
Calculates the standard deviation of the values in a list of values, ranges and/or lists, minus 1 (or the standard score).
Syntax
StdDev(param1, param2, ...)EcarType(param1, param2, ...)
param1 = first parameter (value, range, or list) of the set whose standard score you want to calculate
param2 = second parameter (value, range, or list) of the set whose standard score you want to calculate
... = nth parameter (value, range, or list) of the set whose standard score 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 deviation without subtraction (the square root of the variance), see StdDevP.
Examples
StdDev(1, 2) = 0.707... (square root of 2 divided by 2)EcarType(A1:B3) = standard score for all of the numerical values in the A1:B3 range