VARPA
Calculates variance based on the entire population, including numbers, text, and logical values.
StatisticalStatistics & Analysis
What it does
Calculates population variance (includes text/logic).
Syntax
VARPA(value1, [value2], ...)
Arguments
value1(value) — Values.
Examples
Pop Variance A
Calculate with TRUE.
FORMULA
=VARPA(1, 2, TRUE)
RESULT
0.22
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 |