Students in a management science class have just received their grades on the midterm exam. The instructor has provided information about the midterm exam grades in some previous classes and the final average for the same students. See the Excel file Student Grade on Sakai for the data. Develop a regression model and answer the following questions.

a) Using MS Excel, develop a regression model that could predict the final average in the course based on the midterm exam grade? Clearly state the regression equation.

b) Predict a student's final average who scored 78 on the midterm exam?

c) Give the values of r and r 2 for this model. Then, interpret the value of r 2 in the context of this problem.

d) Do you believe this model is useful (at alpha 0.05) in predicting the final average? Justify your answer using the information provided in the computer output.

e) Calculate the residual for each data using the TREND function.

f) What would be the 95% final average interval for a student with 75 in the midterm exam?

File Home Insert Page Layout Formulas Data Review View Help (D PROTECTED VIEW 8e carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay terriinal Exam 1 F8 85 2 84 88 3 F8 88 4 88 84 5 F8 81 8 88 F8 F FF F3 8 84 83 8 88 88 18 82 88 11 88 53 12 8F 83 13 88 55 14 83 F2 15 82 8F 18 F5 88 1F 88 81 18 82 84 18 F8 F8 28 88 F1 21 88 84 22 F1 F4 23 81 F4 24 88 54 25 F8 84 28 F2 F8 2F 88 88 28 58 53 28 82 F8 38 F2 82 31 FF 88 32 85 88 33 F2 83 34 F1 88 35 F2 82 38 88 88 3F F2 81 38 88 84 38 84 8F 48 85 88 41 88 F2 42 88 83 43 88 84 44 83 8F 45 88 88 48 82 8F 4F F8 82 48 85 83 48 81 F8 58 F4 82 51 88 88 52 88 F2 53 82 F8 54 F8 F5 55 8F 88 58 88 85 StudGrade