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)