Solutions Statistics

Using the data in the Excel file Student Grades, construct a scatter chart for midterm versus final

Question: Using the data in the Excel file Student Grades, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the regression model and R²? If a student scores 85 on the midterm, what would you estimate her grade on the final exam to be?

Student Grades

Student	Midterm	Final Exam
1	76	62
2	84	90
3	79	68
4	88	84
5	76	58
6	66	79
7	75	73
8	94	93
9	66	65
10	92	86
11	80	53
12	87	83
13	86	49
14	63	72
15	92	87
16	75	89
17	69	81
18	92	94
19	79	78
20	60	71
21	68	84
22	71	74
23	61	74
24	68	54
25	76	97
26	72	79
27	99	89
28	58	53
29	82	78
30	72	82
31	77	69
32	95	98
33	72	93
34	71	80
35	72	82
36	96	96
37	72	61
38	89	84
39	94	97
40	85	89
41	60	72
42	66	93
43	96	84
44	83	87
45	88	99
46	92	97
47	80	92
48	80	93
49	91	78
50	74	82
51	96	99
52	80	72
53	62	79
54	70	75
55	87	90
56	90	95