VAR, VARP

Syntax:	VAR(argumentlist)
	VARP(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

VAR returns the population variance (N weighting) of its arguments. Blank cells and cells containing strings are not counted. The formula is given by:

$$\frac{1}{N} \sum_{i=1}^N (x_i - \overline{x})^2$$

VARP is a synonym for VAR.

Examples:

VAR(1, 2, 7) = 6.8888889

VAR(Y1..Y5) = 67.76, where Y1..Y5 = 22, 24, 29, 34, and 45

VARP(K6..K10) = 0.500824, where K6..K10 = 1, .33, 0, -0.66, and -0.99

Excel function: VARP