• Using the given Height and Weight data set, follow the steps in the weekly video or on pages 584-585 of the textbook for performing a regression analysis using Excel to analyze the Height and Weight Data set (assume height is the input variable x and weight is the output variable y).
• Once you have performed the analysis in Excel, state the correct simple linear regression equation and use the regression equation to predict the weight (in pounds) of a person who is 65 inches tall and the weight (in pounds) of a person who is 100 inches tall.
• Why might the regression equation you have found not be a good predication of the weight of someone who is 100 inches tall?
|
Height
|
Weight
|
|
67
|
125
|
|
68
|
140
|
|
67
|
142
|
|
60
|
110
|
|
64
|
97
|
|
61
|
106
|
|
79
|
210
|
|
61
|
110
|
|
71
|
150
|
|
66
|
145
|
|
59.5
|
113
|
|
71
|
175
|
|
72
|
145
|
|
55
|
110
|
|
64
|
112
|
|
65
|
135
|
|
65
|
135
|
|
71
|
140
|
|
68
|
130
|
|
71
|
152
|
|
67
|
127
|
|
70
|
143
|
|
68
|
165
|
|
72
|
160
|
|
71
|
185
|
|
65
|
114
|
|
67
|
116
|
|
66
|
113
|
|
63
|
145
|
|
62
|
116
|
|
70.5
|
155
|
|
64
|
107
|
|
64
|
104
|
|
69
|
137
|
|
75
|
200
|
|
65
|
150
|
|
67
|
140
|
|
65
|
125
|
|
75
|
240
|
|
57
|
140
|
|
68
|
135
|
|
73
|
178
|
|
68
|
122
|
|
62
|
145
|
|
68
|
190
|
|
73.5
|
180
|
|
63
|
125
|
|
72.5
|
165
|
|
66
|
115
|
|
68
|
125
|
|
72
|
210
|
|
63
|
118
|
|
65
|
135
|
|
75
|
225
|
|
69
|
145
|
|
72
|
240
|
|
69
|
170
|
|
62
|
105
|
|
64
|
125
|
|
62.5
|
130
|
|
78
|
190
|
|
63
|
115
|
|
73
|
280
|
|
69
|
125
|
|
62.5
|
120
|
|
63
|
145
|
|
63
|
132
|
|
69.5
|
195
|
|
69
|
168
|
|
70
|
160
|
|
60.5
|
105
|
|
65
|
112
|
|
72
|
215
|
|
69
|
150
|
|
70
|
150
|
|
67
|
125
|
|
64
|
135
|
|
70
|
185
|
|
71
|
127
|
|
72
|
178
|
|
66
|
123
|
|
65.5
|
145
|
|
71
|
135
|
|
68
|
135
|
|
66.5
|
145
|
|
67
|
145
|
|
69
|
193
|
|
66
|
125
|
|
71
|
148
|
|
65
|
125
|
|
62
|
120
|
|
65
|
119
|
|
68
|
160
|
|
67
|
140
|
|
62.5
|
115
|
|
64
|
125
|
|
61
|
95
|
|
62
|
126
|
|
62.5
|
165
|
|
70
|
167
|
|
73
|
250
|
|
73.5
|
280
|
|
79
|
180
|
|
71
|
175
|
|
63
|
120
|
|
72.5
|
125
|
|
69.5
|
156
|
|
75
|
185
|
|
62
|
130
|
|
67
|
140
|
|
64.5
|
120
|
|
66
|
140
|
|
69
|
155
|
|
60
|
105
|
|
67
|
125
|
|
65
|
115
|
|
66
|
130
|
|
69
|
170
|
|
73
|
247
|
|
73.5
|
172
|
|
65
|
147
|
|
67
|
160
|
|
67.5
|
160
|
|
62
|
140
|
|
64
|
120
|
|
63
|
110
|
|
65
|
115
|
|
61
|
115
|
|
73
|
165
|
|
74
|
180
|
|
72
|
182
|
|
65
|
130
|
|
73
|
160
|
|
74
|
190
|
|
75
|
180
|
|
70
|
165
|
|
62
|
140
|
|
68
|
165
|
|
57
|
125
|
|
72
|
160
|
|
66
|
128
|
|
65
|
115
|
|
63
|
135
|
|
66
|
118
|
|
74
|
130
|
|
64
|
130
|
|
67
|
140
|
|
71
|
174
|
|
60
|
118
|
|
64.5
|
133
|
|
61.5
|
107
|
|
64
|
145
|
|
66
|
150
|
|
70.5
|
165
|
|
69
|
143
|
|
70
|
155
|
|
64
|
138
|
|
62
|
147
|
|
77
|
245
|
|
62
|
130
|
|
69
|
135
|
|
70
|
150
|
|
71
|
135
|
|
71.5
|
160
|
|
67.5
|
110
|
|
69
|
155
|
|
63
|
96
|
|
65
|
140
|
|
66.5
|
120
|
|
67
|
130
|
|
73
|
155
|
|
63
|
105
|
|
73
|
160
|
|
63
|
112
|
|
68
|
125
|
|
69
|
132
|
|
69
|
175
|
|
63
|
150
|
|
64
|
105
|
|
69
|
135
|
|
63
|
134
|
|
64
|
115
|
|
63
|
123
|
|
67
|
170
|
|
71
|
162
|
|
68
|
140
|
|
64
|
115
|
|
73
|
205
|
|
67.5
|
130
|
|
67
|
145
|
|
60.5
|
125
|
|
69
|
180
|
|
65.5
|
135
|
|
64
|
140
|
|
76
|
185
|
|
64
|
135
|
|
63
|
127
|
|
62
|
115
|
|
62
|
135
|
|
70.5
|
142
|
|
67
|
140
|
|
68
|
135
|
|
71
|
178
|
|
67
|
135
|
|
64
|
127
|
|
70
|
153
|
|
62
|
110
|
|
73
|
165
|
|
79
|
165
|
|
75
|
160
|
|
71
|
170
|
|
65
|
117
|
|
69.5
|
185
|