STANDARDIZE Function
Return a normalized value (z-score) based on the mean and standard deviation
Return a normalized value (z-score) based on the mean and standard deviation
The STANDARDIZE Function is available under Statistical functions. It will return a normalized value (z-score) based on the mean and standard deviation. A z-score, or standard score, is used for standardizing scores on the same scale by dividing a score’s deviation by the standard deviation in a data set. The result is a standard score. It measures the number of standard deviations a given data point is from the mean.
A z-score can be negative or positive. A negative score indicates a value less than the mean, and a positive score indicates a value greater than the mean. The average of every z-score for a data set is zero.
Z-scores are a way to compare results from a test to a “normal” population. The results from tests or surveys can include thousands of possible results and units. However, the results often seem meaningless. For example, knowing that someone’s height is 180 cms. can be useful information. However, if we want to compare it to the “average” person’s height, looking at a vast table of data can be overwhelming (especially if some heights are recorded in feet). A z-score can tell us where that person’s height is compared to the average population’s mean height.
=STANDARDIZE(x, mean, standard_dev)
The STANDARDIZE function uses the following arguments:
To understand the uses of the STANDARDIZE function, let us consider an example:
Suppose we are given the following data:
The formula we use is:
We get the result below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!