# Use the exact values you enter to make later calculations. A group of students performed the…

Use the exact values you enter to make later calculations.

A group of students performed the same "Newton's Second Law"
experiment that you did in class. For this lab, assume g = 9.81
m/s2.
They obtained the following results:

m1(kg) t1(s) v1(m/s) t2(s) v2(m/s)
0.050 1.2000 0.2500 1.8108 0.3849
0.100 1.2300 0.3240 1.6360 0.6412
0.150 1.1500 0.3820 1.4768 0.8120
0.200 1.1100 0.4240 1.3935 1.0067

where m1 is the value of the hanging mass
(including the mass of the hanger), v1 is the
average velocity and t1 is the time at which
v1 is the instantaneous velocity for the first
photogate, and v2 is the average velocity and
t2 is the time at which v2 is
the instantaneous velocity for the second photogate.

(a) Use Excel
to construct a spreadsheet to do the following. (You will not
submit this spreadsheet. However, the results will be needed later
in this problem.)

(i) Enter the
above data.

(ii) Compute the acceleration, a, for each trial.

(iii) Create a graph of the hanging weight
m1g vs. the acceleration.

(iv) Use the trendline option to draw the best fit line for the
above data and determine the slope and y-intercept from
it.

 slope = y-intercept =

(b) Use the information you obtained from your graph to determine
the total mass of the system M = m1 +
m2.
M =

(c) Using the information you obtained in parts (a) and (b),
predict what the value of the acceleration would be if the value of
the hanging mass were increased tom1 = 0.50
kg.
a =