<< Click to Display Table of Contents >> STANDARDIZE (standardized value) |
Syntax:
STANDARDIZE(x, Mean, StdDev)
Description:
Returns the normalized value of x for a distribution given by mean and standard deviation.
x is the value to be normalized.
Mean is the arithmetic mean of the distribution.
StdDev is the standard deviation of the distribution.
Example:
STANDARDIZE(5, 4, 1.25) returns 0.8
See also:
AVERAGE, STDEV.S/STDEV, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST