VARPA function
VARPA calculates the variance based on the entire population. In addition to numbers, text and logical values such as TRUE and FALSE are included.
Syntax
VARPA (value 1, value 2, ... value 30)
value 1, value 2, ...value 30 are values or ranges representing an entire population. The value arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
Note: If the data represents a sample of
the entire population, use VARA to compute the variance. If logical
values or text must not be included, use VARP instead.
Example
=VARPA(A1:A50)