STANDARDIZE

Standarises a value to a normal distribution.

Syntax:

STANDARDIZE(x:number, mean:number, sd:number)

Standarises the value x to the normal distribution given by mean and sd.

The equation used is:

(x - mean) ÷ sd

Example:

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

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

Added in 1.36.