Why my data does not give a bell curve graph? normal distribution formulas used

[mercek]

Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ?

Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST

X	z	f(x)
490	0.9	0.029
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
482	0.0	0.043
490	0.9	0.029
490	0.9	0.029
490	0.9	0.029
466	-1.7	0.010
482	0.0	0.043
482	0.0	0.043
466	-1.7	0.010
490	0.9	0.029
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
498	1.8	0.009
482	0.0	0.043
482	0.0	0.043
498	1.8	0.009
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
498	1.8	0.009
482	0.0	0.043
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
482	0.0	0.043
506	2.6	0.001
490	0.9	0.029
482	0.0	0.043
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
466	-1.7	0.010
474	-0.8	0.030
482	0.0	0.043
498	1.8	0.009
490	0.9	0.029
474	-0.8	0.030
482	0.0	0.043
490	0.9	0.029
498	1.8	0.009
482	0.0	0.043
474	-0.8	0.030
506	2.6	0.001
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
490	0.9	0.029
474	-0.8	0.030
490	0.9	0.029
474	-0.8	0.030
466	-1.7	0.010
490	0.9	0.029
474	-0.8	0.030
466	-1.7	0.010
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
498	1.8	0.009
498	1.8	0.009
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
498	1.8	0.009
490	0.9	0.029
506	2.6	0.001
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
490	0.9	0.029
490	0.9	0.029
490	0.9	0.029
498	1.8	0.009
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
466	-1.7	0.010
498	1.8	0.009
466	-1.7	0.010
474	-0.8	0.030
490	0.9	0.029
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
458	-2.6	0.002
474	-0.8	0.030
474	-0.8	0.030
498	1.8	0.009
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
498	1.8	0.009
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
466	-1.7	0.010
474	-0.8	0.030
466	-1.7	0.010
466	-1.7	0.010
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
458	-2.6	0.002
490	0.9	0.029
498	1.8	0.009
466	-1.7	0.010
490	0.9	0.029
490	0.9	0.029
466	-1.7	0.010
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
506	2.6	0.001
482	0.0	0.043
466	-1.7	0.010
498	1.8	0.009
466	-1.7	0.010
474	-0.8	0.030
490	0.9	0.029
482	0.0	0.043
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
490	0.9	0.029
466	-1.7	0.010
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
466	-1.7	0.010
466	-1.7	0.010
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
498	1.8	0.009
498	1.8	0.009
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
466	-1.7	0.010
474	-0.8	0.030
466	-1.7	0.010
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
466	-1.7	0.010
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
498	1.8	0.009
474	-0.8	0.030
466	-1.7	0.010
474	-0.8	0.030
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
498	1.8	0.009
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
490	0.9	0.029
498	1.8	0.009
498	1.8	0.009
474	-0.8	0.030
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
474	-0.8	0.030
482	0.0	0.043
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
482	0.0	0.043
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
466	-1.7	0.010
482	0.0	0.043
482	0.0	0.043
474	-0.8	0.030
482	0.0	0.043
490	0.9	0.029
498	1.8	0.009
474	-0.8	0.030
482	0.0	0.043
466	-1.7	0.010
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
482	0.0	0.043
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
474	-0.8	0.030
482	0.0	0.043
482	0.0	0.043
466	-1.7	0.010
474	-0.8	0.030
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
498	1.8	0.009
466	-1.7	0.010
482	0.0	0.043
490	0.9	0.029
490	0.9	0.029
490	0.9	0.029
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029
482	0.0	0.043
474	-0.8	0.030
490	0.9	0.029
490	0.9	0.029

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[BrianJN1]

What are you expecting, a smooth curve?
I selected your Column A and Column C values, went to INSERT and "insert line chart". Under the recommended chart I was able to plot 7 dots according to the frequency of those data items. They formed a "bell curve".

 

[mercek]

Yes I got 7 dots to but I want to see a curve lines forming bell curve (not dots). Area or line chart did not give me that shape

 

[BrianJN1]

Yes I got 7 dots to but I want to see a curve lines forming bell curve (not dots). Area or line chart did not give me that shape

I am reasonably confident that with only 7 items of data (albeit you have multiple of each) you are only going to plot 7 dots. I do not see anything in the offerings that would allow asmooth curve.

 

[BrianJN1]

I found an instance where someone asked for a bell-curve. The answer was to use an XY scatter graph.
The method described to prepare the data was too complicated to repeat here. I can't be sure if the process would work with the data that you have but you may at least find it of some use:
https://answers.microsoft.com/en-us...-my-data/094f57c6-6442-e011-90b6-1cc1de79d2e2

 

[mercek]

Thank you! creating random points in between 7 dots can be a solution