The VARPA function is one of the statistical functions. It is used to analyze the set of values and return the variance of an entire population.
Syntax
VARPA(value1, [value2], ...)
The VARPA 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 VARPA function.
Examples
The figure below displays the result returned by the VARPA function.
