We will study the motion of a freely falling body and, in particular, measure the acceleration due to gravity. With the apparatus supplied, an object is allowed to fall freely and its positions at the ends of successive time intervals are recorded on a strip of paper by means of electric sparks. The experiment will first be demonstrated for the class.
The falling body B is initially suspended by the electromagnet M. When the body is released, it falls parallel to two vertical wires W, one of which, W1, is covered with a strip of paper P as shown in the top view to the left.. A spark timer provides a large electrical voltage across the wires every 1/60th of a second. The voltage difference is not sufficient to allow a spark to jump the full space between the wires, but a spark can jump from W2 through the conducting ring on the body B, and through the paper P to wire W1. Such a spark will leave a mark on the paper strip and thus record the position of the falling body every 1/60th of a second.
Data and Analysis:
Place a meter stick on the paper strip such that the graduated edge lies along the line of spots. The spot you have numbered 0 does not need to be located at the end of the meter stick. Keeping the meter stick stationary, read the position of each spot (distance from spot 0) and record the value in the second column. Remember to report your measurements to 1/10th of the smallest scale division.
Using the Excel Commands appendix of this manual or the online help, create a graph of position versus spot number. (This is equivalent to position versus time.) As expected, your graph is not a straight line. But we do expect a linear relationship between speed and time.
average speed = displacement / time interval.
Note that the displacement is not the same as position, it is the displacement for each interval of time. In the third column, at the cell in the same row with the spot numbered 0, enter the formula
= (y1 - y0) / (1/60),
where y1 and y0 are the addresses of the cells containing the positions of spot numbers 1 and 0, respectively. Then use the Copy command to complete the corresponding calculations for the entire column. Don't use the cell in the same row with your last numbered spot.
= 1/120 + 1/60*(spot number),
where (spot number) is the appropriate cell designation.
The y-intercept b is in this case the average speed at time t = 0 and the slope m is the acceleration. Do you see why? What is the significance of b?
How does your slope compare with the accepted value for the gravitational acceleration, g = 9.80 m/s2? Use 90% confidence intervals in your comparison.
To display the best-fit line on the graph you will use the add trendline command. In your graph, select a data point by a right-click on that point. You will be prompted for a choice, choose Add Trendline (Note: the Source Data option can be used to change you data set). Choose the Options tab and check display equation on chart, which gives you the equation of the best-fit line. Click OK and your graph will appear with the best-fit line through your data. You can see how closely the data points lie to the best-fit line. In fact, the scatter of the data points around the best-fit line is due to the presence of random error.
Title your graph, label the axes, and print it.