STANDARDIZE Function - Standardizing Values in Excel

This article introduces the STANDARDIZE function - one of the statistical functions highly favored in Excel.

Description: Returns standardized values from a distribution characterized by the mean and standard_dev parameters.

Syntax: STANDARDIZE(x, mean, standard_dev)

Key Parameters:

- x: Value to be standardized, a mandatory parameter.

- mean: Arithmetic mean of the distribution, a mandatory parameter.

- standard_dev: Standard deviation of the distribution, a mandatory parameter.

Note:

- If standard_dev ≤ 0 -> the function returns an error value #NUM!

- The formula for standardizing the value is:

Z=X−μσ$Z=\frac{X-\mu }{\sigma }$

Example:

Calculate the standardized values of the data table below:

- Calculate the standardized value of 29. In the cell where you want to calculate, enter the formula =STANDARDIZE(D6,D8,D9)

- Press Enter -> the standardized value of 29 is:

- Calculate the standardized value of -29. In the cell where you want to calculate, enter the formula: =STANDARDIZE(D7,D8,D9) -> Press Enter -> The standardized value of -29 is:

- If the standard deviation of the distribution is less than or equal to 0 -> the function returns an error value #NUM!

Here is the guidance and some specific examples when using the STANDARDIZE function in Excel.

Wishing you success!