Answer in detail please I am sticlomg on it thank you

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 A B Games Gender 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male Gymnast Information First Name Justin Flix Matthew Aaron William Jeremy Samuel Olivier Teagan Wyatt Steven Anthony Yanni Alexander Teague Laurent Findlay Noah Will Kahlil Alex Michael Antoine Michael Patrick Paul Cameron Cam Nic Isaac Davey Sam Ted Liam Gabe Stephen D Last Name Karstadt Dolci Halickman Mah Emard Bartholomeusz PT Age ON 17 QC 12 QC 18 BC 17 QC 14 ON 17 ON 16 14 18 18 BC 18 ON 15 ON 12 BC 19 SK 18 Gosselin-Paradis QC 13 McCormick AB 17 AB 17 NS 16 NS 16 PEI 17 BC 17 NB 13 NL 14 NB 11 MB 18 NB 14 BC 17 SK 18 PEI 11 MB 13 MB 16 PEI 17 NL 16 NL 15 NS 18 Zakutney Thibault Marsden Tyndall Chaplin Tawfik Chronopoulos Farquharson King Stretch Black E F Benjamin Mann Sibley Gautreau Drover Talbot Eros MacMaster Stanley Hallgrimson Bourque Boschmann Wenham Landry Jackman Sorensen Clouter QC AB SK G Floor 13.1 14.5 13.367 14.467 14.3 13.9 14.2 14.067 12.434 14.067 12.567 14 11.934 13.534 14.167 14.267 13.7 12.367 13.667 13.067 12.767 12.734 12.067 12.134 12.434 12.8 12.134 13.367 12.667 11.8 11.634 10.567 11.5 12.734 10.867 12.2 H Pommel Horse 13.767 13.2 12.034 12.4 12.367 11.2 13.234 13.834 11.934 11.867 11.6 13.9 12.9 11.2 11.467 12.267 12 12.067 12.434 11.8 11 11.167 9.834 10.367 11.334 9.167 10.2 11.834 10.667 9.3 11.434 8.8 9.467 9.267 9.8 12.7 I J Team Competition Rings 14.234 14.134 14.367 13.534 13.934 12.567 13.3 13.4 12.867 12.634 12.367 12.934 13.3 12.234 12.667 12.7 12.467 11.734 12.6 10.967 10.967 13.834 11.167 10.534 10.534 10.867 10.634 11.8 11.334 10.034 9.834 9.034 9.967 10.1 8.8 12.2 Vault 14.167 13.7 14.134 13.734 13.3 14.467 14.034 13.367 12.6 13.567 13.234 13.234 13.367 12.134 13 13.834 12.7 13.2 13.234 11.167 12.267 13.034 10.967 9.834 11.234 12.767 10.934 13.167 12 10.367 11.4 11.434 10.4 10.934 11 10.767 K L 11.9 11.067 12.134 12.067 12.4 11.9 11.967 11.034 10.767 11.167 11.534 11.567 6.167 12.834 Bar Parallel Horizontal Individual Bars Score 13.334 81.102 12.234 80.135 12.834 81.103 12.2 80.435 12.734 79.702 13.267 78.635 13.8 82.468 11.267 79.235 12.6 75.002 12.467 76.169 13.134 75.902 79.669 75.768 73.469 76.535 78.502 75.001 73.535 76.635 70.568 70.968 75.67 67.102 62.803 11.934 12.167 11.667 12.3 12.534 11.6 12.067 12.7 11.667 12.267 12.267 67.67 68.035 66.569 75.602 70.035 62.635 60.236 60.502 63.368 59.502 47.768 74.035 M 12.5 12.367 14.367 14.1 13.067 13.234 13.9 13.3 12.567 11.567 13 13.667 12.1 12.7 12.934 12.9 12.534 12.1 12 11.9 11.7 12.634 11.167 8.867 10 10.367 10.267 13.534 11.4 10.1 5.167 9.5 10.5 4.9 1.134 13.334 N Floor 13.55 13.75 13.5 14.25 13.35 13.85 13.5 13.1 12.8 12.35 13.25 10.6 12.6 13.35 13.5 13.55 12.9 11.8 13.05 13.4 12.05 11.05 11.8 11.8 11.9 12.35 12.5 12.35 11.95 12.05 11.6 10.9 12.5 12.05 O Pommel Horse 13.7 13.15 11.95 11.5 12.6 12.7 9.85 11.35 12.75 12.5 10.5 11.95 12.9 11.6 12.2 10.2 11.95 11.75 11.75 9.4 11.5 9.8 9.75 10.15 10.95 6.8 10.25 11.9 5.25 7.6 11.1 3.45 1.5 9.35 8.55 13.5 P Q R Individual All-Around Finals Rings 14.1 14.7 13.7 13.45 14.2 11.25 13.5 13.6 12.75 12.75 12.45 13.25 12.5 13 10.6 12.65 11.45 12.55 12.8 10.8 10.6 13.2 9.95 10.15 9.7 10.15 10.35 11.9 10.55 9.55 8.6 9.2 9.85 9.75 9.25 Vault 13.634 14.1 14.167 13.3 13.067 14.634 14.267 12.834 11.9 12.967 13.2 13.067 13.1 13.134 12.734 12.234 13.2 13.567 12.9 12.334 12 12.234 11 11.167 11 12.634 11.1 11.9 11 10.634 11.234 11.667 10.767 11.034 11 S Parallel Horizontal Bars 13.45 13.25 12.85 12.85 12.6 13.1 13.95 13.15 13 13 13.2 12.7 11.85 10.6 12.05 12.2 11.55 11.3 10.05 12.1 12.5 12.35 11.55 11.3 11.05 11.2 11.9 11.55 10.3 10.35 10.2 10.05 12.05 11.5 6.6 13 Bar Final Score 82.234 81.3 13.8 12.35 14.05 14.1 13.05 13.05 12.3 12.8 13.35 11.5 12.3 13.3 11.45 12.5 12.85 12.9 12.3 11.15 11.3 11.9 11.05 10.05 11.05 10.25 10.2 10.65 6.4 13.75 11 9.6 5.05 9.95 10.4 T 13.55 80.217 79.45 78.867 78.584 77.367 76.834 76.55 75.067 74.9 74.867 74.4 74.184 73.934 73.734 73.35 72.117 71.85 69.934 69.7 68.684 65.1 64.817 64.8 63.784 62.5 61 60.45 59.684 58.234 55.917 55.467 54.134 47.45 40.05 Individual and Vault Apparatus Team Medal and Apparatus 2015 Male Team & Individua + 9 8 224781 FR SE 3.1440 ps 9FFF s s ee: 288882 =23882=5 3 oneedo Ballial c CNH C agog FEE" 223 ,2,117 E N F ON : ! c PRE 8ee 2056: 3de88w88888886-64899188886 ANNA Aw &&&5558 33 0 zzc8e ocens300 05:00 EN 6 C 2 Gymnastics Case Study The Canada Games represents the highest level of national competition for up and coming Canadian athletes. Alternating between winter and summer, the competition is held once every two years. Niagara will be 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 the "Gymnastics" data sheet to make summaries and inferences. Gymnastics Events Artistic gymnastics has been part of the Canada Winter Games since the inaugural Games in 1967 in Quebec City and features both Men's and Women's competition. Women's Artistic Gymnastics Apparatus Events Vault Uneven bars Beam Floor Men's Artistic Gymnastics Apparatus Events Floor Pommel horse Rings Vault Parallel bars Horizontal bars Team Competition Each team consists of 6 athletes from the same province/territory. Each athlete competes on every apparatus. The best 4 scores in each apparatus are added together for the team score. Individual All-Around Finals The top 3 gymnasts per province/territory from the Team Competition competes in the Individual All-Around Finals, with a total of up to 36 participants based on scores obtained in the preliminary competition. Each athlete competes on every apparatus. The scores in each apparatus are added together for the individual score. Apparatus Finals The top 8 gymnasts in each event (with a maximum of 2 per province/territory) from the Team Competition will compete in the Apparatus Finals Competition. Question 6 Coaches are interested to know if there is a linear relationship between a gymnast's individual score in the Team Competition and their final score in the Individual All- Around Finals. Consider the 2015 male gymnasts as a sample of all male gymnasts. Details of their scores can be found in the Excel sheet "2015 Male Team and Individual". Part A: Regression Analysis on Full Data i. Construct a scatter plot of the Individual All-Around Finals score (dependent) and the individual score in the Team Competition (independent). ii. Find and interpret the correlation coefficient. iii. Find and interpret the coefficient of determination. iv. Find the equation of the trend line and add it to the scatter plot. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 A B Games Gender 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male 2015 Male Gymnast Information First Name Justin Flix Matthew Aaron William Jeremy Samuel Olivier Teagan Wyatt Steven Anthony Yanni Alexander Teague Laurent Findlay Noah Will Kahlil Alex Michael Antoine Michael Patrick Paul Cameron Cam Nic Isaac Davey Sam Ted Liam Gabe Stephen D Last Name Karstadt Dolci Halickman Mah Emard Bartholomeusz PT Age ON 17 QC 12 QC 18 BC 17 QC 14 ON 17 ON 16 14 18 18 BC 18 ON 15 ON 12 BC 19 SK 18 Gosselin-Paradis QC 13 McCormick AB 17 AB 17 NS 16 NS 16 PEI 17 BC 17 NB 13 NL 14 NB 11 MB 18 NB 14 BC 17 SK 18 PEI 11 MB 13 MB 16 PEI 17 NL 16 NL 15 NS 18 Zakutney Thibault Marsden Tyndall Chaplin Tawfik Chronopoulos Farquharson King Stretch Black E F Benjamin Mann Sibley Gautreau Drover Talbot Eros MacMaster Stanley Hallgrimson Bourque Boschmann Wenham Landry Jackman Sorensen Clouter QC AB SK G Floor 13.1 14.5 13.367 14.467 14.3 13.9 14.2 14.067 12.434 14.067 12.567 14 11.934 13.534 14.167 14.267 13.7 12.367 13.667 13.067 12.767 12.734 12.067 12.134 12.434 12.8 12.134 13.367 12.667 11.8 11.634 10.567 11.5 12.734 10.867 12.2 H Pommel Horse 13.767 13.2 12.034 12.4 12.367 11.2 13.234 13.834 11.934 11.867 11.6 13.9 12.9 11.2 11.467 12.267 12 12.067 12.434 11.8 11 11.167 9.834 10.367 11.334 9.167 10.2 11.834 10.667 9.3 11.434 8.8 9.467 9.267 9.8 12.7 I J Team Competition Rings 14.234 14.134 14.367 13.534 13.934 12.567 13.3 13.4 12.867 12.634 12.367 12.934 13.3 12.234 12.667 12.7 12.467 11.734 12.6 10.967 10.967 13.834 11.167 10.534 10.534 10.867 10.634 11.8 11.334 10.034 9.834 9.034 9.967 10.1 8.8 12.2 Vault 14.167 13.7 14.134 13.734 13.3 14.467 14.034 13.367 12.6 13.567 13.234 13.234 13.367 12.134 13 13.834 12.7 13.2 13.234 11.167 12.267 13.034 10.967 9.834 11.234 12.767 10.934 13.167 12 10.367 11.4 11.434 10.4 10.934 11 10.767 K L 11.9 11.067 12.134 12.067 12.4 11.9 11.967 11.034 10.767 11.167 11.534 11.567 6.167 12.834 Bar Parallel Horizontal Individual Bars Score 13.334 81.102 12.234 80.135 12.834 81.103 12.2 80.435 12.734 79.702 13.267 78.635 13.8 82.468 11.267 79.235 12.6 75.002 12.467 76.169 13.134 75.902 79.669 75.768 73.469 76.535 78.502 75.001 73.535 76.635 70.568 70.968 75.67 67.102 62.803 11.934 12.167 11.667 12.3 12.534 11.6 12.067 12.7 11.667 12.267 12.267 67.67 68.035 66.569 75.602 70.035 62.635 60.236 60.502 63.368 59.502 47.768 74.035 M 12.5 12.367 14.367 14.1 13.067 13.234 13.9 13.3 12.567 11.567 13 13.667 12.1 12.7 12.934 12.9 12.534 12.1 12 11.9 11.7 12.634 11.167 8.867 10 10.367 10.267 13.534 11.4 10.1 5.167 9.5 10.5 4.9 1.134 13.334 N Floor 13.55 13.75 13.5 14.25 13.35 13.85 13.5 13.1 12.8 12.35 13.25 10.6 12.6 13.35 13.5 13.55 12.9 11.8 13.05 13.4 12.05 11.05 11.8 11.8 11.9 12.35 12.5 12.35 11.95 12.05 11.6 10.9 12.5 12.05 O Pommel Horse 13.7 13.15 11.95 11.5 12.6 12.7 9.85 11.35 12.75 12.5 10.5 11.95 12.9 11.6 12.2 10.2 11.95 11.75 11.75 9.4 11.5 9.8 9.75 10.15 10.95 6.8 10.25 11.9 5.25 7.6 11.1 3.45 1.5 9.35 8.55 13.5 P Q R Individual All-Around Finals Rings 14.1 14.7 13.7 13.45 14.2 11.25 13.5 13.6 12.75 12.75 12.45 13.25 12.5 13 10.6 12.65 11.45 12.55 12.8 10.8 10.6 13.2 9.95 10.15 9.7 10.15 10.35 11.9 10.55 9.55 8.6 9.2 9.85 9.75 9.25 Vault 13.634 14.1 14.167 13.3 13.067 14.634 14.267 12.834 11.9 12.967 13.2 13.067 13.1 13.134 12.734 12.234 13.2 13.567 12.9 12.334 12 12.234 11 11.167 11 12.634 11.1 11.9 11 10.634 11.234 11.667 10.767 11.034 11 S Parallel Horizontal Bars 13.45 13.25 12.85 12.85 12.6 13.1 13.95 13.15 13 13 13.2 12.7 11.85 10.6 12.05 12.2 11.55 11.3 10.05 12.1 12.5 12.35 11.55 11.3 11.05 11.2 11.9 11.55 10.3 10.35 10.2 10.05 12.05 11.5 6.6 13 Bar Final Score 82.234 81.3 13.8 12.35 14.05 14.1 13.05 13.05 12.3 12.8 13.35 11.5 12.3 13.3 11.45 12.5 12.85 12.9 12.3 11.15 11.3 11.9 11.05 10.05 11.05 10.25 10.2 10.65 6.4 13.75 11 9.6 5.05 9.95 10.4 T 13.55 80.217 79.45 78.867 78.584 77.367 76.834 76.55 75.067 74.9 74.867 74.4 74.184 73.934 73.734 73.35 72.117 71.85 69.934 69.7 68.684 65.1 64.817 64.8 63.784 62.5 61 60.45 59.684 58.234 55.917 55.467 54.134 47.45 40.05 Individual and Vault Apparatus Team Medal and Apparatus 2015 Male Team & Individua + 9 8 224781 FR SE 3.1440 ps 9FFF s s ee: 288882 =23882=5 3 oneedo Ballial c CNH C agog FEE" 223 ,2,117 E N F ON : ! c PRE 8ee 2056: 3de88w88888886-64899188886 ANNA Aw &&&5558 33 0 zzc8e ocens300 05:00 EN 6 C 2 Gymnastics Case Study The Canada Games represents the highest level of national competition for up and coming Canadian athletes. Alternating between winter and summer, the competition is held once every two years. Niagara will be 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 the "Gymnastics" data sheet to make summaries and inferences. Gymnastics Events Artistic gymnastics has been part of the Canada Winter Games since the inaugural Games in 1967 in Quebec City and features both Men's and Women's competition. Women's Artistic Gymnastics Apparatus Events Vault Uneven bars Beam Floor Men's Artistic Gymnastics Apparatus Events Floor Pommel horse Rings Vault Parallel bars Horizontal bars Team Competition Each team consists of 6 athletes from the same province/territory. Each athlete competes on every apparatus. The best 4 scores in each apparatus are added together for the team score. Individual All-Around Finals The top 3 gymnasts per province/territory from the Team Competition competes in the Individual All-Around Finals, with a total of up to 36 participants based on scores obtained in the preliminary competition. Each athlete competes on every apparatus. The scores in each apparatus are added together for the individual score. Apparatus Finals The top 8 gymnasts in each event (with a maximum of 2 per province/territory) from the Team Competition will compete in the Apparatus Finals Competition. Question 6 Coaches are interested to know if there is a linear relationship between a gymnast's individual score in the Team Competition and their final score in the Individual All- Around Finals. Consider the 2015 male gymnasts as a sample of all male gymnasts. Details of their scores can be found in the Excel sheet "2015 Male Team and Individual". Part A: Regression Analysis on Full Data i. Construct a scatter plot of the Individual All-Around Finals score (dependent) and the individual score in the Team Competition (independent). ii. Find and interpret the correlation coefficient. iii. Find and interpret the coefficient of determination. iv. Find the equation of the trend line and add it to the scatter plot