The Excel STANDARDIZE function returns a normalized value (z-score) based on the mean and standard deviation.
Syntax:= STANDARDIZE (x, mean, standard_dev)
The STANDARDIZE function syntax has the following arguments:
- X Required. The value you want to normalize.
- Mean Required. The arithmetic mean of the distribution.
Standard_dev Required. The standard deviation of the distribution.
Example: Let’s look at some Excel STANDARDIZE function examples and explore how to use the STANDARDIZE function as a worksheet function in Microsoft Excel:
Let’s understand this function using it in an example.
Here we have scores of the students and we need to find the Z score for the data.
To calculate a z-score, you need to calculate the mean and standard deviation. For mean, we will use the AVERAGE function and For Standard deviation, STDEV.P function.
The formulas in B19 and B20 are, respectively:
Based on the Excel spreadsheet above, the following STANDARDIZE examples would return:
- #NUM! error – Occurs if the given standard_dev argument is less than 0.
- #VALUE! error – Occurs if any of the given arguments are non-numeric.