There is .06 m between each time given What is the average acceleration? (Give y

Question

There is .06 m between each time given

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

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

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

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 (s) 0.07376 0.11703 0.15111 0.17994 0.20566 0.22890 0.25022 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.

Explanation / Answer

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

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), ...

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

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).

*Use calculator or Excel functions to calculate everything

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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