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
<colgroup><col span="3"></colgroup><tbody>
</tbody>
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>