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)