This function returns the variance based on a sample of a population, which includes numeric, logical, or text values.

Syntax

VARA(value1,value2,...)

VARA(array)

VARA(array1,array2,...)

Remarks

Each argument can be a double-precision floating-point value, an integer value, text, a logical value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

Remarks

The variance returns how spread out a set of data is.

This function uses the following equation to calculate the variance, where n is the number of values.

where x is the value and n is the number of values.

This function assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance using the VARPA function.

This function differs from VAR because it accepts text and logical values as well as numeric values.

Data Types

Accepts numeric, logical, and text data for all arguments. Returns numeric data.

Examples

VARA(B3,C4,B2,D10,E5)

VARA(A1:A9)

VARA(R1C2,100,R2C5,102)

VARA(R1C1:R9C1)

VARA(R1C1:R1C9)

VARA(98,85,76,87,92,89,90) gives the result 45.8095238095