VARP function
VARP calculates the variance based on the entire population.
Syntax
VARP (number 1, number 2, ... number 30)
number 1, number 2, ...number 30 are numerical values or ranges representing an entire population.
Note: If
the data represents a sample of the entire population, use VAR to
compute the variance. Logical values (TRUE and FALSE) and text are
ignored. If logical values and text must not be ignored, use VARPA
to compute the variance.
Example
=VARP(A1:A50)