ABCDEFGHIJKLMNOPQR
1
Activity: Observe the Normal Distribution with Real Data!
2
Directions: (1) Fill in the blue boxes with the formulas for the mean, sample standard deviation, minimum, and maximum for the data in grey
3
(2) After you fill in the blue boxes, the grey f(x) column will automatically populate using the normal distribution formula. Explore how the formula is setup.
4
(3) Create your own scatterplot use the height as the input and f(x) as the output.Observe the shape of the curve.
5
Height(Inches)f(x)MeanMin
6
60.61265#DIV/0!Std DevMax
7
60.8634#DIV/0!
8
61.30021#DIV/0!
9
61.4055#DIV/0!
10
61.59011#DIV/0!
11
61.8934#DIV/0!
12
61.93152#DIV/0!
13
62.01666#DIV/0!
14
62.23548#DIV/0!
Create your scatterplot below. You may want the adjust the minimum and maximum values here.
15
62.29058#DIV/0!
16
62.34907#DIV/0!
17
62.35553#DIV/0!
18
62.40403#DIV/0!
19
62.40921#DIV/0!
20
62.42388#DIV/0!
21
62.44964#DIV/0!
22
62.48643#DIV/0!
23
62.52373#DIV/0!
24
62.53019#DIV/0!
25
62.53614#DIV/0!
26
62.60611#DIV/0!
27
62.61388#DIV/0!
28
62.64242#DIV/0!
29
62.64956#DIV/0!
30
62.6568#DIV/0!
31
62.6775#DIV/0!
32
62.6827#DIV/0!
33
62.73809#DIV/0!
34
62.75039#DIV/0!
35
62.78196#DIV/0!
36
62.84458#DIV/0!
37
62.86676#DIV/0!
38
62.86795#DIV/0!
39
62.87696#DIV/0!
40
62.87732#DIV/0!
41
62.91288#DIV/0!
42
62.92771#DIV/0!
43
62.93166#DIV/0!
44
62.98619#DIV/0!
45
62.99042#DIV/0!
46
63.03599#DIV/0!
47
63.03704#DIV/0!
48
63.03853#DIV/0!
49
63.0824#DIV/0!
50
63.11944#DIV/0!
51
63.1255#DIV/0!
52
63.13165#DIV/0!
53
63.13444#DIV/0!
54
63.142#DIV/0!
55
63.14333#DIV/0!
56
63.16568#DIV/0!
57
63.19158#DIV/0!
58
63.1937#DIV/0!
59
63.19953#DIV/0!
60
63.20539#DIV/0!
61
63.22211#DIV/0!
62
63.22395#DIV/0!
63
63.23903#DIV/0!
64
63.24012#DIV/0!
65
63.25683#DIV/0!
66
63.30114#DIV/0!
67
63.30338#DIV/0!
68
63.31058#DIV/0!
69
63.32113#DIV/0!
70
63.33461#DIV/0!
71
63.3557#DIV/0!
72
63.36476#DIV/0!
73
63.37237#DIV/0!
74
63.37741#DIV/0!
75
63.38805#DIV/0!
76
63.41013#DIV/0!
77
63.42211#DIV/0!
78
63.42577#DIV/0!
79
63.44115#DIV/0!
80
63.44123#DIV/0!
81
63.44297#DIV/0!
82
63.45049#DIV/0!
83
63.45113#DIV/0!
84
63.45132#DIV/0!
85
63.45437#DIV/0!
86
63.45505#DIV/0!
87
63.46642#DIV/0!
88
63.47897#DIV/0!
89
63.48115#DIV/0!
90
63.48187#DIV/0!
91
63.48592#DIV/0!
92
63.49286#DIV/0!
93
63.50812#DIV/0!
94
63.51326#DIV/0!
95
63.52175#DIV/0!
96
63.52966#DIV/0!
97
63.53338#DIV/0!
98
63.54206#DIV/0!
99
63.54215#DIV/0!
100
63.54764#DIV/0!