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:
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: