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