Experiment 09
WORK AND
ENERGY-Practical
ANALYSIS
1
AT THIS POINT, IT IS A GOOD IDEA
TO MAKE SURE THAT ALL QUANTITIES ARE EXPRESSED IN SI UNITS (kg, m and s)
1. In
the three columns to the right of data spreadsheet, label the headings
vAin
cell F13, vB in cell
G13,
and Dv2
in
cell H13. Do the same for cells F21, G21, and H21,
respectively. Calculate vA,
vB,
and Dv2
= vB2 - vA2
for each measurement.
HINT:
The velocity at each point can be calculated using the width of the glider
and the elapsed time. For example, in the case of point A, we want:
vA=
w/DtA.
Use the Worksheet to figure it out. In cell F14, enter: "
=
$F$9/D14". Select all the cells for the downward motion, from
F14
to F18, and choose the menu under EDIT....FILL
Down. Do a similar thing for point B data, beginning
in cell G14. Note that the width of the glider is still at $F$9
in this calculation, but that here the time is in cell E14.
Repeat these steps for the upward motion in cells F22 to G26.
To determine the difference in the
squares of the velocities, vB2 -
vA2, set up the following
equation in cell H14: " = G14^2 - F14^2"
, and similarly in cell H22: "= G22^2
- F22^2". Once again, use EDIT....FILL
Down to complete each table.
2.
The quantity vB2
- vA2
should be the same within the experimental uncertainty of the experiment
for all measurements taken with the same value of H. Find the average
value of vB2 - vA2
for motion down the incline, and enter it in cell H19.
HINT:
In cell H19, enter the following: " = AVERAGE(H14:H18)".
This is simply the average of all the values. Repeat for motion up the
incline in cell H27.
3.
Calculate the difference h in the vertical heights of the track
at A and B from the equation:
(4)
and enter it in cell G35.
HINT:
The calculation can be done using the spreadsheet. In cell G35,enter:
" = F11 * F29/F31" .
4. From
Equation
(2), determine the acceleration of gravity g, by dividing the
average value of vB2
- vA2 by 2
h in each case.
HINT:
The calculation can be done using the spreadsheet. In cell G37,
enter: " = H19/(2 * G35)" . In
cell G39 enter "= H27/(2 * G35)"
5.
Answer Questions 1 through 5
in the Workbook. Print out the spreadsheet and use it to develop
your lab report.