estimate the following linear formulation using the table below: Y = a + b X and
ID: 3153737 • Letter: E
Question
estimate the following linear formulation using the table below:
Y = a + b X
and please use the estimated model to predict the value of Y when X is 50.
Y
X
161
46
205
63
301
97
115
30
251
81
89
25
290
94
159
52
46
21
259
88
212
64
301
98
174
54
149
42
130
42
249
79
297
95
229
66
109
59
129
47
212
65
200
67
180
57
303
97
231
73
225
71
138
42
138
42
270
86
192
60
Question 2 options:
157.37
155.25
158.39
151.95
Y
X
161
46
205
63
301
97
115
30
251
81
89
25
290
94
159
52
46
21
259
88
212
64
301
98
174
54
149
42
130
42
249
79
297
95
229
66
109
59
129
47
212
65
200
67
180
57
303
97
231
73
225
71
138
42
138
42
270
86
192
60
Explanation / Answer
Th regression equation is
y=a+bx
from Excel
The fitted Regression equation is
y=5.63+3.035(x)
when x=50
y=5.63+3.035(50)
y=157.37
SUMMARY OUTPUT Regression Statistics Multiple R 0.968091418 R Square 0.937200994 Adjusted R Square 0.934958173 Standard Error 17.76121161 Observations 30 ANOVA df SS MS F Significance F Regression 1 131820.5688 131820.6 417.8669 2.29E-18 Residual 28 8832.897865 315.4606 Total 29 140653.4667 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 5.630012506 9.959817308 0.565273 0.57639 -14.7717 26.03177 -14.7717 26.03177 X 3.034734432 0.148457345 20.44179 2.29E-18 2.730633 3.338836 2.730633 3.338836Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.