VAR

See also A-Z Spreadsheet Function List

Description Returns the variance of a population based on a sample of values.

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

Example VAR(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5) returns .31