please help to answer this

QUESTION 2 Physical tness testing is an important aspect of athletic training. A common measure of the magnitude of cardiovascular tness is the maximum volume of oxygen uptake during strenuous exercise. A study was conducted on 24 athletic men to determine the inuence 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 Jerformed on a treadmill. Subjects Maximum Time in seconds volume of oxygen 1 42.33 918 2 53.1 805 3 42.08 892 4 50.06 962 5 42.45 963 6 42.46 907 7 47.82 770 8 49.92 743 9 36.23 1045 10 49.66 810 11 41.49 927 12 46.17 813 13 46.18 858 14 43.21 860 15 51.67 760 16 53.76 747 17 53.29 742 18 47.98 801 19 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 b) Construct a scatter plot and regression line using Microsoft excel c) Use Microsoft Excel to generate the Summary output for the data. d) Estimate the linear regression line. e) Briey explain what you understand from the summary output in (c)