How Do You Calculate Variance in Excel?

There are two basic ways of calculating variance in Excel using the function VAR or VAR.S. These functions can then calculate variance in several ways: use of numbers in arguments of function =VAR(2,3,4,5,6,7,8,125), use of cells as arguments in the formula =VAR(A2,A3,A4,A5), use of a range of cells as arguments in a formula =VAR(A2:A10,B4:C10), and a mix of above examples in one formula =VAR(A2:A10,B4,5,7).

ADVERTISEMENT