Question

How can I create a normal distribution in excel when the only data I have is mean and standard deviation?

Answer 1

The above algorithm has the following result:

x	P(X=x)
1.9	0.003267
2	0.004432
2.1	0.005953
2.2	0.007915
2.3	0.010421
2.4	0.013583
2.5	0.017528
2.6	0.022395
2.7	0.028327
2.8	0.035475
2.9	0.043984
3	0.053991
3.1	0.065616
3.2	0.07895
3.3	0.094049
3.4	0.110921
3.5	0.129518
3.6	0.149727
3.7	0.171369
3.8	0.194186
3.9	0.217852
4	0.241971
4.1	0.266085
4.2	0.289692
4.3	0.312254
4.4	0.333225
4.5	0.352065
4.6	0.36827
4.7	0.381388
4.8	0.391043
4.9	0.396953
5	0.398942
5.1	0.396953
5.2	0.391043
5.3	0.381388
5.4	0.36827
5.5	0.352065
5.6	0.333225
5.7	0.312254
5.8	0.289692
5.9	0.266085
6	0.241971
6.1	0.217852
6.2	0.194186
6.3	0.171369
6.4	0.149727
6.5	0.129518
6.6	0.110921
6.7	0.094049
6.8	0.07895
6.9	0.065616
7	0.053991
7.1	0.043984
7.2	0.035475
7.3	0.028327
7.4	0.022395
7.5	0.017528
7.6	0.013583
7.7	0.010421
7.8	0.007915
7.9	0.005953
8	0.004432
8.1	0.003267

The graph for this sample is

Hope this was helpful. Please leave back any comment.