Experiment 7


At this point, DOUBLE CHECK to make sure that all data entries are expressed in SI units (meters, kilograms, seconds).

1.  In cell C30, enter the number "1". You need a serial number for each trial, so begin with mouse down at C30 and drag down through cell C36. Then use EDIT...FILL...Series. Click OK on the dialog box, and C30:C36 should contain the number of washers used in each trial (1 through 7).

2.  In cell E30, enter "= C30 * $G$11 * 9.8" to calculate the washer's weight in trial 1. This calculation takes the number of washers used in this trial and multiplies by the mass of each washer times the acceleration due to gravity to give the weight of the washer. Use EDIT...FILL....Down as before to populate cells E30:E36.

3.  Use the mouse to select all the cells from D30:E36, that is all the acceleration and falling mass data, including the headings.

4.  Click on any one of the data points.

5.  From this fitting equation, record the values of the slope and the intercept in cells F62 and F64, respectively. Ideally, the slope should be equal to the total mass of all 7 washers plus the glider. We know however, from Equation (1) in the Introduction that the "effective" mass of the pulley also enters in as part of the slope.

HINT: You can set up the spreadsheet to calculate this value: the total mass is recorded in cell G13, and the fitted value in F62.

6.  Answer Questions 1 through 4 on the Worksheet.

7.  Print out of the Worksheet and turn it in to your instructor.