Question

How do i create a normal distribution curve in excel?

Answer 1

On the Tools menu, click Data Analysis.
In the Analysis Tools box, click Random Number Generation, and then click OK.
In the Number of Variables box, type 1.
In the Number of Random Numbers box, type 2000.

NOTE: Varying this number will increase or decrease the accuracy of the bell curve.
In the Distribution box, select Normal.
In the Parameters pane, enter the number calculated in cell B2 (29 in the example) in the Mean box.
In the Standard Deviation box enter the number calculated in cell B4 (14.68722).
Leave the Random Seed box blank.
In the Output Options pane, click Output Range.
Type D2 in the Output Range box.

This will generate 2,000 random numbers that fit in a normal distribution.
Click OK.

To create a histogram for the random data, follow these steps:
On the Tools menu, click Data Analysis.
In the Analysis Tools box, select Histogram, and then click OK.
In the Input Range box, type D2:D2001.
In the Bin Range box, type C2:C8.
In the Output Options pane, click Output Range.
Type E2 in the Output Range box.
Click OK.
To create a histogram for the original data, follow these steps:
On the Tools menu, click Data Analysis.
Click Histogram, and then click OK.
In the Input Range box, type A2:A9.
In the Bin Range box, type C2:C8.
In the Output Options pane, click Output Range.
Type G2 in the Output Range box.
Click OK.
Create labels for the legend in the chart by entering the following:
E14: =G1&"-"&G2
E15: =E1&"-"&F2
E16: =G1&"-"&H2

Select the range of cells, E2:H10, on the worksheet.
On the Insert menu, click Chart.
Under Chart type, click XY (Scatter).
Under Chart sub-type, in the middle row, click the chart on the right.

NOTE: Just below these 5 sub-types, the description will say "Scatter with data points connected by smoothed lines without markers."
Click Next.
Click the Series tab.
In the Name box, delete the cell reference, and then select cell E15.
In the X Values box, delete the range reference, and then select the range E3:E10.
In the Y Values box, delete the range reference, and then select the range F3:F10.
Click Add to add another series.
Click the Name box, and then select cell E14.
Click the X Values box, and then select the range E3:E10.
In the Y Values box, delete the value that's there, and then select the range G3:G10.
Click Add to add another series.
Click the Name box, and then select cell E16.
Click the X Values box, and then select the range E3:E10.
Click the Y Values box, delete the value that's there, and then select the range H3:H10.
Click Finish.

The chart will have two curved series and a flat series along the x-axis.
Double-click the second series; it should be labeled "- Bin" in the legend.
In the Format Data Series dialog box, click the Axis tab.
Click Secondary Axis, and then click OK.
You now have a chart that compares a given data set to a bell curve.

Answer 2

@debweiss try this file.

Answer 3

has this helped?