71 89 71 85 79 71 94 80 89 79 90 100 61 73 73 77 97 85 88 79 90 96 98 93 98 32 93 97 80 91 75 74 94 85 64 76 98 95 68 69 74 77 69 72 71 81 91 87 80 78\fEXCEL QUESTION A statistics instructor was interested in knowing if the assignments done by her students were preparing them adequately for upcoming tests. She collected data from a large group of students recording both their assignment grade and their test grade to see if there was any correlation between the marks. [3' marks] 3. Create the appropriate graph in Excel. Include the line of best fit and regression equation on the graph. Graphs should be complete and labeled for full marks. [3 marks] b. What is the predicted test grade for a student that received an 80% on their assignments? Express answer to 1 decimal place. [2 marks] c. Calculate and interpret the coefcient of determination. [2 marks] Assignment Grade