STDS(<List>)

 

Description

This function returns the sample standard deviation (N-1 weighting) of its arguments.  Blank cells and cells containing strings are ignored.  The function is given by:

 

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

STDS(1, 2, 7) = 3.2145503

 

STDS(Y1:Y5) = 9.2032603

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

 

STDS(K6:K10) = 0.79122058

Where K6:K10 = 1, .33, 0, -0.66, and -0.99.