VAR.P
Calculates variance based on the entire population.
StatisticalStatistics & Analysis
What it does
Legacy population variance.
Syntax
VARP(number1, [number2], ...)
Arguments
number1(number) — Values.
Examples
Legacy Pop Var
Calculate legacy var.
FORMULA
=VARP(A1:A5)
RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
| 5 | 4 |
| 6 | 5 |