STDEV

See also A-Z Spreadsheet Function List

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)

number_list is a list of as many as 30 numbers, separated by commas. The list can contain numbers or a reference to a range that contains numbers.

See Also STDEVP , VAR , and VARP functions

Example STDEV(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5) returns .56