Estimates variance based on a sample, including text and logical values.
VARA(value1, [value2, ...])
- value1 - Value or range representing a sample of a population.
- value2, .. - [OPTIONAL] Additional numerical values or ranges to calculate for the variance.
VARA(1,2,3,4,5,6,7,8,9,10) returns a value of 9.1666
VARA(A2:A6) returns the variance of the numbers in cells A2 through A6, where the values represent only a sample of all the data.