Returns a normalized value from a distribution characterized by mean and standard_dev.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: 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.