Returns the skewness of a distribution, which characterizes the degree of asymmetry of a distribution around its mean.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
SKEW(number1, [number2], ...)The SKEW function measures how much a dataset deviates from a normal distribution. A positive value indicates a distribution with an asymmetric tail extending toward more positive values, while a negative value indicates a tail extending toward more negative values.
=SKEW(1, 2, 3, 4, 5, 10)結果: 1.153
Calculates the skewness for a set of numbers where the outlier 10 creates a positive skew.
A skewness of 0 indicates that the distribution is perfectly symmetrical.