Create Normal Distribution Bell Curve

**cp41** · 11-20-2013, 04:21 PM

Hi All,

I am having a bunch of trouble trying to create a normally distributed bell curve. My data looks a little like this:

Week Data
1 4
2 3
3 3
4 1
5 1
6 4
7 5
8 10
9 3
10 6

I am having trouble working with my data, and am not sure what to do to see a normal curve.

Any help is appreciated!

Thanks!

**shg** · 11-20-2013, 04:38 PM

What does the data represent?

**shg** · 11-20-2013, 04:40 PM

	A	B	C
1	Week	Data
2	1	4
3	2	3
4	3	3
5	4	1
6	5	1
7	6	4
8	7	5
9	8	10
10	9	3
11	10	6
12
13	mean	4	B13: =AVERAGE(B2:B11)
14	SD	2.625	B14: =STDEV(B2:B11)
15
16	x	y
17	-1	0.0248	B17: =NORMDIST(A17, $B$13, $B$14, FALSE)
18	0	0.0476
19	1	0.0791
20	2	0.1137
21	3	0.1414
22	4	0.1520
23	5	0.1414
24	6	0.1137
25	7	0.0791
26	8	0.0476
27	9	0.0248