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 - vA 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.