Calculating skewness

In this Excel tutorial you will teach yourself what the skewness is and how to calculate skewness in Excel application.

Skewness is the statistics by which you define asymmetry in the distribution of the analyzed variable. With skewness you'll see how the results of your variable shape around the average. If their distribution is similar to the normal distribution (skewness equals to 0) or whether you can deal with the distribution positively skewed (skewness > 0) or negatively skewed (skewness <0).

To calculate a skewness in Excel please prepare some data table.

Skewness data table

Excel provides SKEW function. Syntax is:

=SKEW(number1, [number2], ...)

In this example formula is: =SKEW(B2:B13)

Skewness formula

Skewness here is strongly above 0 (skewness > 0) what means that it is a right-sided asymmetry. The conclusion is that for many of months, sales was significantly lower than the average sales.

Excel really helps you with statistics. Hopely now you can see that.