<< Click to Display Table of Contents >> 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 that contain 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: FALSE is evaluated as 0, while TRUE is evaluated as 1. Text is evaluated as 0.

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