CSTDS(<List>, C)

Top  Previous  Next

 

Description

This function returns the sample standard deviation (N-1 weighting) of its arguments that satisfy the constraint C.  Blank cells and cells containing strings are ignored.

 

Parameters

 

<List>

Any combination of cells or ranges.

 

C

A constraint expression.

 

Examples

 

CSTDS(A1:A3, #<10) = 3.2145503

Where A1:A3 are 1, 2, and 7.

 

CSTDS(Y1:Y5, #25) = 8.1853528

Where Y1:Y5 = 22, 24, 29, 34, and 45.

 

Sponsored

Try Predictive Systems Lab

Interactive Demo →

Need Help?
Contact support