Skip to main content

VARA function

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:

ArgumentDescription
value1/2/nUp 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.

VARA Function