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