Formula Engine Reference Guide
 

 

Back to Class Index

 

STDS(argumentlist)

Description
Returns the sample standard deviation (N-1 weighting) of its arguments. Blank cells and cells containing strings are not counted.
 
Parameters
argumentlist

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