Experiment 8
FREE FALL

ANALYSIS


1.  For each of the 10 runs, find the average of all the acceleration values by adding them up and dividing by the number of points. Find the Standard Deviation of the Mean, sm, in the acceleration for each drop. Enter the results in cells C34:G35 and C67:G68 on the Worksheet. Use the sm as the uncertainty in the acceleration determination.

HINT: Use the "= AVERAGE(:)" function for each data set (each drop). To find sm, use "= STDEV(:)/SQRT(5)" since there are five data points in each drop.

2.  Find the grand average acceleration for all 10 drops and record the result in cell G77. Average the sm values for all 10 drops and record the result in cell G78.

3.  Find the average Slope of the Velocity vs. Time plots for all 10 drops, and record the results in cell G80. Average the Uncertainty in the Slope for all ten drops, and record the result in cell G81.

4.  Calculate the percentage difference between the acceleration results and the velocity-slope (results in cells G77 and G80), using the Slope as the accepted value, and enter the result in cell G84. Answer Question 1 on the Worksheet.

5.  Compare the grand average acceleration with the accepted value of the acceleration due to gravity, g = 9.8 m/s2, and calculate the percentage error. Enter the result in cell G94.

6.  From Equation (1) in the introduction, the slope of the tangent line on the Distance vs. Time plot represents the instantaneous velocity. From the 10th drop Distance vs. Time Data, determine the initial (near t = 0) velocity and record the value in cell E104. From the final and initial slope data, determine the average acceleration over the interval by using Equation (2), where the average acceleration is equal to the change in velocity divided by the difference in times. Record the value of the average acceleration in cell E106.

7.  Answer Question 2 on the Worksheet.

8.  Obtain a printout of the Worksheet by selecting the Excel window and choosing FILE...PRINT and turn it in to your instructor.