Returns a normalized value from a distribution characterized by mean and standard_dev.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
STANDARDIZE(x, mean, standard_dev)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)Kết quả: 1.5
Calculates the z-score for a value of 85 in a distribution with a mean of 70 and a standard deviation of 10.
A negative result indicates that the value is below the mean.