 Formula Engine Reference Guide |
|
Back to Class Index
CVAR(argumentlist, C)
This function returns the population variance (N weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not included.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
Examples
CVAR(Y1..Y5, #<25) = 1
where Y1..Y5 = 22, 24, 29, 34, and 45
CVAR(A1..A3, #<C2E7) = 6.8888889
where A1..A3 are 1, 2, 7, and C2 = 5 and E7 = 2