Use the exact values you enter to make later calculations. A group of students,

Question

Use the exact values you enter to make later calculations.

A group of students, performing the same Uniformly Accelerated Motion experiment that you did in lab, dropped a picket fence through a photogate and obtained the following data from the computer.

Blocking Times: 0.06027, 0.10066, 0.13317, 0.16117, 0.18594, 0.20890, 0.22974

The band spacing is 0.06 m.

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

(i) Calculate the accelerations.

(ii) Calculate the average of the accelerations.

(iii) Create a graph of velocity versus time.

(iv) Use the trendline option to determine the slope.

(v) Report your results below.

(b) What is the average acceleration? (Give your answer to four significant digits.)

(c) What is the average acceleration aaverage as determined from the slope? (Give your answer to four significant digits.)

(d) What is the percent difference between the values of the acceleration you obtained in (b) and (c) above?

Explanation / Answer

Times: Blocking times
Distance: increments of 0.06, so 0 up to 0.42
Average Time: (T1+T2)/2=T12, (T2+T3)/2=T23...
Average Velocity: (V2-V1)/(T2-T1)=V12, (V3-V2)/(T3-T2)=V23, ...
Average Acceleration: (V23-V12)/(T23-T12)...

Then take all of your Average Accelerations and add them up then divide by 6 to get the answer.

Next open excel
in excel make % columns labeled time(s),Distance,Average Time, Average Velocity, Acceleration
fill in the time (0.0000 to 0.1981)and distance (0 to .42) should have 8 rows of numbers and two columns filled in at this time.
(I started my time 0.000 in column B2 keep that in mind when I give formulas)
Next in Cell D3 type in the formula =((C3-C2)/(B3-B2)) , a number should appear. In the bottom right of that cell there should be a dot click and drag it down until cell D9. You should have numbers appearing.
Then in the the column average time type the formula =(B3-B2)/2 into cell E3. Then drag dot to E9.
Finally for the column acceleration type formula =((D4-D3)/(E4-E3)) into cell F4 then drag dot to F9.

(V) 1) Under Excel you need to make 5 column headings: Time, Distance, Average Time, Average Velocity, and Average Acceleration. Both Times and Distance should have 8 boxes rows of info, Average time and Average Velocity should have 7, and then Average Acceleration will have 6. Here is how to fill the columns out:

Times: the numbers you have above
Distance: increments of 0.06, so 0 up to 0.42
Average Time: (T1+T2)/2, (T2+T3)/2...
Average Velocity: 0.6/(T2-T1), 0.6/(T3-T2), ...
Average Acceleration: (V2-V1)/(Tavg2-Tavg1), (V3-V2)/(Tavg3-Tavg2), ...

2) Make another Excel sheet and in Column 1 put the Average Times, and in Column 2 put the Average Velocities. Then highlight both columns and click on insert --> Chart, from the tool bar up top. Then click on scatter plot, select the one with no line between the plots and a graph comes up. Next, click on anyone of the points to select it, and then right click on it, and choose add treadline. Make the line linear and select "show line equation." Use the slope (the # in front of the x).

3) Percent difference is (x1-x2)/(x1).

For the graph you highlight data then click scatter plot.. create graph.Right click- select data. click to remove distance, average time, and acceleration. Then make the trendline which is linear and it should be the slope. hope this helps:)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.