VAR(list)

The VAR function calculates the sample variance of the list. The list can contain numbers, cell addresses, ranges, and cell names.

VAR is calculated according to the formula:

image\ebx_-258648299.gif

See also:

AVERAGE(list) or AVG(list)

Other statistical functions