Calculates the variance based on an entire population. Text and logical values are included in the calculation.
VARPA(value1, [value2, ...])
- value1 - Numerical value or range representing an entire population.
- value2, .. - [OPTIONAL] Additional numerical values or ranges to calculate for the variance.
VARPA(1,2,3,4,5,6,7,8,9,10) returns a value of 8.25.
VARPA(A2:A6) returns the variance of the numbers in cells A2 through A6.