next up previous contents index
Next: CSUM Up: A Function Reference Previous: CSTD

CSTDS

 

Syntax: @CSTDS(argumentlist, C)

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

@CSTDS returns the sample standard deviation (N-1 weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.

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


next up previous contents index
Next: CSUM Up: A Function Reference Previous: CSTD

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