Learn How to Use Microsoft Excel STANDARDIZE Function

Microsoft Excel STANDARDIZE Function

The main purpose of the Microsoft Excel STANDARDIZE function is to calculate normalize value or z-score. That implies, with the help of STANDARDIZE function you can able to return a normalized value or z-score, based on the mean and standard deviation. A z-score, or standard score, can be understood as a way of standardizing scores on the same scale by dividing a score's deviation by the standard deviation in a data set. The result will be the standard score or a z-score. It is used to the number of standard deviations a given data point is from the mean So, with the help of STANDARDIZE function, you can able to calculate normalize value or z-score.

Return Value of STANDARDIZE Function

The return value will be the normalized value.

Syntax of STANDARDIZE Function

=STANDARDIZE(x, mean, standard-dev)

Where the arguments:

• x: This is the value to normalize.
• mean: This is the arithmetic mean of the distribution.
• standard-dev: This is the standard deviation of the distribution

How to Use Microsoft Excel STANDARDIZE Function?

So we know that Microsoft Excel STANDARDIZE function you can able to calculate normalize value or z-score. That implies, with the help of STANDARDIZE function you can able to return a normalized value or z-score, based on the mean and standard deviation. A z-score, or standard score, can be understood as a way of standardizing scores on the same scale by dividing a score's deviation by the standard deviation in a data set. The result will be the standard score or a z-score. It is used to the number of standard deviations a given data point is from the mean So, with the help of STANDARDIZE function, you can able to calculate normalize value or z-score.

Check out the list of all other articles:

• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel
• Learn How to Sort Birthdays by Month and DAY in Microsoft Excel