Hello,

I need help with Hooke's law, I have attached a screenshot of my excel spreadsheet with my numbers: These are the following questions I need to be answered if possible

Questions:

1. Calculate the acceleration due to gravity, g, by plotting m vs. |y - y₀|. Use the slope of this graph along with k_static you found in the lab to determine g. (please show graph on excel)

2. What is the percent error between the acceleration due to gravity you determined in question 1 and the known value of g?

3. When a box of unknown mass is placed into the trunk of a car, both rear shocks are compressed a distance of 7.0 cm. If we assume the two rear shocks are made from springs, each with a spring constant value ofk= 35,000 N/m, what is the mass of the box? (Assume g = 9.80m/s²).

4. When a 0.50 kg mass is attached to a vertical spring, the spring stretches by 15 cm. How much mass must be attached to the spring to result in a 0.75 sec period of oscillation?

from the excel spreadsheet, I need the Kstatic, Kdynamic, and percent error, Thank you

AutoSave O OFF MAP ? C ... Hooke's Law Data Sheet-1 (3) Q . Search Sheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) A ab v General Insert v 2 x Delete v Paste BIUV A += $ % Conditional Format Cell Sort & Find & Formatting as Table Styles Format Filter Select H7 X V fx B C D E F G H K M N O mass (kg) Weight (N) yo (m) y (m) Displacement, y - yo (m) T (s) T? (s? ) 0.5 0.037 37 37 6.1 37.21 Questions: 0.1 0.120 37 44 7.32 53.58 1. Calculate the acceleration due to gravity, g, by plotting m vs. ly - yol . Use the slope 0.15 0.146 44 51 9.57 91.58 of this graph along with kstatic you found in the lab to determine g. 0.2 0.183 51 57 10.2 104.04 0.23 0.48 56 57 10.73 115.13 2. What is the percent error between the acceleration due to gravity you determined in question 1 and the known value of g? 3. When a box of unknown mass is placed into the trunk of a car, both rear shocks are 10 compressed a distance of 7.0 cm. If we assume the two rear shocks are made from springs, each with a spring constant value of k = 35,000 N/m, what is the mass of the 11 box? (Assume g = 9.80m/s2). Kstatic: Kdynamic 4. When a 0.50 kg mass is attached to a vertical spring, the spring stretches by 15 cm. How much mass must be attached to the spring to result in a 0.75 sec period of oscillation? %diff: Sheet1 + Ready Accessibility: Good to go + 120%