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
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.
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
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.
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 )
We have our bell shaped curve ready .