VARA (variance of a sample)

<< Click to Display Table of Contents >>

VARA (variance of a sample)

Syntax:

VARA(Value1, Value2 [, Value3 ...])

Description:

The VARA function is almost identical to the VAR function (see note). It estimates the variance of a population based on a sample.

Number1, Number2, etc. are single values, cell ranges, or arrays containing the values to be evaluated (sample).

Note:

Unlike the VAR function, VARA 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.

Annotation:

The variance is calculated using the "unbiased" or "n-1" method.

Example:

VARA(2, 2, 3, 4, 1) returns 1.3

See also:

VAR.S/VAR, VARPA