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 2.00.