Using Excel, plot weight (in Newtons) versus displacement (x – xo).

Glencoe Physics: Principles and Problems, Student Edition
1st Edition
ISBN:9780078807213
Author:Paul W. Zitzewitz
Publisher:Paul W. Zitzewitz
Chapter14: Vibrations And Waves
Section: Chapter Questions
Problem 2STP
icon
Related questions
Question

Can someone please help answer question 1 through 3 using the data attached.

1. Using Excel, plot weight (in Newtons) versus displacement (x – xo).
2. Fit a straight line without forcing the fitted line through the origin to determine the spring
constant k. In Excel, use the "Add Trendline" function to add a linear line with the display
equation option selected.
3. Determine the slope.
What is the spring constant?
Transcribed Image Text:1. Using Excel, plot weight (in Newtons) versus displacement (x – xo). 2. Fit a straight line without forcing the fitted line through the origin to determine the spring constant k. In Excel, use the "Add Trendline" function to add a linear line with the display equation option selected. 3. Determine the slope. What is the spring constant?
Table 1: Static (non-oscillatory) force-displacement data for determining the spring constant of
the mass-spring system
Mass m (g)
Position x (cm)
Weight (N)
Displacement ( - xo) (m)
0.0
0.0
34.5
0.0
100.0
35.0
0.98
0.5
150.0
37.2
1.47
2.7
250.0
42.3
2.45
7,8
350.0
47.3
3.43
12.8
450.0
51.8
4.41
23,3
Transcribed Image Text:Table 1: Static (non-oscillatory) force-displacement data for determining the spring constant of the mass-spring system Mass m (g) Position x (cm) Weight (N) Displacement ( - xo) (m) 0.0 0.0 34.5 0.0 100.0 35.0 0.98 0.5 150.0 37.2 1.47 2.7 250.0 42.3 2.45 7,8 350.0 47.3 3.43 12.8 450.0 51.8 4.41 23,3
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Unit conversion
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, physics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Physics: Principles and Problems, Student…
Glencoe Physics: Principles and Problems, Student…
Physics
ISBN:
9780078807213
Author:
Paul W. Zitzewitz
Publisher:
Glencoe/McGraw-Hill
Principles of Physics: A Calculus-Based Text
Principles of Physics: A Calculus-Based Text
Physics
ISBN:
9781133104261
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Physics for Scientists and Engineers with Modern …
Physics for Scientists and Engineers with Modern …
Physics
ISBN:
9781337553292
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
College Physics
College Physics
Physics
ISBN:
9781938168000
Author:
Paul Peter Urone, Roger Hinrichs
Publisher:
OpenStax College
Physics for Scientists and Engineers, Technology …
Physics for Scientists and Engineers, Technology …
Physics
ISBN:
9781305116399
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning