STANDARDIZE

Standarises a value to a normal distribution.

Syntax:

STANDARDIZE(x:Number, mu:Number, sigma:Number)

Standarises the value x to the normal distribution given by mean mu and standard deviation sigma.

Formula:

Z = (xmu) ÷ sigma

Example:

SET_VALUE(B1:B15, STANDARDIZE(A1:A15, C1, D1))

returns, in cells B1:B15, the corresponding standarised values of each the contents of cells in the range A1:A15 from the given distribution's mean (C1) and standard deviation (D1) values.

Revisions:

This function was added in 2.00.