Returns a normalized value from a distribution characterized by mean and standard_dev.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 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.