STDEV


Description Returns the standard deviation of a population based on a sample of supplied values. The standard deviation of a population represents an average of deviations from the population mean within a list of values.

Syntax STDEV ( number_list )
Argument Description
number_list A list of up to 30 numbers. The list may contain numeric values, cell references, range references, or array constants.Text and logical values in range references and array constants are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Example This function returns .56:

STDEV(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)

See Also STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA