Table of Contents
This guide explains how to use STANDARDIZE Function in Excel, including its syntax, required arguments, practical examples, and common errors.
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:
- Calculate the standardized value of 29 . In a cell to calculate, enter the formula : = STANDARDIZE (D6, D8, D9)
- Press Enter -> normalized value of 29 is :
- 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:
- Where the standard deviation of the distribution is less than or equal to 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the STANDARDIZE function in Excel.
Good luck!
FAQ
What does the STANDARDIZE function do in Excel?
The STANDARDIZE function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the STANDARDIZE function correctly?
Start with an equals sign, enter STANDARDIZE, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the STANDARDIZE function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.