Excel functions / Statistics
STDEVA function
The standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
Syntax
=STDEVA(value1, [value2], …)
Arguments
value: Values, cells or ranges.
When to use it
STDEVA gives the standard deviation of a sample like STDEV, but counts text and FALSE in a range as 0 and TRUE as 1.
Examples
Text and logical values counted
A B C 1 Value 2 10 4.86 3 n/a 4 TRUE 5 FALSE In C2:
=STDEVA(A2:A5)→ 4.86The values counted are 10, 0, 1 and 0.
Common mistakes
- Use STDEV. Unless text really means zero, STDEV is the one to use.
STDEVA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: STDEVA
- Danish: STDAFVV
- Dutch: STDEVA
- Finnish: KESKIHAJONTAA
- French: STDEVA
- German: STABWA
- Hungarian: SZÓRÁSA
- Italian: DEV.ST.VALORI
- Norwegian: STDAVVIKA
- Polish: ODCH.STANDARDOWE.A
- Portuguese (Brazil): DESVPADA
- Portuguese (Portugal): DESVPADA
- Russian: СТАНДОТКЛОНА
- Spanish: DESVESTA
- Swedish: STDEVA
- Turkish: STDSAPMAA