Site icon Best Excel Tutorial

How to Calculate Skewness in Excel

In this Excel tutorial lesson, you will learn what skewness is and how to calculate skewness in Excel application.

To find the skewness in Excel, please prepare some data tables.

Calculate Skewness using the SKEW function

Excel provides a SKEW function. Syntax is:

=SKEW(number1, [number2], …)

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

A skewness value significantly greater than 0 (skewness > 0) indicates right-skewed (positively skewed) data. In this sales example, it suggests that sales were often significantly lower than the average. A positive skewness indicates that the distribution of sales data has a longer tail on the right side. This suggests that while there might be a few months with very high sales, the majority of months experienced sales below the average.

Calculate Skewness using Data Analysis ToolPak Add-In

First, you need to make sure your Data Analysis Toolpak Add-In is installed. Here is the lesson on how to install Data Analysis Toolpak Add-In.

Go to Ribbon to the Data tab. Click the Data Analysis button.

A new window appears. Choose Descriptive Statistics and click OK.

Enter the proper parameters:

And this is how you see my statistics summary. Skewness is calculated in row 10. The result is the same as in Example 1 where we checked how to calculate Skewness using the SKEW Excel function.

While the formula 3 * (MeanMedian) / Standard Deviation (Pearson’s coefficient) approximates skewness, Excel’s SKEW function provides a more accurate calculation. The SKEW function and the Data Analysis ToolPak use a different formula involving the third moment, which is the standard method for calculating sample skewness. Therefore, while the Pearson coefficient can give a rough idea, the SKEW function is the preferred and more precise way to calculate sample skewness in Excel.

Exit mobile version