STANDARDIZE


Description Computes the proper argument for the function that calculates the standard normal cumulative distribution, given specified values for x, mean, and standard deviation. This function is used to "translate" the three arguments required for the NORMDIST function into a form that can be used in NORMSDIST.

Syntax STANDARDIZE (x, mean, st_dev)
Argument Description
x The value at which you want to evaluate the function.
mean The arithmetic mean of the distribution.
st_dev The standard deviation of the distribution. It must be greater than 0.

Examples This function returns 11.25:

STANDARDIZE (95, 50, 4)

See Also NORMDIST, NORMSDIST