How to Create Graph of Skewness and Kurtosis in Excel

Get FREE Advanced Excel Exercises with Solutions!

Symmetric datasets give us normal distribution curves, whereas asymmetric datasets give us skewed normal curves with different shapes of peaks. Asymmetric curves have non-zero skewness and kurtosis. In this article, we will show you how to create a graph of skewness and kurtosis in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


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.


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

In this article, we will demonstrate four easy steps to create a graph of skewness and kurtosis in Excel. We will use the following dataset for this purpose. The dataset contains a Student Name column and a Test Score column.

how to graph skewness and kurtosis in excel


Step 1: Create Summary Statistics Table

In the first step, we need to create a Summary Table that contains Mean, Standard Deviation, Skewness, and Kurtosis.

  • First of all, from your Data tab, go to,

Data → Analysis Data  Analysis

  • The Data Analysis pop-up box will appear. Select Descriptive Statistics from there.
  • Then click OK to open the Descriptive Statistics dialogue box.

Create Summary Statistics Table to Create Graph of Skewness and Kurtosis

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

  • Hence, the Summary Statistics table will appear in your desired cell.

Create Summary Statistics Table to Create Graph of Skewness and Kurtosis


Step 2: Calculate Bin Intervals

Now we will calculate bin intervals using the Mean and the Standard Deviation values.

  • First, insert a column named Intervals.
  • Next, select cell F5 and write down the following formula.
=$E$6-2*$E$10
  • Similarly, type formulas to cells F6 to F9 and determine Bin Intervals. All the formulas are given in the Formula column.

Create Summary Statistics Table to Create Graph of Skewness and Kurtosis

Read More: How to Calculate Skewness in Excel (2 Effective Methods)


Step 3: Determine Frequency

In this step, we will determine Frequency using the Histogram tool.

  • First, go to Data >> Data Analysis.
  • Then, select Histogram. A new dialogue box will pop up.

Determine Frequency to graph skewness and kurtosis in excel

  • In the box, select cells C5 through C20 as the Input Range.
  • Then choose cells F5 to F9 as the Bin Range.
  • Next, select Output Range to show Frequency in a specific cell and click OK.

  • Consequently, you will get the Frequency for the Bin Intervals.

Determine Frequency to graph skewness and kurtosis in excel


Step 4: Plot a Graph of Skewness and Kurtosis

Finally, it’s time to plot the graph of skewness and kurtosis. We will use the Charts tool for this purpose.

  • Firstly, select the data of Bin Intervals and Frequency.

Create Graph of Skewness and Kurtosis

  • Next, go to Insert >> Scatter and then select Scatter with Smooth Lines.

  • Finally, you will have your graph of skewness and kurtosis.

how to graph skewness and kurtosis in excel

Notes:
  • If you want to format the chart title, axis title, gridlines others, you can do this by using the Chart Design feature.

Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know how to create a graph of skewness and kurtosis in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.


Related Articles

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo