"Uniformly" Accelerated Motion
Introduction: Some experiments yield clearcut, unequivocal data; some experiments do not. However, with enough data, some results can be deemed as trustworthy. In this lab we will take lots of data from primitive equipment and analyze it in the spreadsheet.
Theory: The theory behind uniformly accelerated motion is simple. Let a falling weight drag a tape through an apparatus which marks it at regular time intervals, t. Given this set of coordinates, the distance between each pair can be calculated. If the time for each interval is known, the quotient of x/t yields the average velocity over the interval. (This also happens to be the velocity halfway between the coordinates, called the midmark velocity.) When one subtracts consecutive average (or midmark) velocities, and divides the differences by the same time interval, one arrives at a set of accelerations. If the driving force is constant, like gravity, the accelerations would be constant, or uniform. The graph of a = a(t) would be a horizontal line. Using integration, the graph of v = v(t) would be a sloping line. What would the graph of x = x(t) look like?
These are ideal situations. In reality, our apparatus has all sorts of random variations, frictions, and uncertainties. The raw graph of a = a(t) would not be a horizontal line, the graph of v = v(t) would not be a sloping line, etc. However, using statistical analysis, we can negate to some extent the vagaries of the equipment.
Task:
 To statistically analyze data from data tapes to determine the acceleration of two falling bodies, producing six graphs and four values for acceleration
 To analyze the apparatus for flaws, errors, and uncertainties (as always)
Equipment:
Procedure:
 Set up the
apparatus as shown below:
Figure 1
 Drag the tape (by hand) through the apparatus for a measured amount of time.
 There is no switch, just plug it into the 120V outlet.
 Be sure to drag the tape at a constant speed.
 The number of dots and the pulling time is all you need from this action.
 Set up the
apparatus as shown below:
Figure 2
 Using the 20g mass, allow it to drag the tape through the tape timer. Be sure there is enough tape to reach the floor.
 Lay the tape
on a meterstick and record the POSITION of (not the distance between)
each mark.
 Repeat 35
for the 100g mass.
Spreadsheet:
 Title your file and label columns with units!
 Make a single cell for time/dot from the first procedure (pulling the tape by hand), then refer to this cell when you need t.
 Make a column for the raw data, the position of each mark.
 Next to this column, calculate the difference between positions.
 e.g. B2:(A2A1), B3:(A3A2)
 Next to this column, calculate the quotient of X/t.
 X is the difference between positions.
 t is the time interval derived from the 2) procedure.
 Find t by dividing the "pulled" time duration by the number of dots during that duration.
 You should have this number calculated somewhere in your sheet.
 these are average or midmark velocities
 Next to this column, calculate the difference between average velocities (V).
 Next to this column, calculate V/t. These are your accelerations.
 Make a column for elapsed time.
 This could be made using multiples of the incremental time.
 These values will be used for graphing.
 Compute the average acceleration. This is your first value for acceleration.
Graphs for 20g Mass:
Be sure to
title, label and grid your graphs!
 Acceleration vs time:
 Type of graph: XY
 X: elapsed time
 A (first series): computed accelerations
 Trendline: which (line, power, polynomial, exponential) will you choose? Show the equation and the intercept on your chart.
 For Series 1 select the series by rightclicking on a datum. Under Chart Tools / Layout choose the Error Bars pull down menu. Choose Error Bars with Standard Deviation.
 Right click on any x error bar to delete them all.
 Y error bars are a good way of showing data variation around a specified value.
 Your second value for acceleration lies here.
 Velocity vs time
 Type of graph: XY
 X: elapsed time
 A: computed velocities
 Trendline: which will you choose? Show the equation and intercept on your chart.
 Your third value for acceleration lies here.
 Displacement vs time
 Type of graph: XY
 X: elapsed time
 A: displacement (raw data)
 Trendline: which will you choose? Show the equation and the intercept on your chart.
 Your fourth value for acceleration lies here.
 Repeat for
100g mass. You will have 6 graphs in your report.
Questions:
 Full analysis on what affects this experiment: Why such great variations in results? How certain are you about your data? Your calculations? Use your understandings from the Uncertainty, Statistics and Measurement exercise.
 On the v(t) graph, what does the y intercept represent?
 What do the quadratic coefficients b and c represent?
 Make a table (below) and compare the four values for acceleration for each of the two masses. Which is the most trustworthy (and by this I DON"T mean closest to g)?

20g 
100g 
average 


accel. graph 


vel. graph 


displace. graph 

