Using the accompanying Student Grades data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the model? If a student scores 79 on themidterm, what would you predict her grade on the final exam to be? Please explain with excel and table Student Midterm Final Exam
1 77 65
2 85 89
3 80 67
4 89 84
5 77 60
6 66 78
7 77 72
8 95 93
9 65 59
10 93 85
11 80 54
12 86 83
13 87 56
14 64 73
15 92 88
16 75 88
17 70 80
18 92 95
19 80 78
20 61 70
21 68 85
22 72 74
23 61 73
24 67 54
25 76 94
26 72 80
27 98 89
28 57 53
29 82 77
30 73 81
31 78 68
32 96 97
33 72 94
34 70 80
35 71 83
36 97 95
37 72 60
38 90 85
39 95 96
40 84 88
41 59 72
42 65 92
43 95 83
44 82 86
45 89 99
46 91 96
47 77 91
48 86 93
49 90 78
50 75 83
51 97 100
52 80 73
53 62 79
54 70 75
55 87 89
56 89 95