 Formula Engine Reference Guide |
|
Back to Class Index
VAR(argumentlist)
Returns the population variance (N weighting) of its arguments. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination of numbers, cells, or ranges
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