next up previous contents index
Next: DATE Up: A Function Reference Previous: CVAR

CVARS

 

Syntax: @CVARS(argumentlist, C)

argumentlist = any combination of cells or ranges
C = a constraint expression

@CVARS returns the sample variance (N-1 weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not included.

Examples:

@CVARS(Y1..Y5, #<25) = 2, where Y1..Y5 = 22, 24, 29, 34, and 45

@CVARS(A1..A3, #<C2*E7) = 10.333333, where A1..A3 are 1, 2, 7, and C2 = 5 and E7 = 2


next up previous contents index
Next: DATE Up: A Function Reference Previous: CVAR

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