Question: I need help to understand this using excel, the paper have the answers but how do I get them using excel pls help Practice 2

I need help to understand this using excel, the paper have the answers but how do I get them using excel pls help

I need help to understand this using excel, the paper have the

Practice 2 Assume that the following data was collected experimentally. Time, t (s) Height, H (m) 1 0.52 2 1.89 3 4.38 4 7.92 1. Use this data to create a graph of ? vs H (y-axis vs x-axis) - use Excel 2. What is the intercept (b) of the graph? - use Excel 0.0776 s2 3. What is the slope (m) of the graph? - use Excel 2.018 s2/m 4. Using slope and the equation t = 7 2H V g find g - Use Excel or Calculator 9.78 m/s2 5. Calculate the % discrepancy for the g value. Use actual value of g = 9.81 m/s2 - use Excel or Calculator %discrepancy = X actual - Xexperimental x 100 X actual % discrepancy = 0.31% Answer: 9.78 m/s2 (0.31%) Please note that intercept and slope may have units which should be included

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Physics Questions!