Estimates variance based on a sample, ignoring logical values and text.
Sample Usage
VARS(1,2,3,4,5,6,7,8,9,10)
VARS(A2:A6)
Syntax
VARS(value1, [value2, ...])
- value1 - Value or range representing a sample of a population.
- value2, .. - [OPTIONAL] Additional numerical values or ranges to calculate for the variance.
Examples
VARS(1,2,3,4,5,6,7,8,9,10) returns a value of 9.1666
VARS(A2:A6) returns the variance of the numbers in cells A2 through A6, where the values represent only a sample of all the data. VARS returns a different result than VARP, which treats the range of data as the entire population.
Notes
- A minimum of two values must be supplied as value arguments. Else, VARS will return an error.
- VARS will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use VARA
. - VARS calculates variance for a sample. To calculate variance for an entire population, use VARP.