gldtkn77gary
New Member
- Joined
- Dec 9, 2003
- Messages
- 3
Can anyone help me find the correct formula for creating a standard normal distribution chart to look like a bell-shaped curve?
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | data | normaldistribution | ||||
2 | 1 | 0.004886 | ||||
3 | 3 | 0.005864 | ||||
4 | 6 | 0.007542 | ||||
5 | 7 | 0.008153 | ||||
6 | 9 | 0.009443 | ||||
7 | 10 | 0.010118 | ||||
8 | 10 | 0.010118 | ||||
9 | 12 | 0.011511 | ||||
10 | 26 | 0.020358 | ||||
11 | 26 | 0.020358 | ||||
12 | 27 | 0.020736 | ||||
13 | 29 | 0.021323 | ||||
14 | 31 | 0.021667 | ||||
15 | 34 | 0.021704 | ||||
16 | 37 | 0.021166 | ||||
17 | 41 | 0.019635 | ||||
18 | 42 | 0.019127 | ||||
19 | 42 | 0.019127 | ||||
20 | 42 | 0.019127 | ||||
21 | 46 | 0.016719 | ||||
22 | 47 | 0.016046 | ||||
23 | 48 | 0.015354 | ||||
24 | 48 | 0.015354 | ||||
25 | 48 | 0.015354 | ||||
26 | 51 | 0.013215 | ||||
27 | 55 | 0.010378 | ||||
28 | 55 | 0.010378 | ||||
29 | 57 | 0.009034 | ||||
30 | 58 | 0.008391 | ||||
Sheet1 |