next up previous contents index
Next: CVARS Up: A. Function Reference Previous: CUMPRINC   Contents   Index


CVAR

Syntax: CVAR(argumentlist, C)

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

CVAR returns the population variance (N weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not included.

Examples:

CVAR(Y1..Y5, #$<$25) = 1, where Y1..Y5 = 22, 24, 29, 34, and 45

CVAR(A1..A3, #$<$C2*E7) = 6.8888889, where A1..A3 are 1, 2, 7, and C2 = 5 and E7 = 2

Excel function: N/A


next up previous contents index
Next: CVARS Up: A. Function Reference Previous: CUMPRINC   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003