Excel functions / Statistics
VARPA function
The variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
Syntax
=VARPA(value1, [value2], …)
Arguments
value: Values, cells or ranges.
When to use it
VARPA gives the variance 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 17.69 3 n/a 4 TRUE 5 FALSE In C2:
=VARPA(A2:A5)→ 17.69
Common mistakes
- Use VAR.P. Unless text means zero, VAR.P is the one.
VARPA 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: VARPA
- Danish: VARIANSPV
- Dutch: VARPA
- Finnish: VARPA
- French: VARPA
- German: VARIANZENA
- Hungarian: VARPA
- Italian: VAR.POP.VALORI
- Norwegian: VARIANSPA
- Polish: WARIANCJA.POPUL.A
- Portuguese (Brazil): VARPA
- Portuguese (Portugal): VARPA
- Russian: ДИСПРА
- Spanish: VARPA
- Swedish: VARPA
- Turkish: VARSA