How to Create Graph of Skewness and Kurtosis in Excel

Introduction to Skewness and Kurtosis

Skewness

Skewness is a measure of the level of asymmetry in the distribution of a dataset. When a dataset is not distributed symmetrically, skewness is observed in the normal curve. An asymmetric normal curve can be positively or negatively skewed.

Kurtosis

Kurtosis is the measure of tailedness in a normal distribution curve. It can help us find the outliers in a dataset. Based on the shape of the peak and tail, it can be platykurtic, mesokurtic, or leptokurtic.

How to Create a Graph of Skewness and Kurtosis in Excel: 4 Easy Steps

We will use the following dataset for this purpose, which contains a Student Name column and a Test Score column.

Step 1 – Create a Summary Statistics Table

Go to Data and select Data Analysis.

The Data Analysis pop-up box will appear. Select Descriptive Statistics.
Click OK to open the Descriptive Statistics dialog box.

Select the Input range (Test Score) from cells C5 through C20.
Select the Columns and the Output Range.
In the Output Range, select the cell where you want your Summary Statistics table to appear.
Check the box Summary Statistics and click OK.

The Summary Statistics table will appear in your desired cell, including the skewness and kurtosis values.

Step 2 – Calculate Bin Intervals

Insert a column named Intervals.
Select cell F5 and use the following formula.

=$E$6-2*$E$10

Use similar formulas to cells F6 to F9 and determine Bin Intervals. All the formulas are given in the Formula column. They’re created by modifying the constant that’s multiplying E10 from -2 to 2.