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 .

## 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

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

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

Step2Use 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 3Calculate 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 4Now 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 5Now 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 .

No related posts.