VARP (Primitive Spread Function) calculates variance based on the entire population.

SYNTAX:

VARP(value1,value2,...)

REMARKS:

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

The variance returns how spread out a set of data is.

The VARP function assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the variance using the VAR function.

The VARP function uses the following formula to calculate the variance: 

                                                                                                

 

EXAMPLES:

VARP(B3,C4,B2,D10,E5)
VARP(A1:A9)
VARP(98,85,76,87,92,89,90)=39.2653061224