tell me how to do this without calculator and excel. A marketing professor at Gi
ID: 3227602 • Letter: T
Question
tell me how to do this without calculator and excel.
A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter follow.
Hours Spent Studying
Total Points Earned
45
40
30
35
90
75
60
65
105
90
65
50
90
90
80
80
55
45
75
65
a. Develop an estimated regression equation showing how total points earned is related to hours spent studying.
b. Test the significance of the model with =.05.
c. Predict the total points earned by Mark Sweeney. He spent 95 hours studying.
d. Develop a 95% prediction interval for the total points earned by Mark Sweeney.
Hours Spent Studying
Total Points Earned
45
40
30
35
90
75
60
65
105
90
65
50
90
90
80
80
55
45
75
65
Explanation / Answer
a. Estimated regression equation :
Y^ = 5.847 +.8295X
b. The significance level of the model is .05. Is the model significant?
Yes it is . See the p-value is is 6.45*10^-5, which means that the model is <.05 and model is significant
c.
Y^ = 5.847 +.8295*95 = 84.6495
d.
A 95% prediction of total points earned is given in as "X Variable 1" in the uploaded regression results above
-11.98 to 25.258
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.