The VARA function is one of the statistical functions. It is used to analyze the set of values and calculate the sample variance.
Syntax
VARA(value1, [value2], ...)
The VARA function has the following arguments:
Argument | Description |
---|
value1/2/n | Up to 255 values for which you want to calculate the variance. |
Notes
Text and FALSE values are counted as 0, TRUE values are counted as 1, empty cells are ignored.
How to apply the VARA function.
Examples
The figure below displays the result returned by the VARA function.
