A B C D E F G H J K L M N P Hours of Final 1 study Grade 2 3 38.75 3 4 49.05 4 2 50 5 3 53 6 14 89.93 7 11 86.95 8 8 76.47 9 12 80.27 10 16 90.28 11 2 35.5 12 5 60.49 13 2 39.91 14 18 95.38 15 12 69.775 16 12 78.779 17 8 51.445 Data represented here is showing the Hours of study for a group of studnets and the grades they achieved on their test after the study. Using the linear regression at 0.02 significant level, model the Final Grade as a function of the Hours of study and answer the following questions: (10 marks) 1) What is the slope and how do you interpret it in the content of this problem? (5 marks) 2) What is the intercept and how do you interpret it in the content of this problem? (5 marks) 3) Is the linear relationship significant? How do you know? (2.5 marks) 4) Report and interpret the correlation coefficient. (5 marks) 5) Report and interpret the coefficient of determination. (5 marks) 6) Double-check the normality of the residual values using the Q-Q plot. (10 marks) 7) Based on what you see in the residual analysis, is this data linear? Briefly explain. (5 marks) 18 12 86.8 19 6 55.964 8) What is your prediction on a grade of a student who has studied 10 hours for this test? (2.5 marks) 20 7 68.677 21 8 56.558 22 61.965 A B C D E F G H | J K L M N 21 22 23 00 00 00 8 56.558 8 61.865 8 59.045 24 8 78.784 25 4 58.057 26 14 85.95 27 18 87.65 28 1 35.25 29 12 28.5 30 15 95.5 31 1 30 32 3 51.19 33 3 46 34 8 67.617 35 3 51.879 36 20 100 37 9 54.27 38 11 67.887 39 12 79.84 40 14 86.75 41 0 30 42 13 90 12 15 92 Sheet1 Sheet2 A B D E F G H J K L M N 42 13 90 43 15 92 44 16 98 45 15 91 46 12 85.65 47 7 59.45 48 8 66.051 49 9 69.055 50 14 85.25 51 20 90 52 1 45 53 19 89.95 54 5 61.065 55 20 97 56 6 55 57 13 67.957 58 6 62 59 12 78 60 5 58.1 61 7 55.54 62 7 78.555 63 6 56.049 61 070 Sheet1 Sheet2 + A B D E F G H | J K 63 60 56.049 64 8 64.079 65 3 47.18 66 11 86.9 67 8 65 68 0 36 69 12 75 70 2 49 71 0 28 72 18 86.76 73 12 71.805 74 13 67 75 12 69.68 76 2 55.78 77 4 56.575 78 15 88.12 79 12 78.5 80 14 82 81 16 82 82 2 50 83 13 68 84 12 78.55 05 10 < Sheet1 Sheet2 + A B C D E F G H J K L M 84 12 78.55 85 18 93 86 6 62.25 87 88 89 90 6300 58.9 47.5 11 66.5 8 67.28 91 15 86.12 92 1 40 93 2 49 94 18 92.65 95 5 65.858 96 14 81.47 97 12 89.95 98 4 59.746 99 7 75.76 100 101 102 103 104 105 106 Sheet1 Sheet2 G