EXCEL SOLUTIONS ONLY

32 A math instructor believes that there is a relationship between the number of optional homework problems that the students complete during the semester and their final score for the course. To examine this relationship, the instructor gathers data (given in the following table) on the homework problems completed and the final score for the course for a randomly selected sample of 16 students. a (4 points) Develop a linear regression equation for the final course score as a function of the average number of optional homework problems completed (3 points) Forecast a final course score if the average number of bomework problems completed is b 59. C (3 points) Evaluate the goodness of fit of the regression equation by computing the values of R2, . and syx and interpret the results, Student Final score for the course Number of Completed Homework Problems 20 45 56 61 64 67 70 74 77 79 39 $2 28 47 35 NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 60 72 78 70 71 71 85 90