The VAR returns the variance for a sample of numbers.
This function is used in statistics to measure the spread of data relative to the mean and shows how much the values in the sample deviate from the mean.
Syntax
VAR(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First value or sample range |
Numerical values or cell ranges |
[value2, ...] |
(optional) Additional values or ranges that need to be included in the sample |
Numerical values or cell ranges (up to 255 arguments) |
Examples of use
Calculating the variance of values in the range
=VAR(A1:A10)
The result will be equal to the variance of values in this range.
Calculating the variance of several individual values
=VAR(10, 12, 14, 16)
Result: approximately 6.67.
Notes
–If the arguments are not numerical values, they will be ignored.
–If all arguments are equal, the function will return 0.