VARS (Primitive Spread Function) calculates the sample variance (values represent a subset of the data, not the entire population)

SYNTAX:

VARS(Cell Range)

REMARKS:

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

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

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

       

Where Xbar is the mean, n is number of values, and x are the individual values.                                                                                

EXAMPLES:

VARS(A1:A9)