Next: STRING Up: A. Function Reference Previous: STD, STDEVP Contents Index

STDS, STDEV

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:

$\begin{displaymath} \sqrt{ \frac{1}{N-1} \sum_{i=1}^N (x_i - \overline{x})^2 } \end{displaymath}$

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

Next: STRING Up: A. Function Reference Previous: STD, STDEVP Contents Index

SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003

Syntax:	STDS(argumentlist)
	STDEV(argumentlist)