Excel STANDARDIZE function

Function              STANDARDIZE

Description        Excel STANDARDIZE function returns a normalized value depending on the mean and standard deviation.

Syntax  STANDARDIZE(x, mean, standard_dev)

x  The value which is to normalize.

mean  The arithmetic mean of the distribution.

standard_dev  The standard deviation of the distribution.

Example:

=STANDARDIZE(35,5,2)=15

=STANDARDIZE(35,10,2)=12.5

Usage Note:

• If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value.
• The equation for the normalized value is =(x-mean)/standard_dev