Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Bell Curve How to Create A Bell Curve – Excelchat

How to Create A Bell Curve – Excelchat

We can create a bell curve, also called the normal probability distribution curve to show probable events. The highest point of the bell curve is called the highest probability of occurrence, and the occurrence goes down to either side of the curve. We can use bell curves to evaluate exam grades or employee performance appraisals. In this tutorial, we will learn how to make a bell curve and save as a blank bell curve template.  

Figure 1 – How to make a bell curve

Creating a Bell Curve in Excel 

  • In a blank workbook, we will enter the following column headers, as shown in the figure below.

Figure 2 – Column headers for distribution table in Excel 

  • Next, in Column A, we will enter the data as shown in figure 3

Figure 3 – Data for normal distribution function in Excel

  • In Column C (Average), we will enter the formula below in Cell C4 and press the enter key
    =AVERAGE(A4:A21)

Figure 4 – Calculating Average for a bell curve 

  • In Column D (Standard Deviation), we will enter the formula below in Cell D4 and press the enter key.
    =STDEV(A4:A21)

Figure 5 – Calculating Standard Deviation for creating a bell curve in Excel

  • Now, we will go back to Cell B4, enter the formula below and press enter
    =NORM.DIST(A4,$C$4,$D$4,FALSE)  – Excel 2010, 2013 and 2016
    =NORMDIST(A4,$C$4,$D$4,FALSE)  – Excel 2007

Figure 6 – Norm Distribution Function

  • Now, we will drag the formula in Cell B2 down the column.

Figure 7 – Normal Distribution function 

  • We will highlight the range A4:B21(Data Column and Distribution Column)
  • We will click on Insert and select Scatter (In Excel 2013, we will choose Scatter and Doughnut chart in Excel) and select Scatter with Smooth Lines and Markers

Figure 8 – Bell Curve on Excel 

  • Our Bell curve chart will look like this

Figure 9 – Creating a bell curve in Excel 

Making a Blank Bell Curve Template

We call also save Bell Curve chart as a normal chart template so we can use it for future calculations by following these steps:

     1. To save;

 

  • In Excel 2013 or 2016, we will right click on the Bell curve chart, and select Save as Template.

 

     2. In Excel 2010 and 2007, we will click on the Bell curve chart to activate the Chart Tools. Next, we will go to Design and click on Save As Template

Figure 10 – Creating a Bell curve template

     3. In the Save Chart Template Dialog box, we will enter the name we wish for our template in the File name box and select the Save Button.

Figure 11 – Creating a blank bell curve template

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc