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

mercek

New Member
Joined
Oct 27, 2017
Messages
3
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


[TABLE="width: 342"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]X[/TD]
[TD]z[/TD]
[TD]f(x)[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]506[/TD]
[TD]2.6[/TD]
[TD]0.001[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]506[/TD]
[TD]2.6[/TD]
[TD]0.001[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]506[/TD]
[TD]2.6[/TD]
[TD]0.001[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]458[/TD]
[TD]-2.6[/TD]
[TD]0.002[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]458[/TD]
[TD]-2.6[/TD]
[TD]0.002[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]506[/TD]
[TD]2.6[/TD]
[TD]0.001[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]498[/TD]
[TD]1.8[/TD]
[TD]0.009[/TD]
[/TR]
[TR]
[TD]466[/TD]
[TD]-1.7[/TD]
[TD]0.010[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]482[/TD]
[TD]0.0[/TD]
[TD]0.043[/TD]
[/TR]
[TR]
[TD]474[/TD]
[TD]-0.8[/TD]
[TD]0.030[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
[TR]
[TD]490[/TD]
[TD]0.9[/TD]
[TD]0.029[/TD]
[/TR]
</tbody>[/TABLE]
 
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".
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top