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.