STANDARDIZE function
STANDARDIZE(X,
Mean, StandardDeviation) STANDARDIZE(X;
Mean; StandardDeviation)
X
Number or { Number }
The number to normalize.
Mean
Number or { Number }
The arithmetic mean of the distribution.
StandardDeviation
Number or { Number }
The standard deviation of the distribution.
Returns
Number or { Number }
The equivalent value in a standard normal distribution.
Converts a value in a normal distribution to its equivalent in a standard normal distribution.
Example
STANDARDIZE(14, 10,
4)STANDARDIZE(14; 10;
4)
Returns 1. The original value 14 lies one standard deviation above the original mean 10. The new value lies one standard deviation above the new mean 0.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.