Returns the skewness of a distribution, which characterizes the degree of asymmetry of a distribution around its mean.
Składnia
SKEW(number1, [number2], ...)Argumenty
number1wymagane
The first number or range of numbers for which you want to calculate skewness.
number2opcjonalne
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.