A marketing professor is interested in the relationship between hours spent studying and total points earned in a course. The following is the data collected from 8 students. Please collect data for another 2 students and answer the questions based on the dataset including 10 students.

Hours Spent Studying. Total Points Earned

45 40

30 35

90 75

60 65

105 90

65 50

90 90

80 80

___ ___

___ ___

1. develop an estimated regression equation showing how total points earned is related to hours spent studying.
2. test the significance of the model with alpha = .05.
3. predict the total points earned by Mark Sweeney. He spent 78 hours studying.
4. develop a 95% prediction interval for the total points earned by Mark Sweeney.

Please do not get the answer from another website.