Navigation:  Formulas and functions > Functions from A to Z > VARPA (variance of entire population)

Syntax:

VARPA(Number1, Number2 [, Number3 ...])

Description:

The VARPA function is almost identical to the VARP function (see note). It returns the variance of an entire population.

Number1, Number2, etc., are single values, cell ranges, or arrays containing the values to be evaluated. Please note that all values of the entire population have to be specified. To calculate the variance of a sample, use the VARA or VAR.S/VAR function instead. This returns an estimate of the variance.

Note:

Unlike the VARP function, VARPA also evaluates logical values and text. Both FALSE and text are evaluated as 0. TRUE is evaluated as 1.

Empty cells, however, are also ignored here.

Example:

VARPA(2, 2, 3, 4, 1) returns 1.04

See also:

VAR.P/VARP, VAR.S/VAR, VARA