Data Analysis with Microsoft Excel: Updated for Office 2007

274 Fundamentals of Statistics

Have you accepted the null hypoth-

esis, or is there evidence that reaction

times do change from one round to

another?

21. Return to your analysis of the results
    of the 1996 100-meter dash. This time,
    analyze the race times from the three
    rounds of the race.
    a. Open the Race workbook from the
    Chapter06 folder and save it as
    Race Results Analysis.
    b. Perform a paired t test of the race
    times (use the Race1, Race2, and
    Race3 variables), comparing the

differences between Round 1 and

Round 2 and then Round 2 and

Round 3. Is there signifi cant evidence

that the race times decrease as the

runner advances in the competition?

Calculate the 95% confi dence interval

for the change in race time.

c. Save your changes to the workbook

and write a report summarizing your

results, including any descriptive

statistics and p values. Does your evi-

dence suggest any difference in the

competition level as a runner goes

from Round 1 to Round 2 as compared

to going from Round 2 to Round 3?