Question: Canada Games - Alpine SkiingCase Study DataThe Canada Games represents the highest level of national competition for up and comingCanadian athletes. Alternating between winter and

Canada Games - Alpine SkiingCase Study DataThe Canada Games represents the highest level of national competition for up and comingCanadian athletes. Alternating between winter and summer, the competition is held once everytwo years. Niagara was the proud host of the 2022 Canada Summer Games. In this case study,your group will explore the athletes information and achievements as given in theAlpine SkiData.xlsxdata sheet to make summaries and inferences.Alpine Skiing EventsAlpine skiing has been part of the Canada Winter Games since the inaugural Games in 1967 inQuebec City. Alpine skiing has always featured both Mens and Womens competition and hasoffered events for athletes with a disability since the 2011 Canada Games in Halifax.Slalom.An athlete skis between gates that are spaced closest together of the three events.There is a minimum vertical drop of 120 m. Regarded as a technical event, Slalom requiresquick, short turns. The combined time of two runs is the skiers final score.Giant Slalom.An athlete skis between gates that are spaced further apart than thegates in Slalom. The minimum vertical drop is 200 m. Giant Slalom is a technical eventthat requires quick, short turns. The skiers final score is the total time to finish two runs.Super G.An athlete skis between the most widely set gates and the minimum verticaldrop is 250 m. Super G, also known as Super Giant Slalom, is regarded as a speed event.Skiers complete one run for their final score.DataTo make computations more manageable, all times should to be converted from their currentformat of mm:ss.00 to seconds.00. For example, to convert a time of 01:39.15 in cell H2, clickon an empty cell and type=H2*60*60*24In the home tab, change the Number Format of that cell fromCustomtoGeneral. The time of01:39.15 is now converted to 99.15 seconds. When providing times in your report, express timesin the mm:ss.00 format. Unless stated otherwise in the question, omit athletes with incompleterace times from analysis SummaryBased on the results you have obtained from your case study questions, prepare a brief (nomore than one single-spaced page) report to your client. This report should include three head-ings: Introduction, Results and Conclusions/Recommendations and should include any findingsyou think are noteworthy. Were there any conclusions throughout these statistical analyses thatstood out to you? Were any results surprising to you, and if so, why? The report must betyped, include the name and signatures of all members of the group and should be the last pageof your case study submission

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!