Calculates the sample variance of a set of numbers. The value of text is 0.
VARA(Number 1[; Number 2[; ...[; Number 255]]])
Returns a non-negative real number which is the estimated sample variance based on the numbers passed in the arguments.
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers.
- The parameters should specify at least two values. If there are less than two values, then the function will return a division (#DIV/0!) error.
- If any of the arguments contain text values either being passed directly then the function returns a name (#NAME?) error and if passed with double quotes then the function recognizes it as text and uses 0 for that value.
- If a cell contains text, error value, or empty cells, then the function uses the value 0 for them. For logical values, TRUE is considered as 1, and FALSE is considered as 0. However, empty cells are ignored.
- If a cell contains 0 then the function includes it.
- The formula for VAR is:
where xi is Number i, n is the count of xi's and x̄ is mean value.
- For more details on variance, visit Wikipedia.
|=VARA(3;4;5;6;2;3;1)||The function calculates the variance of the data||2.95238095238095|
|=VARA(3;4;5;6;2;3;1;"alpha")||The function calculates the variance of the data. Text has value 0.||4|
|=VARA(3,4,-5,6.05,2,3,-1.5)||The function calculates the sample variance of the data||13.7991666666667|
|=VARA(A1:A6) where A1:A5 contains 1,2,3,4,5, alpha(text)||The function calculates the variance of the data passed as a reference to the cell. Text has value 0.||3.5|
|=VARA(3)||The function will return a division error since less than 2 arguments are available.||#DIV/0!|
Related LibreOffice functions:
Equivalent Excel functions: