Syntax: | STDS(argumentlist) |
STDEV(argumentlist) |
argumentlist = any combination of numbers, cells, or ranges
STDS returns the sample standard deviation (N-1
weighting) of its arguments. Blank cells and cells
containing strings are not counted. The formula is given by:
STDEV is a synonym for STDS.
Examples:
STDS(1, 2, 7) = 3.2145503
STDEV(Y1..Y5) = 9.2032603, where Y1..Y5 = 22, 24, 29, 34, and 45
STDEV(K6..K10) = 0.79122058, where K6..K10 = 1, .33, 0, -0.66, and -0.99
Excel function: STDEV