• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • COUNTIF function
  • EXP function
  • FV function
  • LOG function
  • MAX function
  • MEDIAN function
  • MIN function
  • MKDEC function
  • MKINT function
  • MOD function
  • POS function
  • PV function
  • R function
  • RATIO function
  • RC function
  • RCNV function
  • RCR function
  • RCTOTAL function
  • ROUND function
  • ROWCOUNT function
  • RR function
  • RRTOTAL function
  • STDDEV function
  • SUM function
  • TOTAL function

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.

Related Topics

• Mathematical and Financial Functions