Often, alpine skiers will compete in multiple events in the Canada Winter Games. Male alpine skiers who compete in the Super G and Giant Slalom event want to know if they can use their time from a Super G to predict their time in the forthcoming Giant Slalom. As sample data, we will consider the male alpine skiers who competed in the 2015 Canada Games as given in the Excel sheet Male Super G and Giant Slalom.

1. a) Construct a scatter plot of the Giant Slalom race time (dependent variable) and Super G race time (independent variable).

2. b) Find the correlation coefficient.

3. c) Findtheequationoftheregressionlineandaddittothescatterplot.

4. d) Find the coefficient of determination.

5. e) Construct a residual plot. (Hint: Using the Analysis ToolPak, go to Data Analysis,

   choose Regression, and then check the box beside Residual Plots.)

6. f) Use your results from part a), b), d) and e) to justify why the regression equation

   you found in part c) is a good model to describe the relationship between the two

   variables.

7. g) Some coaches heard that your group developed a good regression model and

   would like to make predictions for their athletes in the following situations. When appropriate, provide a prediction. When not appropriate, explain why.

   1. A male Canada Games alpine skier who finished a Super G in 73.14 seconds wants to predict his Giant Slalom race time.

   2. A male Canada Games alpine skier who finished a Super G in 52.98 seconds wants to predict his Giant Slalom race time.

   3. A female Canada Games alpine skier who finished a Super G in 56.27 seconds wants to predict her Giant Slalom race time.

Athlete Information					Super G		Giant Slalom
Games	Gender	First Name	Last Name	PT	Time	Rank	Time	Rank
2015	Male	Declan	McCormack	ON	00:50.97	1	N/A	N/A
2015	Male	Cam	McGregor	ON	00:51.46	2	N/A	N/A
2015	Male	Will	Kornya	ON	00:51.55	3	02:08.86	8
2015	Male	Griffin	Copp	ON	00:51.86	4	N/A	N/A
2015	Male	Kasper	Woolley	BC	00:52.03	5	02:09.31	9
2015	Male	Asher Alexander	Jordan	BC	00:52.15	6	02:08.16	4
2015	Male	Alexander David	Valentin	BC	00:52.17	7	N/A	N/A
2015	Male	Liam	Haynes	AB	00:52.46	8	02:08.63	6
2015	Male	Kyle	Alexander	BC	00:52.90	9	N/A	N/A
2015	Male	Zachary	Mayne	ON	00:53.02	10	02:10.72	13
2015	Male	Benjamn	Mathieu	QC	00:53.11	11	02:08.56	5
2015	Male	Hunter	Watson	ON	00:53.32	12	02:08.71	7
2015	Male	Liam	Wallace	AB	00:53.40	13	02:04.63	1
2015	Male	Kelvin	Cochrane	AB	00:53.47	14	02:13.06	15
2015	Male	Jay	Toots	QC	00:53.48	15	N/A	N/A
2015	Male	Quentin	Roy-Foster	QC	00:53.54	16	DNL	DNL
2015	Male	Jamie	Casselman	AB	00:53.89	17	02:09.31	10
2015	Male	Gavin	Donald	BC	00:53.90	18	DNL	DNL
2015	Male	Ryan Westover	Finley	BC	00:54.03	19	N/A	N/A
2015	Male	Evan	Ross	NS	00:54.09	20	02:09.79	11
2015	Male	Cody	Monod	AB	00:54.24	21	02:08.11	3
2015	Male	Adrien	Grabinski	AB	00:54.31	22	02:07.98	2
2015	Male	Louis-Phillipe	Noel	QC	00:54.48	23	N/A	N/A
2015	Male	Stephen Cameron	Magee	NB	00:54.55	24	N/A	N/A
2015	Male	Caeden	Carruthers	NB	00:54.70	25	02:24.44	26
2015	Male	Vincent	Tarte	QC	00:54.92	26	02:14.04	17
2015	Male	Frederic	Verret	NB	00:55.30	27	N/A	N/A
2015	Male	Dawson mead	Hill	AB	00:55.38	28	02:11.35	14
2015	Male	JD	Todd	NS	00:54.09	29	02:18.21	20
2015	Male	Ian	Morrison	NB	00:55.97	30	02:18.25	21
2015	Male	Connor	Keefe	NS	00:56.06	31	DNL	DNL
2015	Male	Jacob	King	MB	00:56.12	32	DNL	DNL
2015	Male	Ian	Keefe	NS	00:56.29	33	02:23.95	25
2015	Male	Devin	McAllister	SK	00:56.58	34	N/A	N/A
2015	Male	Walter	Teague	NB	00:56.73	35	02:25.12	27
2015	Male	Devin	Mittertreiner	BC	00:56.78	36	02:18.46	22
2015	Male	Camden	Sutherland	NB	00:56.18	37	02:18.60	23
2015	Male	Olivier	Paradis	QC	00:56.90	38	02:10.53	12
2015	Male	Eli	Klassen	SK	00:57.16	39	02:25.89	29
2015	Male	Jack	Dunlop	MB	00:57.70	40	N/A	N/A
2015	Male	Blaise	Cunnigham	MB	00:57.88	41	N/A	N/A
2015	Male	Louis	Lacoursiere	SK	00:58.40	42	N/A	N/A
2015	Male	Cole	Myers	NS	00:58.51	43	02:25.61	28
2015	Male	Brandyn	Cooke	NB	00:59.32	44	02:21.03	24
2015	Male	Garrett	Musgrave	SK	00:59.43	45	02:35.05	32
2015	Male	Micheal	Copp	MB	00:59.80	46	02:32.32	30
2015	Male	Jack	Morse	PE	01:01.19	47	N/A	N/A
2015	Male	Kyle	Simmons	NL	01:01.38	48	02:36.77	34
2015	Male	Owen	Tuner	PE	01:01.65	49	N/A	N/A
2015	Male	Jack	Healey	MB	01:03.21	50	N/A	N/A
2015	Male	Rhett	Regnier	SK	01:03.32	51	02:36.49	33
2015	Male	Kyle	Barrington	NS	01:03.53	52	02:39.08	36
2015	Male	Alex	Woolfrey	NL	01:03.65	53	N/A	N/A
2015	Male	Mitchell	Harris	SK	01:03.80	54	02:39.53	37
2015	Male	Nicholas	Friesen	MB	01:03.94	55	N/A	N/A
2015	Male	Neill	Telles-Langdon	MB	01:04.72	56	02:45.95	38
2015	Male	Erik	Kuhune	NL	01:05.00	57	N/A	N/A
2015	Male	Jack	Diehl	SK	01:06.05	58	N/A	N/A
2015	Male	Patrick	Hadlaw	NS	01:07.18	59	02:38.68	35