Excel functions / Statistics
STDEVPA function
The standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
Syntax
=STDEVPA(value1, [value2], …)
Arguments
value: Values, cells or ranges.
When to use it
STDEVPA gives the standard deviation of a whole population, counting text and FALSE as 0 and TRUE as 1.
Examples
Text and logical values counted
A B C 1 Value 2 10 4.21 3 n/a 4 TRUE 5 FALSE In C2:
=STDEVPA(A2:A5)→ 4.21
Common mistakes
- Use STDEV.P. Unless text really means zero, STDEV.P is the one.
STDEVPA 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: STDEVPA
- Danish: STDAFVPV
- Dutch: STDEVPA
- Finnish: KESKIHAJONTAPA
- French: STDEVPA
- German: STABWNA
- Hungarian: SZÓRÁSPA
- Italian: DEV.ST.POP.VALORI
- Norwegian: STDAVVIKPA
- Polish: ODCH.STANDARD.POPUL.A
- Portuguese (Brazil): DESVPADPA
- Portuguese (Portugal): DESVPADPA
- Russian: СТАНДОТКЛОНПА
- Spanish: DESVESTPA
- Swedish: STDEVPA
- Turkish: STDSAPMASA