VARP(list)

The VARP function calculates the variance of a list on the assumption that list contains the whole population.

The variance is a measure of the spread of data from the mean, and is calculated using the formula:

image\ebx_-1115049335.gif

VARP assumes that list is the whole of a population, so use VAR (see VAR) if you wish to estimate the variance based on a sample.

For example:

VARP(9, 6, 5, 1, 10, 9, 3)

returns 9.836735.

See also:

AVERAGE(list) or AVG(list)

Other statistical functions