Physical fitness testing is an important aspect of athletic training. A common measure of the magnitude of cardiovascular fitness is the maximum volume of oxygen uptake during strenuous exercise. A study was conducted on 24 athletic men to determine the influence on the oxygen uptake of the time required to complete two-mile run. Oxygen uptake was measured with standard laboratory methods as the subjects performed on a treadmill.

QUESTION 2 Physical fitness testing is an important aspect of athletic training. A common measure of the magnitude of cardiovascular fitness is the maximum volume of oxygen uptake during strenuous exercise. A study was conducted on 24 athletic men to determine the influence on the oxygen uptake of the time required to complete a two-mile run. Oxygen uptake was measured with standard laboratory methods as the subjects performed on a treadmill. Subjects Maximum Time in seconds volume of oxygen 42.33 918 53.1 805 42.08 892 50406 962 42.45 968 42.46 907 47.82 770 49.92 743 16 21 1045 49.66 810 41.49 927 46.17 813 46.18 43.21 860 51.67 760 53.76 747 53.29 742 47.98 801 56.99 683 20 46.73 844 21 48.76 755 22 53.36 700 23 60.62 740 24 56.29 775 a) Identify the independent variable and dependent Variable (2 marks) bj Construct a scatter plot and regression line using Microsoft excel (2 marks) c) Use Microsoft Excel to generate the Summary output for the data. (4 marks) d) Estimate the linear regression line. (1 mark) c) Briefly explain what you understand from the summary output in (c). ( 5 marks)