-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel STANDARDIZE Function
In this article, you will learn how to use the Microsoft Excel STANDARDIZE function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel STANDARDIZE function return value and syntax with the help of some examples.
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
Comments