STDEVP

See also A-Z Spreadsheet Function List

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

Syntax STDEVP(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 STDEV , VAR , and VARP functions

Example STDEVP(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5) returns .52