VAR

---

Name

Variance

Description

Calculates variance based on a sample of a population.

Syntax

VAR(value1, value2, . . . )

Remarks

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

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

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

The VAR function uses the following formula to calculate the variance:

See also AVERAGE, STDEV, STDEVP, and VARP.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

VAR(R1C2,100,R2C5,102)
VAR(B3,C4,B2,D10,E5)
VAR(A1:A9)
VAR(98,85,76,87,92,89,90)=45.8095238095