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:
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