please answer all questions E-G

Alpine Skiing Events Alpine skiing has been part of the Canada Winter Games since the inaugural Games in 1967 in Quebec City. Alpine skiing has always featured both Men's and Women's competition and has offered events for athletes with a disability since the 2011 Canada Games in Halifax Slalom Giant Slalom Super G An athlete skis between An athlete skis between An athlete skis between gates that are spaced gates that are spaced the most widely set gates closest together of the further apart than the gates and the minimum vertical three events. There is a in Slalom. The minimum drop is 250 m. Super G, minimum vertical drop of vertical drop is 200 m. also known as Super Giant 120 m. Regarded as a Giant Slalom is a technical Slalom, is regarded as a technical event, Slalom is event that requires quick, speed event. Skiers requires quick, short turns. short turns. The skier's complete one run for their The combined time of two final score is the total time final score. runs is the skier's final to finish two runs. score. Data To make computations more manageable, all times should to be converted from their current format of mm:ss.00 to seconds.00. For example, to convert a time of 01:39.15 in cell H2, click on an empty cell and type =H2*60*60*24 in the home tab, change the Number Format of that cell from "Custom" to "General". The time of 01:39.15 is now converted to 99.15 seconds. When providing times in your report, express times in the mm:ss.00 format. Unless stated otherwise in the question, omit athletes with incomplete race times from analysis. e) Construct a residual plot. (Hint: Using the Analysis ToolPak, go to Data Analysis, choose "Regression", and then check the box beside "Residual Plots".) 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. 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. i. A male Canada Games alpine skier who finished a Super G in 73.14 seconds wants to predict his Giant Slalom race time. ii. A male Canada Games alpine skier who finished a Super G in 52.98 seconds wants to predict his Giant Slalom race time. iii. A female Canada Games alpine skier who finished a Super G in 56.27 seconds wants to predict her Giant Slalom race time. E G PT ON ON ON ON BC BC BC AB BC ON QC ON AB AB A B 1 2 Games Gender 3 2015 Male 4 2015 Male 5 2015 Male 6 2015 Male 7 2015 Male 8 2015 Male 9 2015 Male 10 2015 Male 11 2015 Male 12 2015 Male 13 2015 Male 14 2015 Male 15 2015 Male 16 2015 Male 17 2015 Male 18 2015 Male 19 2015 Male 20 2015 Male 21 2015 Male 22 2015 Male 23 2015 Male 24 2015 Male 25 2015 Male 26 2015 Male 27 2015 Male 28 2015 Male 2015 Male 30 2015 Male 31 2015 Male 32 2015 Male 33 2015 Male 34 2015 Male 35 2015 Male 36 2015 Male D Athlete Information First Name Last Name Declan McCormack Cam McGregor Will Kornya Griffin Copp Kasper Woolley Asher Alexander Jordan Alexander David Valentin Liam Haynes Kyle Alexander Zachary Mayne Benjamn Mathieu Hunter Watson Liam Wallace Kelvin Cochrane Jay Toots Quentin Roy-Foster Jamie Casselman Gavin Donald Ryan Westover Finley Evan Ross Cody Monod Adrien Grabinski Louis-Phillipe Noel Stephen Cameron Magee Caeden Carruthers Vincent Tarte Frederic Verret Dawson mead Hill JD Todd lan Morrison Connor Keefe Jacob King lan Keefe Devin McAllister QC QC AB BC BC NS AB AB QC NB NB QC NB AB NS NB F H Super G Giant Slalom Time Rank Time Rank 00:50.97 1 N/A NA 00:51.46 2 N/A N/A 00:51.55 3 02:08.86 8 00:51.86 4 N/A N/A 00:52.03 5 02:09.31 9 00:52.15 6 02:08.16 4 00:52.17 7 N/A N/A 00:52.46 8 02:08.63 6 00:52.90 9 N/A N/A 00:53.02 10 02:10.72 13 00:53.11 11 02:08.56 5 00:53.32 12 02:08.71 7 00:53.40 13 02:04.63 1 00:53.47 14 02:13.06 15 00:53.48 15 N/A N/A 00:53.54 16 DNL DNL 00:53.89 17 02:09.31 10 00:53.90 18 DNL DNL 00:54.03 19 N/A N/A 00:54.09 20 02:09.79 11 00:54.24 21 02:08.11 3 00:54.31 22 02:07.98 2 00:54.48 23 N/A N/A 00:54.55 24 N/A N/A 00:54.70 25 02:24.44 26 00:54.92 26 02:14.04 17 00:55.30 27 N/A N/A 00:55.38 28 02:11.35 14 00:54.09 29 02:18.21 20 00:55.97 30 02:18.25 21 00:56.06 31 DNL DNL 00:56.12 32 DNL DNL 00:56.29 33 02:23.95 25 00:56.58 34 N/A N/A 29 NS MB NS SK Turry USIVE UITE NB A B 1 2 Games Gender LUTO VOTO 35 2015 Male 36 2015 Male 37 2015 Male 38 2015 Male 39 2015 Male 40 2015 Male 41 2015 Male 42 2015 Male 43 2015 Male 44 2015 Male 45 2015 Male 46 2015 Male 47 2015 Male 48 2015 Male 49 2015 Male 50 2015 Male 51 2015 Male 52 2015 Male 53 2015 Male 54 2015 Male 55 2015 Male 56 2015 Male 57 2015 Male 58 2015 Male 59 2015 Male 60 2015 Male 61 2015 Male E Athlete Information First Name Last Name PT Vuvos lan Keefe NS Devin McAllister SK Walter Teague NB Devin Mittertreiner BC Camden Sutherland Olivier Paradis QC Eli Klassen SK Jack Dunlop MB Blaise Cunnigham MB Louis Lacoursiere SK Cole Myers NS Brandyn Cooke NB Garrett Musgrave SK Micheal Copp MB Jack Morse PE Kyle Simmons NL Owen Tuner PE Jack Healey MB Rhett Regnier SK Kyle Barrington NS Alex Woolfrey NL Mitchell Harris SK Nicholas Friesen MB Neill Telles-Langdon MB Erik Kuhune NL Jack Diehl Patrick Hadlaw NS F G H Super G Giant Slalom Time Rank Time Rank 00:56.29 33 02:23.95 25 00:56.58 34 N/A NA 00:56.73 35 02:25.12 27 00:56.78 36 02:18.46 22 00:56.18 37 02:18.60 23 00:56.90 38 02:10.53 12 00:57.16 39 02:25.89 29 00:57.70 40 N/A N/A 00:57.88 41 N/A NA 00:58.40 42 N/A N/A 00:58.51 43 02:25.61 28 00:59.32 44 02:21.03 24 00:59.43 45 02:35.05 32 00:59.80 46 02:32.32 30 01:01.19 47 NA NA 01:01.38 48 02:36.77 34 01:01.65 49 N/A NA 01:03.21 50 N/A N/A 01:03.32 51 02:36.49 33 01:03.53 52 02:39.08 36 01:03.65 53 N/A N/A 01:03.80 54 02:39.53 37 01:03.94 55 N/A 01:04.72 56 02:45.95 38 01:05.00 57 N/A N/A 01:06.05 58 N/A N/A 01:07.18 59 02:38.68 35 SK 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". a) Construct a scatter plot of the Giant Slalom race time (dependent variable) and Super G race time (independent variable). b) Find the correlation coefficient. c) Find the equation of the regression line and add it to the scatter plot. d) Find the coefficient of determination. Alpine Skiing Events Alpine skiing has been part of the Canada Winter Games since the inaugural Games in 1967 in Quebec City. Alpine skiing has always featured both Men's and Women's competition and has offered events for athletes with a disability since the 2011 Canada Games in Halifax Slalom Giant Slalom Super G An athlete skis between An athlete skis between An athlete skis between gates that are spaced gates that are spaced the most widely set gates closest together of the further apart than the gates and the minimum vertical three events. There is a in Slalom. The minimum drop is 250 m. Super G, minimum vertical drop of vertical drop is 200 m. also known as Super Giant 120 m. Regarded as a Giant Slalom is a technical Slalom, is regarded as a technical event, Slalom is event that requires quick, speed event. Skiers requires quick, short turns. short turns. The skier's complete one run for their The combined time of two final score is the total time final score. runs is the skier's final to finish two runs. score. Data To make computations more manageable, all times should to be converted from their current format of mm:ss.00 to seconds.00. For example, to convert a time of 01:39.15 in cell H2, click on an empty cell and type =H2*60*60*24 in the home tab, change the Number Format of that cell from "Custom" to "General". The time of 01:39.15 is now converted to 99.15 seconds. When providing times in your report, express times in the mm:ss.00 format. Unless stated otherwise in the question, omit athletes with incomplete race times from analysis. e) Construct a residual plot. (Hint: Using the Analysis ToolPak, go to Data Analysis, choose "Regression", and then check the box beside "Residual Plots".) 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. 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. i. A male Canada Games alpine skier who finished a Super G in 73.14 seconds wants to predict his Giant Slalom race time. ii. A male Canada Games alpine skier who finished a Super G in 52.98 seconds wants to predict his Giant Slalom race time. iii. A female Canada Games alpine skier who finished a Super G in 56.27 seconds wants to predict her Giant Slalom race time. E G PT ON ON ON ON BC BC BC AB BC ON QC ON AB AB A B 1 2 Games Gender 3 2015 Male 4 2015 Male 5 2015 Male 6 2015 Male 7 2015 Male 8 2015 Male 9 2015 Male 10 2015 Male 11 2015 Male 12 2015 Male 13 2015 Male 14 2015 Male 15 2015 Male 16 2015 Male 17 2015 Male 18 2015 Male 19 2015 Male 20 2015 Male 21 2015 Male 22 2015 Male 23 2015 Male 24 2015 Male 25 2015 Male 26 2015 Male 27 2015 Male 28 2015 Male 2015 Male 30 2015 Male 31 2015 Male 32 2015 Male 33 2015 Male 34 2015 Male 35 2015 Male 36 2015 Male D Athlete Information First Name Last Name Declan McCormack Cam McGregor Will Kornya Griffin Copp Kasper Woolley Asher Alexander Jordan Alexander David Valentin Liam Haynes Kyle Alexander Zachary Mayne Benjamn Mathieu Hunter Watson Liam Wallace Kelvin Cochrane Jay Toots Quentin Roy-Foster Jamie Casselman Gavin Donald Ryan Westover Finley Evan Ross Cody Monod Adrien Grabinski Louis-Phillipe Noel Stephen Cameron Magee Caeden Carruthers Vincent Tarte Frederic Verret Dawson mead Hill JD Todd lan Morrison Connor Keefe Jacob King lan Keefe Devin McAllister QC QC AB BC BC NS AB AB QC NB NB QC NB AB NS NB F H Super G Giant Slalom Time Rank Time Rank 00:50.97 1 N/A NA 00:51.46 2 N/A N/A 00:51.55 3 02:08.86 8 00:51.86 4 N/A N/A 00:52.03 5 02:09.31 9 00:52.15 6 02:08.16 4 00:52.17 7 N/A N/A 00:52.46 8 02:08.63 6 00:52.90 9 N/A N/A 00:53.02 10 02:10.72 13 00:53.11 11 02:08.56 5 00:53.32 12 02:08.71 7 00:53.40 13 02:04.63 1 00:53.47 14 02:13.06 15 00:53.48 15 N/A N/A 00:53.54 16 DNL DNL 00:53.89 17 02:09.31 10 00:53.90 18 DNL DNL 00:54.03 19 N/A N/A 00:54.09 20 02:09.79 11 00:54.24 21 02:08.11 3 00:54.31 22 02:07.98 2 00:54.48 23 N/A N/A 00:54.55 24 N/A N/A 00:54.70 25 02:24.44 26 00:54.92 26 02:14.04 17 00:55.30 27 N/A N/A 00:55.38 28 02:11.35 14 00:54.09 29 02:18.21 20 00:55.97 30 02:18.25 21 00:56.06 31 DNL DNL 00:56.12 32 DNL DNL 00:56.29 33 02:23.95 25 00:56.58 34 N/A N/A 29 NS MB NS SK Turry USIVE UITE NB A B 1 2 Games Gender LUTO VOTO 35 2015 Male 36 2015 Male 37 2015 Male 38 2015 Male 39 2015 Male 40 2015 Male 41 2015 Male 42 2015 Male 43 2015 Male 44 2015 Male 45 2015 Male 46 2015 Male 47 2015 Male 48 2015 Male 49 2015 Male 50 2015 Male 51 2015 Male 52 2015 Male 53 2015 Male 54 2015 Male 55 2015 Male 56 2015 Male 57 2015 Male 58 2015 Male 59 2015 Male 60 2015 Male 61 2015 Male E Athlete Information First Name Last Name PT Vuvos lan Keefe NS Devin McAllister SK Walter Teague NB Devin Mittertreiner BC Camden Sutherland Olivier Paradis QC Eli Klassen SK Jack Dunlop MB Blaise Cunnigham MB Louis Lacoursiere SK Cole Myers NS Brandyn Cooke NB Garrett Musgrave SK Micheal Copp MB Jack Morse PE Kyle Simmons NL Owen Tuner PE Jack Healey MB Rhett Regnier SK Kyle Barrington NS Alex Woolfrey NL Mitchell Harris SK Nicholas Friesen MB Neill Telles-Langdon MB Erik Kuhune NL Jack Diehl Patrick Hadlaw NS F G H Super G Giant Slalom Time Rank Time Rank 00:56.29 33 02:23.95 25 00:56.58 34 N/A NA 00:56.73 35 02:25.12 27 00:56.78 36 02:18.46 22 00:56.18 37 02:18.60 23 00:56.90 38 02:10.53 12 00:57.16 39 02:25.89 29 00:57.70 40 N/A N/A 00:57.88 41 N/A NA 00:58.40 42 N/A N/A 00:58.51 43 02:25.61 28 00:59.32 44 02:21.03 24 00:59.43 45 02:35.05 32 00:59.80 46 02:32.32 30 01:01.19 47 NA NA 01:01.38 48 02:36.77 34 01:01.65 49 N/A NA 01:03.21 50 N/A N/A 01:03.32 51 02:36.49 33 01:03.53 52 02:39.08 36 01:03.65 53 N/A N/A 01:03.80 54 02:39.53 37 01:03.94 55 N/A 01:04.72 56 02:45.95 38 01:05.00 57 N/A N/A 01:06.05 58 N/A N/A 01:07.18 59 02:38.68 35 SK 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". a) Construct a scatter plot of the Giant Slalom race time (dependent variable) and Super G race time (independent variable). b) Find the correlation coefficient. c) Find the equation of the regression line and add it to the scatter plot. d) Find the coefficient of determination