STANDARDIZE(x, mean, stdev)

The STANDARDIZE function calculates a nomalized value for x, by subtracting the mean and dividing the result by the standard deviation (stdev) of a distribution. This allows direct comparison to the standard normal distribution.

For example:

STANDARDIZE(30, 20, 1.8)

returns 5.56, that is (30-20)/1.8.

See also:

Other statistical functions