Based on the results from task 2, what percent of variability in the final grade can be explained by the midterm grade? Please round it to the nearest one percent. Choice 1 of 4:55% Choice 2 of 4:23% Choice 3 of 4:29% Choice 4 of 4:32%; Midterm Final Exam 76 65 84 90 79 68 88 84 76 61 66 79 77 73 94 93 66 60 92 86 80 53 87 83 86 55 63 72 92 87 75 89 69 81 92 94 79 78 60 71 68 84 71 74 61 74 68 54 76 94 72 79 99 89 58 53 82 78 72 82 77 69 95 98 72 93 71 80 72 82 96 96 72 61 89 84 94 97 85 89 60 72 66 93 96 84 83 87 88 99 92 97 78 92 85 93 91 78 74 82 96 99 80 72 62 79 70 75 87 90 89 95; Using the data in the Excel file, apply the Excel Regression tool, using the midterm grade as the independent variable and the final exam grade as the dependent variable. Please also analyze the residuals