Skewness is a basic statistical concept. Sometimes, you may need to calculate the skewness in Excel. So, if you are looking for how to calculate the skewness in Excel then you have come to the right place. Today, I will demonstrate how to calculate the skewness in Excel.
Furthermore, for conducting the session, I will use Microsoft 365 version.
Download Practice Workbook
You can download the practice workbook from here:
What Is Skewness in Statistics?
The skewness of an ideal symmetric probability distribution, also known as the poison’s distribution curve, is its asymmetry. It is a fundamental statistical concept. The skewness of the poison’s distribution curve, also known as the normal distribution, is 0. This means that the normal distribution curve is symmetrical.
Despite the fact that no practical probability distribution is perfectly symmetrical. They do, however, have a skewness that is close to zero.
Any deviation from the normal distribution has some skewness values.
2 Effective Methods to Calculate Skewness in Excel
Here, I will describe 2 suitable methods to calculate skewness in Excel. Also, for your better understanding, I’m going to use sample data that has 2 columns. Those are Student’s Name and Mathematics Score. The dataset is given below.
1. Use Excel SKEW Function to Compute Skewness
You can use a built-in Excel function to calculate the skewness in Excel. Which is known as the SKEW function. Furthermore, this is the easiest and simple way to find out the skewness in Excel. Now, let’s follow the steps.
- Firstly, you must select a new cell E10 where you want to keep the skewness.
- Secondly, you should use the formula given below in the E10 cell.
Here, in this formula, the SKEW function will return the skewness. Where C5:C18 is the number range.
- Subsequently, press ENTER, and you will get the skewness.
Read More: How to Calculate Coefficient of Skewness in Excel
2. Apply Data Analysis ToolPak to Find Skewness in Excel
You can apply the Data Analysis ToolPak to calculate skewness in Excel. Firstly, you have to check whether your Excel Custom Ribbon is the Data Analysis ToolPak visible or not. If the Data Analysis ToolPak is invisible then you should follow Step-1. Otherwise, you may follow from Step-2.
Step 1: Insert Data Analysis ToolPak
Here, I will show how to insert Data Analysis ToolPak in Excel.
- Firstly, you have to go to the File tab.
At this time, you will see the following window.
- Now, from that window, you should choose the Options menu.
Consequently, a dialog box named Excel Options will appear.
- Firstly, from that dialog box, you have to go to the Add-ins command.
- Secondly, choose Excel Add-ins in the Manage: box.
- Finally, press the Go button.
At this time, another dialog box named Add-ins will appear.
- Now, you need to click on the Analysis ToolPak.
- Then, press OK to get the changes.
- Lastly, you will see that there is a new ribbon named Data Analysis under the Data tab.
Step 2: Use Descriptive Statistics Feature from Data Analysis ToolPak
In this section, I will demonstrate how to use the Descriptive Statistics feature for the calculation of skewness with the help of the Data Analysis ToolPak in Excel.
- Firstly, from the Data tab >> go to the Data Analysis ribbon.
At this time, a dialog box named Data Analysis will appear.
- Now, select Descriptive Statistics and then Click on OK.
Subsequently, a new dialog box named Descriptive Statistics will appear.
- Firstly, select the data range in the Input Range: box for which you want to do the descriptive statistics. Here, I have selected the range C4:C18.
- Secondly, mark the Labels in first row option.
- After that, choose the cell in the Output Range: box where you want to see the result. Here, I have chosen the D4 cell.
- Then, you must mark the Summary statistics option.
- Finally, press OK to get the result.
At this time, you will see the following output. Where you will find the skewness.
Now, I will do formatting to the output. In addition, you can do the formatting according to your preference. Also, this is not a mandatory term.
- Firstly, select the data range.
- Secondly, from the Home tab >> you may select the All Borders option >> then you may increase the Font Size >> then you may choose Center and Middle Alignment.
- After that, select D4:E4.
- Then, from the Home tab >> I increase the Font Size >> then I change the Fill Color >> then Bold it.
Finally, you will see the following formatted result. Additionally, I have marked the Skewness with Fill Color (Green, Accent 6, Lighter 60%).
Read More: How to Calculate Standard Error of Skewness in Excel
Now, you can practice the explained method by yourself.
I hope you found this article helpful. Here, I have explained 2 suitable methods for how to calculate the Skewness in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.