VAR
Estimates variance based on a sample.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Calculates sample variance (Legacy).
Syntax
VAR(number1, [number2], ...)
Arguments
number1(number) — Value.
Examples
Legacy Variance
Calculate sample var.
FORMULA
=VAR(A1:A5)
RESULT
2.5
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
| 5 | 4 |
| 6 | 5 |