,
s, and sm for both partners' runs are automatically
computed by the spreadsheet in machine units for the restricted samples
of measurements 1-5, 1-10, 1-25, and 76-100. Consider these results and
answer Questions 1 through 3 in the Worksheet.
ANALYSIS
The Analysis section of each
experiment will provide you with a guide to what calculations and plots
must be performed on the Worksheet.
1. The values of
,
s, and sm for both partners' runs are automatically
computed by the spreadsheet in machine units for the restricted samples
of measurements 1-5, 1-10, 1-25, and 76-100. Consider these results and
answer Questions 1 through 3 in the Worksheet.
2. A histogram, or frequency
plot, will also automatically be produced for all 100 measurements in both
runs at rows 137 and 152. Disregard the data in rows 119
through 135; they are used to produce the histogram.
Click the media button (next to the zoom percentage box). Then select the arrow drawing tool to put an arrow at the times corresponding to:
,
± s,
± 2s.
HINT: After selecting the Arrow tool you can hold down the SHIFT key while you move the cursor, and a vertical or horizontal arrow will be drawn. In this case you want to mark the points with a vertical arrow.
3. Using the raw data from
the data tables, determine the percentage of all 100 measurements
that lie between ± s, and enter the results in cells G172 and G177.
Repeat for ± 2s, and enter the results in cells G173 and G178.
Answer Question 4 in the Worksheet.
4. Average the number of machine units from the three calibration runs (in cells F73:F75) and enter the result in cell F187 in the Worksheet. Divide 180 sec by this value to find the conversion factor in seconds per machine unit, and enter the result in cell F188.
HINT: It is easy to use the spreadsheet as a calculator to do this. In cell F188, enter: "= 180/F187".
5. Use this result to compute
,
s, and sm in seconds
by multiplying the values found in machine units in cells F34, F36
and F38; and in cells F64, F66 and F68, by
the conversion factor in cell F188. Record the results for both
partners in cells C191
through E192. Try using the spreadsheet as a calculator.
(No HINT this time!)
6. Compare your reaction time with your partner's reaction time by answering Question 5. The differences are significant if the average values differ by more than the sum of the associated uncertainties in the average values. Take the uncertainty in the average value to be equal to sm in each case.
7. Obtain a printout
of the Worksheet and use it to develop your completed lab report.