VARA function
First
The first parameter.
Other
Additional parameters.
Returns
The sample variance of the parameters.
Returns the sample variance of the parameters. VARA(3, 4, 5, "6", 2, 3, 1)VARA(3; 4; 5; "6"; 2; 3; 1) returns roughly 3.0.
VARA accepts numbers, logical values and text strings representing numbers. VAR.S, by contrast, only accepts numbers. TRUE is interpreted as 1, FALSE is interpreted as 0, colors are ignored and text strings are parsed as though TONUMBER is used.
VARA takes the language of the app into account when converting text strings to numbers. When VARA is used with an app whose language is set to German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. When VARA is used with an app whose language is set to UK English, for instance, a decimal point (".") should be used. Thousands separators may not be used.
Example
Returns roughly 3.0.