Western Sydney University The College is investigating whether there is any relationship between the student's average study minutes per day and their average % mark for the year. Sample data concerning the average study minutes per day and the average % mark of the students for the year was collected.

a) Using Excel, obtain a regression output.

b) Determine the regression equation that may be used to predict the average % mark for the year from the average study minutes per day.

c) Interpret the slope of the regression line.

d) Obtain and interpret the coefficient of determination.

Average Number of Study Minutes per Day	Average % marks for the year
17	34.4
17	31.4
19	31.8
19	46.8
21	29.2
23	26.6
28	40.6
32	42.4
34	48.8
35	29
35	56
36	52.2
39	54.8
39	56.8
39	35.8
39	42.8
41	44.2
45	33
48	58.6
50	41
54	36.8
54	54.8
55	32
56	59.2
56	51.2
56	47.2
57	47.4
58	61.6
59	43.8
64	34.8
64	60.8
64	53.8
65	38
66	53.2
67	49.4
67	40.4
72	44.4
72	42.4
75	42
76	55.2
76	58.2
77	36.4
77	43.4
77	63.4
77	43.4
77	47.4
79	46.8
79	65.8
81	46.2
83	55.6
86	52.2
87	43.4
88	63.6
90	54
90	64
90	46
94	50.8
95	40
95	52
96	60.2
97	69.4
97	55.4
98	46.6
101	56.2
104	58.8
105	43
105	54
111	72.2
113	51.6
113	46.6
116	56.2
118	70.6
123	57.6
124	55.8
124	65.8
124	49.8
125	74
125	46
126	63.2
129	48.8
130	63
130	64
134	70.8
135	60
135	71
138	56.6
144	75.8
144	60.8
147	74.4
151	71.2
151	59.2
151	72.2
155	60
158	61.6
159	73.8
160	75
165	76
165	60
165	82
165	71
167	78.4
168	72.6
169	61.8
169	62.8
171	75.2
171	62.2
172	77.4
173	84.6
173	70.6
180	64
183	62.6
183	86.6
185	74
185	82
187	80.4
188	87.6
191	69.2
191	70.2
192	79.4
195	67
196	72.2
199	71.8
200	78
201	82.2
201	69.2
204	72.8
204	77.8
206	89.2
207	73.4
208	80.6
211	92.2
213	81.6
217	81.4
218	80.6
218	90.6
218	75.6
219	75.8
219	82.8
220	73
220	79