STDDEV Function
The STDDEV function calculates the standard deviation of the numbers contained in a range of cells.
Syntax
STDDEV(first cell..last cell,<argument>)
The argument is optional and controls what the function does with cells in the range that have different value types.
If the argument is included:
|
Argument |
Result |
|
0 |
The function includes all cells in the range. |
|
1 |
The function includes cells in the range that have a non-zero value. |
A cell with a zero value is a cell that is empty or that contains a blank.
Alternate Syntax
STDDEV("sum group",<argument>)
Where
sum group is the label assigned to a sum group of cells.
Example 1
STDDEV(C501..C507)
If the contents of cells C501 to C507 are:
69, 46, 55, 58, 67, 73 70
then, the value 9.81253 is returned.
Example 2
STDDEV("Expenses")
Where Expenses is the sum group to which the cells in example 1 are assigned and the values contained in the cells are the same.
Returns the value 9.81253.
Example 3
STDDEV("Office",0)
Where Office is the sum group to which cells C1 to C5 are assigned, and the contents of the cells are:
0, 13, 16, 17, 20
Because the 0 is included, the function returns the value 7.79102.
Example 4
STDDEV("Office",1)
Using the same data as in Example 3 with the 0 ignored, the function returns the value 2.88675.
