1. Generate the regression of T on all the independent variables in the data using EXCEL. Copy and paste the results here. This is MODEL I. Evaluate the explanatory power of MODEL 1
2. ) Test the claim that there is no correlation between the best time and the miles run against the claim that miles run and the best time for the 5K move inversely (as one goes up, the other falls). Use a 5% level of significance. Ho: Ha:

   Decision Rule (Draw the distribution, show the critical values, and shade the rejection region)

   Test statistic: (Show the calculated value formula and what you are using to generate the value)

   Decision : Do not reject Ho Reject Ho (Circle)

   Conclusion in the context of this problem:

3. Test the overall significance of MODEL 1. Use a 5% level of significance. Ho: Ha: Decision Rule (Use the p-value rule) Test statistic: (Report the calculated value and the p-value in the output) Decision : Do not reject Ho Reject Ho (Circle)Conclusion in the context of this problem:

WU STR G 0 HSA 0 TW 0 1 1 M 35 25 40 A 20 17 17 1 1 CA 1 0 0 1 1 Y 9 3 5 9 1 1 1 1 1 0 1 0 1 1 0 0 1 1 0 0 1 1 0 2 0 5 0 0 0 1 1 1 0 0 0 0 0 1 0 1 1 4 6 0 0.5 19 16 27 21 17 30 19 21 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 0 0 0 1 0 1 0 0 1 1 4 1 65 2 1 1 0 0 1 0 0 0 2 0 0 0 0 0 0 1 0 8 0 1 0 0 0 1 1 0 0 1 0 0 0 0 23 15 16 20 18 1 1 0 0 1 1 1 1 1 1 1 0 0 1 1 1 0 1 1 1 0 5 50 3 60 30 14 0 16 65 1 1 0 0 0 0 1 0 0 0 1 1 1 3 7 2 3 3 0 0 5 11 0 3 2 1 1 0 0 0 0 0 0 0 0 0 17 19 21 22 49 21 21 16 0 0 0 1 1 0 0 0 1 0 1 1 1 1 0 1 0 0 1 26 30 0 1 1 0 1 1 1 1 1 1 10 30 1 0 0 18 18 1 1 1 0 0 1 1 1 1 0 0 0 1 T 18.75 17.23 18.88 20.38 21.83 26.00 20.38 24.00 26.40 14.88 20.85 27.88 28.50 26.00 20.00 38.00 15.80 18.17 39.00 25.45 32.67 15.02 16.47 22.53 18.32 23.15 24.50 23.75 20.47 20.80 28.72 27.00 21.55 25.12 16.75 23.97 16.33 21.78 16.40 23.00 15.27 21.97 18.72 22.03 23.58 19.80 24.43 24.43 19.33 21.33 17.95 15.83 23.00 19.67 16.83 18.92 25.00 30.00 0 4 10 18 25 0 0 0 1 0 0 1 1 1 2 2 7 6 0 0 0 20 42 56 17 0 0 0 0 0 0 0 1 1 10 1 1 1 1 1 0 1 43 0 0 1 1 1 0 0 0 0 15 10 3 1 1 0 0 1 1 0 3 0 8 0 0 0 0 1 0 1 1 1 1 1 0 0 1 0 50 1 1 0 0 0 0 0 0 20 1 1 1 1 1 1 1 1 0 0 0 1 1 0 30 60 30 45 30 60 1 0 1 0 0 20 49 16 19 57 19 16 19 16 21 18 19 16 19 16 1 5 2 4.5 2 7 5 1 0 1 1 1 1 0 1 0 1 0 0 30 1 1 1 1 1 1 0 0 1 0 1 1 0 0 0 0 0 0 1 1 7 3 3 0 45 35 6 12 12 9 30 35 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 1 1 ON 1 0 1 1 1 0 1 0 1 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 0 1 1 0 0 0 1 1 1 10 7 8 8 0 7 3 0 0 0 19 17 20 19 17 16 13 18 19 18 17 36 0 0 1 1 0 0 1 1 1 1 20 50 8 40 50 0 0 10 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 1 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 1 1 1 1 0 0 1 1 1 17.00 22.70 19.53 14.83 21.00 17.50 30.00 23.42 21.20 19.92 15 40 10 25 25 10 0 28 38 2 2 2 2 8 3 2 0 5 3 1 1 16 16 39 21 17 17 12 22 15 16 1 1 1 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 1 1 1 0 5 0 WU STR G 0 HSA 0 TW 0 1 1 M 35 25 40 A 20 17 17 1 1 CA 1 0 0 1 1 Y 9 3 5 9 1 1 1 1 1 0 1 0 1 1 0 0 1 1 0 0 1 1 0 2 0 5 0 0 0 1 1 1 0 0 0 0 0 1 0 1 1 4 6 0 0.5 19 16 27 21 17 30 19 21 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 0 0 0 1 0 1 0 0 1 1 4 1 65 2 1 1 0 0 1 0 0 0 2 0 0 0 0 0 0 1 0 8 0 1 0 0 0 1 1 0 0 1 0 0 0 0 23 15 16 20 18 1 1 0 0 1 1 1 1 1 1 1 0 0 1 1 1 0 1 1 1 0 5 50 3 60 30 14 0 16 65 1 1 0 0 0 0 1 0 0 0 1 1 1 3 7 2 3 3 0 0 5 11 0 3 2 1 1 0 0 0 0 0 0 0 0 0 17 19 21 22 49 21 21 16 0 0 0 1 1 0 0 0 1 0 1 1 1 1 0 1 0 0 1 26 30 0 1 1 0 1 1 1 1 1 1 10 30 1 0 0 18 18 1 1 1 0 0 1 1 1 1 0 0 0 1 T 18.75 17.23 18.88 20.38 21.83 26.00 20.38 24.00 26.40 14.88 20.85 27.88 28.50 26.00 20.00 38.00 15.80 18.17 39.00 25.45 32.67 15.02 16.47 22.53 18.32 23.15 24.50 23.75 20.47 20.80 28.72 27.00 21.55 25.12 16.75 23.97 16.33 21.78 16.40 23.00 15.27 21.97 18.72 22.03 23.58 19.80 24.43 24.43 19.33 21.33 17.95 15.83 23.00 19.67 16.83 18.92 25.00 30.00 0 4 10 18 25 0 0 0 1 0 0 1 1 1 2 2 7 6 0 0 0 20 42 56 17 0 0 0 0 0 0 0 1 1 10 1 1 1 1 1 0 1 43 0 0 1 1 1 0 0 0 0 15 10 3 1 1 0 0 1 1 0 3 0 8 0 0 0 0 1 0 1 1 1 1 1 0 0 1 0 50 1 1 0 0 0 0 0 0 20 1 1 1 1 1 1 1 1 0 0 0 1 1 0 30 60 30 45 30 60 1 0 1 0 0 20 49 16 19 57 19 16 19 16 21 18 19 16 19 16 1 5 2 4.5 2 7 5 1 0 1 1 1 1 0 1 0 1 0 0 30 1 1 1 1 1 1 0 0 1 0 1 1 0 0 0 0 0 0 1 1 7 3 3 0 45 35 6 12 12 9 30 35 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 1 1 ON 1 0 1 1 1 0 1 0 1 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 0 1 1 0 0 0 1 1 1 10 7 8 8 0 7 3 0 0 0 19 17 20 19 17 16 13 18 19 18 17 36 0 0 1 1 0 0 1 1 1 1 20 50 8 40 50 0 0 10 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 1 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 1 1 1 1 0 0 1 1 1 17.00 22.70 19.53 14.83 21.00 17.50 30.00 23.42 21.20 19.92 15 40 10 25 25 10 0 28 38 2 2 2 2 8 3 2 0 5 3 1 1 16 16 39 21 17 17 12 22 15 16 1 1 1 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 1 1 1 0 5 0