This article illustrates how to create a skewed bell curve in Excel. A bell curve depicts the normal probability distribution. This name comes from the shape of the curve. A bell curve will be perfectly symmetrical if you generate it from a normal distribution. However, it can be skewed if it is generated from a skewed distribution. You will learn how to create a skewed bell curve by following this article. You will see what a skewed bell curve looks like in the picture below.
What Is a Skewed Bell Curve?
Skewed bell curves are associated with skewed distribution. For a highly skewed bell curve, the skewness will be either greater than 1 or less than -1. For a mildly skewed bell curve, the skewness will be either between -1 and -0.5 or 0.5 and 1. If the skewness is between -0.5 and 0.5, then the bell curve will be almost symmetrical. There are mainly two types of bell curves: positively and negatively skewed bell curves.
Positively Skewed Bell Curve:
It is also known as a right-skewed bell curve. If Mean > Median > Mode for a dataset, then the bell curve will be positively skewed. A positively skewed bell curve has a long tail pointing towards the right.
Negatively Skewed Bell Curve:
A negatively skewed bell curve is also called a left-skewed bell curve. If Mean < Median < Mode, then the bell curve will be negatively skewed. A negatively skewed bell curve has a long tail pointing towards the left.
How to Create a Skewed Bell Curve in Excel: Step-by-Step Procedure
Assume you have the following dataset. It contains the mark sheets of a group of students. Now you want to create a bell curve to compare the results. Then follow the steps below.
Step 1: Generate a Summary Statistics
- First, select Data >> Data Analysis as follows.
- Then, select Descriptive Statistics and click OK.
- Next, enter D5:D20 (Physics) for Input Range. Then, mark the radio button for Columns. Next, select the radio button for Output Range. Now, enter E4 for the output range. After that, check the Summary statistics. Then, click OK.
- After that, you will see the following result. You can see that the Skewness is 1.29 indicating a highly positively skewed dataset. We will need the Mean and Standard Deviation from this table to create the skewed bell curve.
Step 2: Create a Bin Range
- Now, enter the following formula in Cell F5.
=$E$5-3*$E$9
- Then, apply the following formula in cell F6 and drag the fill handle icon up to cell F10.
=F5+$E$9
Step 3: Generate a Histogram
- Next, select Data >> Data Analysis as earlier. Then, select Histogram and click OK.
- Now, enter C5:C20 and F6:F10 for the Input Range and the Bin Range Then, mark the radio button for the Output Range and enter G4 for the output range. Next, click on the OK button.
- After that, you will get the following result. Now select range G7:H11 from the histogram table.
Final Step: Insert Skewed Bell Curve
- Then, select Insert >> Insert Scatter (X, Y) or Bubble Chart >> Scatter with Smooth Lines as in the following image.
- Finally, you will get the desired skewed bell curve as shown in the following picture.
- Now, repeat the same procedures for the other set of data (Chemistry). You will get the following result.
- Then, insert a Scatter Chart with Smooth Lines as earlier. After that, you will get the following result.
Read More: Â Create a Bell Curve with Mean and Standard Deviation in Excel
Things to Remember
- You can also use the SKEW function in Excel to find the skewness of a dataset. It is always better to know the skewness of a dataset before trying to create a skewed bell curve.
- Some formulas have relative and absolute references. You need to enter them properly to avoid any erroneous results.
You can download the practice workbook from the download button below.
Conclusion
Now you know how to create a skewed bell curve in Excel. Do you have any further queries or suggestions? Then please use the comment section below for that. Stay with us and keep learning.
Hi! Thanks for the post! very usefull for me. Learned something new.
There is a little mistake in:
Next, enter D5:D20 (Physics) for Input Range. Then, mark the radio button for Columns. Next, select the radio button for Output Range. Now, enter E4 for the output range. After that, check the Summary Statistics. Then, click OK.
Here: Next, enter D5:D20 (Physics) for Input Range. It’s “C”5 and not “D” column.
Keep the good blog! Thanxs
Hello ERICH NAGY
I appreciate your time in reading the article. I’m delighted you found the information helpful and learnt something new. Your attention to detail is really appreciated, and you are correct. The appropriate range should be the C5:C20 range instead of D5:D20. An immediate correction will be made. Once again, We appreciate your comments and support. Continue reading our blog, and we aim to offer you further helpful information soon.
Regards
Lutfor Rahman Shimanto (ExcelDemy Team)
Thank you so much I was struggling with my project and you have helped me complete it.
THANK YOUUUUUUU
Dear Vivasvan,
You are most welcome. It’s great to know that our article helped you to complete your project.
Regards
Shamima Sultana
Project Manager | ExcelDemy