Sep
2004
Nov
2011
2.4 2.5
2.35 2.7
2.65 2.7
3.8 2.7
2.7 2.5
2.1 2.6
2.35 2.6
2.4 2.7
2.5 2.7
2.45 2.7
2.45 2.7
2.5 2.7
2.8
2.7
2.7
2.7
2.8
2.8
2.8
2.9
2.8
3.0
3.1
time dist
0 0
3 420
5 840
8 1260
11 1680
13 2100
16 2520
18 2940
21 3360
24 3780
26 4200
29 4620
32 5040
35 5460
37 5880
40 6300
43 6720
46 7140
48 7560
51 7980
54 8400
57 8820
60 9240
63 9660

Born to Run: Still running • Name:

Chapter 11: Data on the left

On the left is track lap data from 12 September 2004 and Tuesday evening, 29 November 2011. The data is the time in minutes to complete one lap of the track in lane three while running and juggling. For this data run an independent samples t-test for a difference in the mean lap time to determine if Lee Ling has slowed down over the past seven years from 45 to 52 years old.

  1. __________ Calculate the sample mean x for the 2004 lap time data.
  2. __________ Calculate the sample mean x for the 2011 lap time data.
  3. _____________ What is the p-value? Use the data on the left in an independent samples TTEST function with two tails to determine the p-value for this two sample data.
  4. _____________ Are the sample means statistically significantly different at a risk of a type I error alpha α = 0.05?
  5. _____________ Would we fail to reject | or | reject a null hypothesis of no difference in the sample means at a risk of a type I error alpha α = 0.05?
  6. _____________ What is the maximum level of confidence we can have that the difference in the means is statistically significant?
  7. _____ Is Lee Ling slower at 52 than he was at 45?

    Chapter 4: Data on the right

    The data on the right in the split time in minutes versus the split distance in meters from the 23 laps run on the evening of 29 November. This is xy scattergraph paired data.

  8. __________ Determine the sample size n for the data on the right.
  9. __________ Determine the slope.
  10. __________ Determine the intercept.
  11. __________ Determine the correlation coefficient r.
  12. __________ Determine the coefficient of determination.
  13. __________ Based on the slope and intercept, calculate the length of time for Lee Ling to joggle a 21000 meter half marathon.