Bell Curve

In this Article we will learn about the creation of Bell curve in Excel.

Let us prepare a blank Excel file with the data. We need Distribution, Average and Standard Deviation values.

 

Now we will add the formulas for the Distribution, average and standard deviation.

Distribution: =NORM.DIST(A2,$C$2,$D$2,FALSE)

Average: =AVERAGE(A2:A52)

Standard deviation: =STDEV(A2:A52)

 

Now let's plot the scatter with smooth lines and markers chart for the same:

Scatter With Smooth Lines

 

We got the perfect example of a bell curve as the result:

Bell Curve

 Please find attached the Excel file for reference.