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