next up previous contents index
Next: STDS, STDEV Up: A. Function Reference Previous: STANDARDIZE   Contents   Index


STD, STDEVP

Syntax: STD(argumentlist)
  STDEVP(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

STD returns the population standard deviation (N weighting) of its arguments. Blank cells and cells containing strings are not counted. The function is given by:

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

STDEVP is a synonym for STD.

Examples:

STD(1, 2, 7) = 2.6246693

STDEVP(Y1..Y5) = 8.2316463, where Y1..Y5 = 22, 24, 29, 34, and 45

STDEVP(K6..K10) = 0.7076892, where K6..K10 = 1, .33, 0, -0.66, and -0.99

Excel function: STDEVP


next up previous contents index
Next: STDS, STDEV Up: A. Function Reference Previous: STANDARDIZE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003