Syntax: @VAR(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:
Examples:
@VAR(1, 2, 7) = 6.8888889
@VAR(Y1..Y5) = 67.76, where Y1..Y5 = 22, 24, 29, 34, and 45
@VAR(K6..K10) = 0.500824, where K6..K10 = 1, .33, 0, -0.66, and -0.99