|
<< Click to Display Table of Contents >> VARA (variance of a sample) |
Syntax:
VARA(Number1, Number2 [, Number3 ...])
Description:
The VARA function is almost identical to the VAR function (see note). It thus provides an estimate of the variance of a population based on a sample.
Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated (sample).
Note:
Unlike the VAR function, VARA 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.
Additional info:
The variance is calculated using the "unbiased" or "n-1" method.
Example:
VARA(2, 2, 3, 4, 1) returns 1.3
See also: