SECTION 1: RELATIONSHIP BETWEEN MILE RUN AND VO2 MAX [25 POINTS) A kinesiology major wanted to predict VO2Max based on the mile run. To develop the regression equation, she obtained VO2Max values (ml/kg/min) in the exercise physiology laboratory on 18 male students. Two days later, she measured the same 18 students on the mile walk/run with scores reported as total time in seconds it took to complete a mile. The data for the study is shown below: Mile Walk/Ru n VO2 (Second s) Participa Max nt x2 y2 1 250 60.3 57.2 2 315 3 420 55.4 4 410 51.4 5 436 52.5 6 511 45.6 7 460 38.4 8 510 41.5 9 530 39.6 10 586 33.2 11 591 37.7 12 600 40.1 13 626 32.0 14 643 35.4 1 Page KIN 270 - HOMEWORK ASSIGNMENT #5 650 675 33.7 35.9 15 16 17 18 710 27.4 720 25.3 Questions: a) Using MS Excel, create a scatter plot. Describe the plot. (2 Points) b) Calculate the means values for the mile run times (x) and VO2 Max (x). Show your work. (2 Points) c) Complete the table above and compute the following: i. Calculate the sum of xy. (1 Point) Calculate the Sum of x? (1 Point) iii. Calculate the sum of y2. (1 Point) d) Calculate the correlation coefficient. Show your work. (3 Points) e) Summarize the strength of the relationship between Mile Run and V02 Max. (1 Point) f) State the null and alternative hypothesis. (1 Point) g) Calculate t-test statistic for the correlation. Show your work. (2 Points) n) Find the degrees of freedom. Show your work. (1 Point) i) Let alpha = 0.05, find the critical value, p-value and state your conclusion. (2 Point) 1) Find the regression equation. Show your work. (4 Points) k) Interpret a and b estimates from the regression equation. (2 Points) 1) Using the regression equation as a prediction equation, calculate the predicted VO2 Max for a student who complete a mile run in 325 seconds? Show your work. (1 Point) m) Using the regression equation as a prediction equation, calculate the predicted VO2 Max for a student who complete a mile run in 477 seconds? Show your work. (1 Point)