Home Application Office information

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

STANDARDIZE function: The function returns the normalized value from a distribution characterized by mean and standard_dev arguments. Syntax: STANDARDIZE (x, mean, standard_dev)

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

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

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:

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

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

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

- Press Enter -> normalized value of 29 is :

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

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

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

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

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

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

Good luck!

You've just finished reading the article "STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel" edited by the TipsMake team. You can save standardize-function-the-function-returns-the-normalized-value-from-a-specific-distribution-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV STDEV.P function - The function returns the standard deviation based on the whole in Excel
NEXT » SMALL function - The function returns the kth smallest value in a dataset in Excel
Read more