<< Click to Display Table of Contents >> STANDARDIZE (standardized value)

Syntax:

STANDARDIZE(x, Mean, StdDev)

Description:

This returns the standardized value of x based on a distribution defined by its mean and standard deviation.

x is the value to be standardized.

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