6 Athletes complete the components of a triathlon in the order of swim, bike, and run. Which pair of components have a linear relationship that can be used for predictions? Investigate the following pairs of components: Bike (dependent) vs. Swim (independent) Run (dependent) vs. Swim (independent) Run (dependent) vs. Bike (independent) Consider the female triathletes who competed in the Canada Games as a sample of all female triathletes. Part A: Women Sprint Triathlon Consider Sprint results from the 2009, 2013, and 2017 Women Individual Triathlon. iv. For each pair of components, V. a. construct a separate scatter plot, b. find the corresponding correlation coefficient, and c. find the corresponding coefficient of determination. Which pair of components has the strongest linear relationship in the sprint triathlon? Find the equation of the trend line for this pair and add it to the corresponding scatter plot. Part B: Women Super Sprint Triathlon Consider Super Sprint results from the 2009 and 2013 Women Relay Triathlon. (Hint: The athlete's individual performance in a Team Relay is their Super Sprint data.) i. The pair of components that has the strongest linear relationship in the super sprint triathlon is between swim (independent) and run (dependent). Find the equation of this trend line and add it to the scatter plot. ii. iii. Compare the strongest linear relationship in the sprint triathlon to the strongest linear relationship in a super sprint triathlon. Estimate the expected run time for a female super sprint triathlete who finished the swim component in 4 and a half minutes. (Hint: Express the run time in mm:ss format.) Triathlon 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 "Triathlon" data sheet to make summaries and inferences. Triathlon Events Triathlon debuted at the 2009 Summer Canada Games in PEI and features both Men's and Women's competition. Individual Sprint Triathlon An individual athlete completes a sprint triathlon: 750 m swim -> Transition 1 -> 20 km bike -> Transition 2 -> 5 km run Team Relay A three-person team (all men or all women) in which each athlete completes a super sprint triathlon: 250 m swim -> Transition 1 -> 6.6 km bike -> Transition 2 -> 1.6 km run The three individual super sprint triathlon times are added together for the total team relay time. Data To make computations more manageable, all times should to be converted from their current format of hh:mm:ss to seconds. For example, to convert a time of 0:58:14 in cell F2, click on an empty cell and type = hour(F2)*3600+minute (F2)*60+second(F2) In the home tab, change the Number Format of that cell from "Custom" to "General". The time of 0:58:14 is now converted to 3494 seconds. When providing times in your report, express times in the hh:mm:ss or mm:ss format. Unless stated otherwise in the question, omit athletes who did not finish (DNF) from analysis