The following data was obtained by a student doing tin: Ball-Drop Lab: Distance
ID: 2054769 • Letter: T
Question
The following data was obtained by a student doing tin: Ball-Drop Lab: Distance of Drop (m) / Average Time of Drop (sec) .80 / .43 .70/ 37 .60/ 35 .50/32 .40 / .28 Using Excel make a table that includes the Average Time. Time Squared. Distance, and Calculated g. Show the Average g. Use Excel to do the calculations for g and HAND-WRITK next to the table your "Excel Speak" equation Make a distance (y) vs. time squared (x) graph Make a best fit line and show the equation of the line. Find the % error from the equation of the graph.Explanation / Answer
Ok, so first off you need to open excel. Label the columns in the top row as follows. Average time Time Squared Distance Calculated g In the first column list all of the times from the lab: 0.43 0.37 0.35 0.32 0.28 In the second column, put something like "=B1^2" and excel will square those times. Pull down the little blue box in the corner of the cell and the calculation will repeat itself. In the third column, list all of the distances 0.8 0.7 0.6 0.5 0.4 In order to fill out the fourth column, we have to recall one of the equations of motion. x=xo+vot+1/2at^2 The object starts from rest so vo = 0 and the acceleration is g. So, d = 1/2gt^2 Lets rearrange for g. g = 2d/t^2 Okay so then the fourth column needs to multiply the third column by 2 and then divide by the second. That would be something like "=(B3*2)/(B2^2)". As far as the graph goes, have excel make a scatter plot of your 3rd column on the y-axis and 2nd column on the x-axis. Once you have the plot you can right click and select "add trendline". Right click on the trendline and select "format trendline" and look for a checkbox that says "display equation on chart". The slope of this line should be 1/2g. so multiply the slope by 2 to get a value for g.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.