<< 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). 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 given. 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 evaluates as 0. TRUE evaluates as 1. Text evaluates 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