Returns a normalized value from a distribution characterized by mean and standard_dev.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 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.