Experiment 05


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 in the acceleration, sm, 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 (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.

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 accleration with the accepted value of the acceleration of gravity, g = 9.8 m/s2, and calculate the percentage error. Enter the result in cell G94.

6.    From Equation (1), the slope of the tangent line on the Position vs. Time plot represents the instantaneous velocity. From the 10th drop Distance vs. Time Data, determine the initial 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 acceleration is equal to the change in velocity divided by the difference in times. Record the value of the acceleration in cell E106.

7.    Answer Question 2 on the Worksheet.