Can we infer a students score on their final exam based on how many class meetings they missed?The table below gives this information for 14 students. (Comma separated lists of the data are alsoprovided below the table to ease in copying the data to R.)Number of Missed Classes (x)0566151y=7014502: 0, 5, 6, 6, 1, 5, 1, 7, 0, 1, 4, 5, 0, 2y: 97, 76, 77, 54, 86, 51, 78, 56, 91, 86, 71, 61, 79, 70Percent Score on Final Exam (y)97767754865178569186716179701. Find the best fit line for the data.Question Help: Post to forumx2. Graph the scatter plot of the data together with the best fit line using R. (This portion of theproblem is not graded.)3. Predict the final exam score of a student who missed 2 classes.3 pts 100 Details

1 The regression analysis is conducted here by using EXCEL. The software procedure is given below:…

Can we infer a students score on their final exam based on how many class meetings they missed? The table below gives this information for 14 students. (Comma separated lists of the data are also provided below the table to ease in copying the data to R.) Number of Missed Classes (x) 0 5 66 1 5 1 7 0 1 4 5 0 2 Y T: 0, 5, 6, 6, 1, 5, 1, 7, 0, 1, 4, 5, 0, 2 y: 97, 76, 77, 54, 86, 51, 78, 56, 91, 86, 71, 61, 79, 70 1. Find the best fit line for the data. Percent Score on Final Exam (y) 97 76 77 54 86 51 78 56 91 86 71 H 61 79 70 2. Graph the scatter plot of the data together with the best fit line using R. (This portion of the problem is not graded.) 3. Predict the final exam score of a student who missed 2 classes.