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:

$$\frac{X-M}{S}$$

Examples:

STANDARDIZE(1, 2, 1) = -1

STANDARDIZE(1, 2, 0) = Error

Excel function: STANDARDIZE