next up previous contents index
Next: STD, STDEVP Up: A. Function Reference Previous: SSQ   Contents   Index


STANDARDIZE

Syntax: STANDARDIZE(X, M, S)

X = a numeric value
M = a numeric value
S = a numeric value greater than 0

STANDARDIZE returns the normalized value of X for a distribution with mean M and standard deviation S. S must be greater than 0. The function is given by:

\begin{displaymath}
\frac{X-M}{S}
\end{displaymath}

Examples:

STANDARDIZE(1, 2, 1) = -1

STANDARDIZE(1, 2, 0) = Error

Excel function: STANDARDIZE


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