VARP

See also A-Z Spreadsheet Function List

Description Returns the variance of a population based on an entire population of values.

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

Example VARP(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5) returns .27