<< 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: