**
**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, W_{1},
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 W_{2} through the conducting ring on the body B, and
through the paper P to wire W_{1}. 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:**

- Create a spreadsheet for the data. Remember to include a title for your spreadsheet and labels for each column of numbers. Place the paper strip on a flat surface. Circle each of the spots with a pencil and number them 0, 1, 2, 3, etc. Enter these spot numbers in the first column of the spreadsheet. The spot numbers are the number of 1/60th second time intervals which have elapsed since the initial spot was made.
- Compute the
**average speed**of the falling object during each 1/60th second time interval: - The time we associate with an average speed is at the midpoint of the time interval.
Calculate
**time**in the fourth column using the formula - Create a graph of average speed versus time. Does your graph approximate a straight line? If air resistance is negligible, a falling object would experience a constant acceleration due to gravity and, therefore, its instantaneous speed versus time graph would have a constant slope. (If the speed increases linearly with time, the average speed over the time interval corresponds to the instantaneous speed at the midpoint of the interval.)
- To determine the acceleration due to gravity we need to find the slope of the line which
best fits the data in this graph. Use the spreadsheet command
**linest**: select time as the independent variable and average speed as the dependent variable. This command and the output are described in the Excel Commands appendix. - Print the spreadsheet for your notebook.
**What are some possible sources of error in this experiment?**

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

= (y_{1} - y_{0}) / (1/60),

where y_{1} and y_{0} 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/s ^{2}? 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.