STDEVA function
STDEVA returns the sample standard deviation while counting text and logical values: TRUE counts as 1, and FALSE and text in ranges count as 0. It is rarely used, and STDEV.S suits clean numeric data.
Example
Read it as a sentence: estimate the standard deviation of the sample in A1:A8, counting any text and logical values too, which gives 2.138089935.
Syntax
STDEVA(value1, [value2], ...)
Arguments in [square brackets] are optional.
-
value1(required) - First value or range.
-
value2(optional) - More values or ranges.
Returns: The sample standard deviation counting text and logicals.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=STDEVA({2,4,4,4,5,5,7,9}) | 2.138089935 | Array constant |
=STDEVA(10,"20",TRUE) | 9.504384953 | Direct args: number, text-number, TRUE |
=STDEVA({1,"2",TRUE,3}) | 1.414213562 | Array with text and boolean |
=STDEVA(Data!A1:A8) | 2.138089935 | Range of numbers |
=STDEVA(Data!B1:B8) | 16.65189822 | Mixed range: num, text-number, TRUE, blank, text, FALSE |
=STDEVA(Data!E1:E5) | 0 | All-text range |
=STDEVA(10,"abc") | #VALUE! | Direct arg: non-numeric text |
=STDEVA(5) | #DIV/0! | Single number |
The Data sheet these formulas read
A cell that starts with = holds that formula.
Watch out for
- Text in ranges drags results toward 0.
- Prefer STDEV.S for clean numeric data.
Where it works
- Excel
- STDEVA is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .