STANDARDIZE (standardized value)

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