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