Buzz
STANDARDIZE is an Excel computational function that yields standardized values from a distribution characterized by Mean and Standard_Dev parameters.
Excel's STANDARDIZE Function
Using the STANDARDIZE Function in Excel
1. Description and Syntax
This function returns standardized values from a distribution characterized by Mean and Standard_Dev parameters.
Syntax:
STANDARDIZE(x, mean, standard_dev)
Where:
- X: Value to be standardized, a required parameter.
- Mean: Arithmetic mean of the distribution, a required parameter.
- Standard_Dev: Standard deviation of the distribution, a required parameter.
Note:
- If Standard_Dev ≤ 0 -> the function returns an error value #NUM!
- The equation for standardization value is:
2. Specific Scenario Examples
Suppose you need to calculate the standardized values of the data in the table below:
Step 1: Calculate the standardized value of 49. In the cell where you want to calculate, input the formula: =STANDARDIZE(C3,C5,C6)
Step 2: Press Enter -> the standardized value of 49 is:
Step 3: Calculate the standardized value of -49. In the cell where you want to calculate, input the formula: =STANDARDIZE(C4,C5,C6)
Press Enter -> The standardized value of -49 is:
In cases where the standard deviation of the distribution is less than or equal to 0 -> the function returns an error value #NUM!
Above is the guide and some specific examples when you use the STANDARDIZE Function in Excel. With this function, remember the syntax is STANDARDIZE(X, Mean, Standard_Dev), where X is the value to be standardized, Mean is the arithmetic mean of the distribution, and Standard_Dev is the standard deviation of the distribution. Wish you success!
The IF function is a widely used conditional function with its versatility, knowing how to use the IF function will make using Excel functions incredibly easy and useful. Learn more about the IF function in Excel through the technical article on Mytour. Happy learning!
