Conditional Statistical Functions

 

Ø  @CAVG(..., C) -

Conditional average.

 

Ø  @CCOUNT(..., C) -

Conditional count.

 

Ø  @CMAX(..., C) -

Conditional maximum.

 

Ø  @CMIN(..., C) -

Conditional minimum.

 

Ø  @CSTD(..., C) -

Conditional sample standard deviation (N weighting).

 

Ø  @CSTDS(..., C) -

Conditional sample standard deviation (N-1 weighting).

 

Ø  @CSUM(..., C) -

Conditional sum.

 

Ø  @CVAR(..., C) -

Conditional population variance (N weighting).

 

Ø  @CVARS(..., C) -

Conditional population variance (N-1 weighting).