The following article Taimienphi.vn introduces you to STANDARDIZE function in Excel, this is one of the functions in the statistical function group that many people use when working with Excel.
STANDARDIZE Excel is a calculation function that helps you produce normalized results from a distribution characterized by the Mean and Standard_Dev arguments.
STANDARDIZE function in Excel
How to use STANDARDIZE function in Excel
1. Description and syntax used
This is the function that returns the normalized value from a distribution characterized by the Mean and Standard_Dev arguments.
STANDARDIZE (x, mean, standard_dev)
– X: The value you want to normalize, is a required parameter.
– Mean: Arithmetic mean of distribution, is a required parameter.
– Standard_Dev: Standard deviation of the distribution, is a required parameter.
– If Standard_Dev ≤ 0 -> the function returns an error value #NUM!
– The equation for the normalized value is:
2. Examples of specific situations
Suppose you need to calculate the normalized values of values in the following data table:
Step 1: Calculate the normalized value of 49. In the cell to calculate, enter the formula: = STANDARDIZE (C3, C5, C6)
Step 2: Press Enter -> normalized value of 49 was:
Step 3: Calculate the normalized value of -49. In the cell to calculate, enter the formula: = STANDARDIZE (C4, C5, C6)
You press Enter -> Normalized value of -49 was:
Where the standard deviation of the distribution is less than or equal to 0 -> the function returns the error value #NUM!
Above are instructions and some specific examples when you use STANDARDIZE function in Excel. With this function, you remember the syntax is STANDARDIZE (X, Mean, Standard_Dev), Inside X is the value to be standardized, Mean is the arithmetic mean of the distribution, also Standard_Dev is the standard deviation of the distribution. Good luck!
The IF function is a commonly used conditional function with its versatility, and the way the IF function is used makes it easy to use the Excel function. See more about How to use the IF function through tips on Taimienphi.vn friends.