next up previous contents index
Next: VDB Up: A Function Reference Previous: VAR

VARS

 

Syntax: @VARS(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

@VARS returns the sample variance (N-1 weighting) of its arguments. Blank cells and cells containing strings are not counted. The formula is given by:

displaymath16421

Examples:

@VARS(1, 2, 7) = 10.333333

@VARS(Y1..Y5) = 84.7, where Y1..Y5 = 22, 24, 29, 34, and 45

@VARS(K6..K10) = 0.62603, where K6..K10 = 1, .33, 0, -0.66, and -0.99


next up previous contents index
Next: VDB Up: A Function Reference Previous: VAR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999