Returns the skewness of a distribution, which characterizes the degree of asymmetry of a distribution around its mean.
이 함수는 Google Sheets에서도 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.