VARA (variance of a sample) |
  
|
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 that contain the values to be evaluated (sample).
Note:
Unlike the VAR function, VARA also evaluates logical values and text. Both FALSE and text are evaluated as 0. TRUE is evaluated as 1.
Empty cells, however, are also ignored here.
Note:
The variance is calculated using the "unbiased" or "n-1" method.
Example:
VARA(2, 2, 3, 4, 1) returns 1.3
See also: