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:
We got the perfect example of a bell curve as the result:
Please find attached the Excel file for reference.