******please solve this Q 4-14 using excel *****

STUDENT 1 2 3 4 5 6 7 8 9 1st test grade 98 77 88 80 96 61 66 95 69 Final average 93 78 84 73 84 64 64 95 76 (a) Develop a regression model that could be used to predict the final average in the course based on the first test grade. (b) Predict the final average of a student who made an 83 on the first test. (c) Give the values of r and r for this model. Inter- pret the value of r in the context of this problem. :4-14 Using the data in Problem 4-13, test to see if there is a statistically significant relationship between the grade on the first test and the final average at the 0.05 level of significance. Use the formulas in this chapter and Appendix D