In this Article we will learn about the creation of Bell curve in Excel.
Now we will add the formulas for the Distribution, average and standard deviation.
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.