Returns a normalized value from a distribution characterized by mean and standard_dev.
구문
STANDARDIZE(x, mean, standard_dev)인수
x필수
The value you want to normalize.
mean필수
The arithmetic mean of the distribution.
standard_dev필수
The standard deviation of the distribution (must be greater than 0).
The STANDARDIZE function calculates the z-score of a value based on a provided arithmetic mean and standard deviation. It is commonly used to compare data points from different distributions by placing them on a standard normal distribution scale.
=STANDARDIZE(85, 70, 10)→1.5Calculates the z-score for a value of 85 in a distribution with a mean of 70 and a standard deviation of 10.
Identify your data parameters
Determine the specific value (x), the population mean, and the standard deviation.
Enter the function
Type =STANDARDIZE(x, mean, standard_dev) into a cell, replacing the arguments with your values.
A negative result indicates that the value is below the mean.