How to create the Bell Curve in EXCEL

To create a Bell Curve represent a normal distribution also known as a Gaussian distribution.

To do that you need four pieces of information

1. Data for which you want to plot the bell curve.
2. Normal Distribution
3. Average
4. Standard Distribution

 

Create Bell Curve in Excel

 

Step1

Put the  following labels  in column A,B,C and D

Data    Distribution  Average   Standard Deviations in the 4 columns as shown in the screenshot

Step2

Use the formula for calculating the Average as shown below. Remember that the average is just one value we simply copy it to all the cells in Column C for convenience.

 

07-May-16 5-51-02 PM

 

Step 3

Calculate the standard Deviation in Column D

use the formula for calculating the Standard Deviation as shown below. Remember that the Standard Deviation is just one value, and we simply copy it to all the cells in column D for convenience

07-May-16 10-24-51 PM

 

Step 4

Now we will calculate the Normal Distribution in column B and we would be using the values in column C(Average) and in column D(Standard Deviation) . Copy the formula to all the cells in B.

 

07-May-16 10-28-20 PM

 

Step 5

Now we have all four columns with required information

Column A – has the actual data for which we want to draw the graph, eg. weight of patience, price of a product

Column B – Normal Distribution values for each cell

Column C – has the average value  copied to all the cells in column C

Column D – has the Standard Deviation value copied to all the cells in column D

 

Draw the graph by selecting all the values in column B ( Normal Distribution values )

07-May-16 10-35-04 PM

 

 

We have our bell shaped curve ready .