STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel

The following article introduces you to the STANDARDIZE function - one of the functions in the statistical function group is very popular in Excel.

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 1

Description: The function returns the normalized value from a distribution characterized by mean and standard_dev arguments.

Syntax: STANDARDIZE (x, mean, standard_dev)

Inside:

- x : The value you want to normalize, is a required parameter.

- mean: Arithmetic mean of distribution, is a required parameter.

- standard_dev: The standard deviation of the distribution, is a required parameter.

Attention:

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

- The equation for the normalized value is:

[Z = frac {{X - mu}} {sigma}]

For example:

Calculate the normalized value of the values ​​in the following data table:

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 2

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

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 3

- Press Enter -> normalized value of 29 is :

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 4

- Calculate the normalized value of -29. In the cell to calculate enter the formula: = STANDARDIZE (D7, D8, D9) -> press Enter -> The normalized value of -29 is:

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 5

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

STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel Picture 6

Above are instructions and some specific examples when using the STANDARDIZE function in Excel.

Good luck!