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)