Returns the skewness of a distribution, which characterizes the degree of asymmetry of a distribution around its mean.
구문
SKEW(number1, [number2], ...)인수
number1필수
The first number or range of numbers for which you want to calculate skewness.
number2선택
Additional numbers or ranges up to 255 arguments.
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.153Calculates the skewness for a set of numbers where the outlier 10 creates a positive skew.
Select a cell
Click on the cell where you want to display the skewness result.
Enter the formula
Type =SKEW( and select the range of cells containing your data, then close the parenthesis.
Press Enter
Press Enter to calculate the skewness value for the selected dataset.
A skewness of 0 indicates that the distribution is perfectly symmetrical.