Answer Happy

Need help with the data analysis section. Not sure is the acccolumn is filled out correctly so please disregard if it is notcorrect.
tavs (5) ~ 1.8m Data Collection Table: (create your own in EXCEL) Freefall Data Collection Table Height Height Time Time Time ( cm ) (5) (m) Trial 1 Trial 2 Trial 3 200 0.6331 10.6347 10.6346 10.6341 180 0,6005 10.60o2 10.6008 Loiboos 166 îliom 10.5694 10,sille 10,5699 To 530 u 1,4m 0,5314 10,5313 10.5311 To 53126 - 120 liam 0,4944 10.4947 10.1950 To 4947 100 lm 10.4505 No.4509 12u541 10.4545 80 a O.om 10.3968 0.3982 10.3988 10.39793/ 60 0.6m 0.3466 0,3464 0. 3998 0.3476 Data Analysis 1. Create a table in EXCEL using the template "Freefall Data Analysis Table" below. Determine the proper equation to find the average acceleration (ponder your kinematics equations for uniformly accelerated motion) and percent difference (see error handout) and input equations to have EXCEL perform the calculations to fill the table. 2. Have EXCEL, plot height (on the vertical or y-axis) and 1 (on the horizontal or x-axis) and then have it perform a linear regression. Your graph should show the best fit line equation and the R value. Once you have your graph, print it out and include it in your lab report. 3. Comment on your results: What did you find? What was expected, what was surprising? Explain. Freefall Data Analysis Table acc % diff Height ( m ) 6,6341 s -9.31 1,8 m 0, 6005 s lib m 0.57013 s -9, 017 1.4 in 10.53126 -9,81 0,4947 -9,81 Sa I m 0.4545 s -9.81 o.f 0.3979 -9,8192 0.6 m 0,3476 s T -9.81 T These columns must be filled in with EXCEL equations. You will print out both the data table AND show the equations used for calculating these cells.