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.
how to find coefficient and se coefficient without calculator and excel?