Returns a normalized value from a distribution characterized by mean and standard_dev.
この関数は Google スプレッドシートでも 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.