The VARPA function returns the variance for the entire population.
Text and logical values are taken into account in the calculation.
This function is used in statistics to measure the dispersion of all data in a population relative to the mean value.
Syntax
VARPA(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First value of the population |
Numerical values or cell ranges |
[value2, ...] |
(optional) Additional values or cell ranges |
Numerical values or cell ranges (up to 255 arguments) |
Examples of use
Calculating the population variance of values in the range
=VARPA(A1:A10)
The result will be equal to the population variance of values in this range.
Calculation of the population variance of several individual values
=VARPA(10, 12, 14, 16)
Result: 5.
Notes
–If the arguments are not numerical values, they will be ignored.
–If all arguments are equal, the function will return 0.