THIS IS FOR STAT PLEASE ANSWER ASAP AND ALSO I HAVE INCLUDED THE DATA.

\f2015 Giant Slalom Para Female Brenda MacDonald Lona NS 2015 Giant Slalom Para Female Christel Robichaud NB 2015 Giant Slalom Para Female Alex Marta ON 2015 Slalom Para Female Frederique Turgeon QC 2015 Slalom Para Female Mel Pemble BC 2015 Slalom Para Female Sarah Gillies ON 2015 Slalom Para Female Brenda MacDonald Lona NS 2015 Slalom Para Female Chelaine Tannis Mclnroy BC 2015 Giant Slalom Male Liam Wallace AB 2015 Giant Slalom Male Adrien Grabinski AB 2015 Giant Slalom Male Cody Monod AB 2015 Giant Slalom Male Asher Alexander Jordan BC 2015 Giant Slalom Male Benjamin Mathieu QC 2015 Giant Slalom Male Liam Haynes AB 2015 Giant Slalom Male Hunter Watson ON 2015 Giant Slalom Male Will Kornya ON 2015 Giant Slalom Male Kasper Woolley BC 2015 Giant Slalom Male Jamie Casselman AB 2015 Giant Slalom Male Evan Ross NS 2015 Giant Slalom Male Olivier Paradis QC 2015 Giant Slalom Male Zachary Mayne ON 2015 Giant Slalom Male Dawson Mead Hill AB 2015 Giant Slalom Male Kelvin Cochrane AB 2015 Giant Slalom Male Louis-Philippe Noel QC 2015 Giant Slalom Male Vincent Tarte QC 2015 Giant Slalom Male Cameron Stephen Magee NB 2015 Giant Slalom Male Leo Pilote QC 2015 Giant Slalom Male JD Todd NS 2015 Giant Slalom Male lan Morrison NB 2015 Giant Slalom Male Devin Mittertreiner BC 2015 Giant Slalom Male Camden Sutherland NB 2015 Giant Slalom Male Brandyn Cooke NB 2015 Giant Slalom Male lan Keefe NS 2015 Giant Slalom Male Caeden Carruthers NB 2015 Giant Slalom Male Walter Teague NB 2015 Giant Slalom Male Cole Myers NS 2015 Giant Slalom Male Eli Klassen SK 2015 Giant Slalom Male Michael Copp MB 2015 Giant Slalom Male Owen Turner PE 2015 Giant Slalom Male Garrett Musgrave SK 2015 Giant Slalom Male Rhett Regnier SK 2015 Giant Slalom Male Kyle Simmons NL 2015 Giant Slalom Male Patrick Hadlaw NS 2015 Giant Slalom Male Kyle Barrington NS 2015 Giant Slalom Male Mitchell Harris SK 2015 Giant Slalom Male Neill Telles-Langdon MB 2015 Giant Slalom Male Jake Diehl SK 2015 Giant Slalom Male Patrick Walsh NL 2015 Giant Slalom Male Quentin Roy-Foster QC 2015 Giant Slalom Male Gavin Donald BC 2015 Giant Slalom Male Jacob King MB 2015 Giant Slalom Male Connor Keefe NS 2015 Giant Slalom Para Male Alexis Bambi Guimond QC2015 Giant Slalom Para Male Mark Taylor Robertson BC 2015 Giant Slalom Para Male James Binsfeld ON 2015 Giant Slalom Para Male Omid Raoufian AB 2015 Giant Slalom Para Male Greg Moogk ON 2015 Giant Slalom Para Male Spencer Douglas Allen AB 2015 Giant Slalom Para Male Remi Cote QC 2015 Ski Cross Male Leo Pilote QC 2015 Ski Cross Male Devin Mittertreiner BC 2015 Ski Cross Male Ryan Westover Finley BC 2015 Ski Cross Male Liam Wallace AB 2015 Ski Cross Male Olivier Paradis QO 2015 Ski Cross Male Evan Ross NS 2015 Ski Cross Male Stephen Cameron Magee NB 2015 Ski Cross Male Connor Keefe NS 2015 Ski Cross Male Kyle Alexander BC 2015 Ski Cross Male Brandyn Cooke NB 2015 Ski Cross Male Caeden Carruthers NB 2015 Ski Cross Male Alexander David Valentin BC 2015 Ski Cross Male Asher Alexander Jordan BC 2015 Ski Cross Male Adrien Grabinski AB 2015 Ski Cross Male Gavin Donald BC 2015 Ski Cross Male JD Todd NS 2015 Ski Cross Male Devin McAllister SK 2015 Ski Cross Male Louis-Philippe Noel QC 2015 Ski Cross Male Jamie Casselman AB 2015 Ski Cross Male Kelvin Cochrane AB 2015 Ski Cross Male Liam Haynes AB 2015 Ski Cross Male lan Morrison NB 2015 Ski Cross Male Benjamin Mathieu QC 2015 Ski Cross Male Garrett Musgrave SK 2015 Ski Cross Male lan Keefe NS 2015 Ski Cross Male Camden Sutherland NB 2015 Ski Cross Male Jack Dunlop MB 2015 Ski Cross Male Blaise Cunnigham MB 2015 Ski Cross Male Cole Myers NS 2015 Ski Cross Male Frederic Verret NB 2015 Ski Cross Male Jack Morse PE 2015 Ski Cross Male Cody Monod AB 2015 Ski Cross Male Quentin Roy-Foster QC 2015 Ski Cross Male Vincent Tarte QC 2015 Ski Cross Male Jay Toots QC 2015 Ski Cross Male Gavin Alexander Kerr PE 2015 Ski Cross Male Nicholas Friesen MB 2015 Ski Cross Male Dawson Mead Hill AB 2015 Ski Cross Male Rhett Regnier SK 2015 Ski Cross Male Walter Teague NB 2015 Ski Cross Male Eli Klassen SK 2015 Ski Cross Male Kyle Barrington NS 2015 Ski Cross Male Kyle Simmons NL 2015 Ski Cross Male Alex Woolfrey NL 2015 Ski Cross Male Patrick Walsh NL 2015 Ski Cross Male Owen Turner PE 2015 Ski Cross Male Jacob King MB\fGames Event Gender Name PT 2015 Giant Slalom Female Brianna Macdonald ON 2015 Giant Slalom Female Kristina Natalenko BC 2015 Giant Slalom Female Maxime Tremblay QC 2015 Giant Slalom Female Abby Harrison AB 2015 Giant Slalom Female Catherine Dufresne QC 2015 Giant Slalom Female Samantha Boughner ON 2015 Giant Slalom Female Camryn Metzger ON 2015 Giant Slalom Female Ella Renzoni BC 2015 Giant Slalom Female Justine Clement QC 2015 Giant Slalom Female Katie Fleckenstein BC 2015 Giant Slalom Female Skylar Buckle AB 2015 Giant Slalom Female Brooke Lukinuk BC 2015 Giant Slalom Female Ashleigh Chloe Alexander AB 2015 Giant Slalom Female Larkin Casey ON 2015 Giant Slalom Female Karleen Jane Rutter AB 2015 Giant Slalom Female Nicole Mah BC 2015 Giant Slalom Female Alessia Vinet QC 2015 Giant Slalom Female Kalli van der Voort AB 2015 Giant Slalom Female Sierra Ashley King BC 2015 Giant Slalom Female Sam Piekarski NB 2015 Giant Slalom Female Kelly McCardle PE 2015 Giant Slalom Female Katie Orr QC 2015 Giant Slalom Female Jennifer Kristin Clarke NB 2015 Giant Slalom Female Callie Hislop MB 2015 Giant Slalom Female Lindsay Myles NS 2015 Giant Slalom Female Camille Jones NS 2015 Giant Slalom Female Jessica McBride MB 2015 Giant Slalom Female Bella Gierys MB 2015 Giant Slalom Female Megan Colbourne NL 2015 Giant Slalom Female Cameron MacLeod PE 2015 Giant Slalom Female Mackenzie Heidel SK 2015 Giant Slalom Female Shayna Fehr SK 2015 Giant Slalom Female Heidi Perry NL 2015 Giant Slalom Female Georgia Elisabeth Jones NS 2015 Giant Slalom Female Chloe Laidlaw SK 2015 Giant Slalom Female Lucy Black NB 2015 Giant Slalom Female Jodie Davis MB 2015 Giant Slalom Female Claire Healey MB 2015 Giant Slalom Female Kay Mills NB 2015 Giant Slalom Female Dara Carr NS 2015 Giant Slalom Female Amanda Creith MB 2015 Giant Slalom Female Claire Simmons NL 2015 Giant Slalom Female Carley May NL 2015 Giant Slalom Female Samantha Elizabeth Richardson YT 2015 Giant Slalom Female Melissa Bzowey SK 2015 Giant Slalom Female Amy Lacoursiere SK 2015 Giant Slalom Female Frances Elsie MacDonald BC 2015 Giant Slalom Female Camille Christie Vibert ON 2015 Giant Slalom Female Katelyn Lee Vowk YT 2015 Ski Cross Female Katie Fleckenstein BC 2015 Ski Cross Female Nicole Mah BC 2015 Ski Cross Female Kalli van der Voort ABQuestion 1. Skiing is a popular competitive sport in the Canada 1Winter Games and is featured in the Alpine Skiing, Cross Country Skiing, and Freestyle Skiing competitions. Event organizers are interested to know if the distribution of home provincesfterritories is different between skiers who compete in Alpine Skiing and skiers who compete in Freestyle Skiing. To test the claim, we will use the data given in the Excel sheets Freestyle Ski and 2015 Alpine Ski as sample data. (a) Use the Freestyle Ski data to construct a relative frequency distribution for the home provinces! territories of freestyle skiers. {b} Use the 2015 Alpine Ski data to construct a relative frequency distribution for the home provinces/ territories of alpine skiers. {Hint Some alpine skiers compete in multiple events. To avoid counting a skier more than once, delete repeated names. Click on any cell in the data table. In the Data tab, click on the \"Remove Duplicates\" button. Select the appropriate columnfs} Excel should examine for duplicates.) (c) Create a relative frequency bar graph to help the event organizers visualize and compare the distributions of home provincesf territories between freestyle skiers and alpine skiers. (Hint: Use the results in part {a} and {b} to construct a Clustered Column graph in Excel. Ensure the graph is easy to interpret with clear labels and a legend.) {d} Examine the bar graph in part {c} and comment on what you notice when comparing the distributions. Based on your observations, do you believe the distribution of home provincesf territories is different between alpine skiers and freestyle skiers? Explain. {e} We will now conduct a formal statistical test to compare the distributions. At the 5% signicance level, should we reject or not reject the claim that the distribution of home provinces/ territories of alpine skiers is the same as the distribution of home provinces: f territories of freestyle skiers? (Hint: Apply the test of goodness oft. You should notice that 2 of the expected frequencies are less than 5, but you can still proceed with the test.)