1.Use graphing software to create a graph of Applied Force on the vertical axis versus displacement on the horizontal axis for the data collected when the spring constants for the left and right spring were both 200 N/m. 2. Add the data for the other two sets of spring constants to the same graph with trendlines for each data set. Include equations for the trendlines, a graph title, and axis titles with appropriate units. Data Table 3: Springs in Series Applied Left Spring Force (N) Force Right Spring Force on Applied Force (N) Right Spring Force on Left Spring(N) Displacement (m) Spring Constant (Nm) (N) Left Spring Constant-200 Nim. Right Spring Constant-200 N/m 20 -20 20 50 -50 50 100 -100 100 -50 50 -50 Top Spring Constant-200 Nim, Right Spring Constant-500 N/m 20 -20 50 -50 100 -100 -50 50 Top Spring Constant-300 Nim, Right Spring Constant-500 N/m 20 20 50 -50 100 100 -50 50 A 20 50 100 50 R༞ ༅ ༞ R 8 ཇོ 8 0.2001 100 0.500 1.000 -0.500 142.86 0.140 0.350 0.700 -0.350 20 20 0.107 187.50 50 50 0.267 100 100 0.533 50 50 -0.267

College Physics
11th Edition
ISBN:9781305952300
Author:Raymond A. Serway, Chris Vuille
Publisher:Raymond A. Serway, Chris Vuille
Chapter1: Units, Trigonometry. And Vectors
Section: Chapter Questions
Problem 1CQ: Estimate the order of magnitude of the length, in meters, of each of the following; (a) a mouse, (b)...
icon
Related questions
Question
100%

i need help creating a graph using excel or simular for my data in the attached photo. Thanks

1.Use graphing software to create a graph of Applied Force on the vertical axis versus displacement on the horizontal axis for the data
collected when the spring constants for the left and right spring were both 200 N/m.
2. Add the data for the other two sets of spring constants to the same graph with trendlines for each data set. Include equations for the
trendlines, a graph title, and axis titles with appropriate units.
Data Table 3: Springs in Series
Applied Left Spring Force (N)
Force
Right Spring Force on Applied Force (N)
Right Spring Force on Left Spring(N)
Displacement (m)
Spring Constant (Nm)
(N)
Left Spring Constant-200 Nim. Right Spring Constant-200 N/m
20
-20
20
50
-50
50
100
-100
100
-50
50
-50
Top Spring Constant-200 Nim, Right Spring Constant-500 N/m
20
-20
50
-50
100
-100
-50
50
Top Spring Constant-300 Nim, Right Spring Constant-500 N/m
20
20
50
-50
100
100
-50
50
A
20
50
100
50
R༞ ༅ ༞ R 8 ཇོ 8
0.2001
100
0.500
1.000
-0.500
142.86
0.140
0.350
0.700
-0.350
20
20
0.107
187.50
50
50
0.267
100
100
0.533
50
50
-0.267
Transcribed Image Text:1.Use graphing software to create a graph of Applied Force on the vertical axis versus displacement on the horizontal axis for the data collected when the spring constants for the left and right spring were both 200 N/m. 2. Add the data for the other two sets of spring constants to the same graph with trendlines for each data set. Include equations for the trendlines, a graph title, and axis titles with appropriate units. Data Table 3: Springs in Series Applied Left Spring Force (N) Force Right Spring Force on Applied Force (N) Right Spring Force on Left Spring(N) Displacement (m) Spring Constant (Nm) (N) Left Spring Constant-200 Nim. Right Spring Constant-200 N/m 20 -20 20 50 -50 50 100 -100 100 -50 50 -50 Top Spring Constant-200 Nim, Right Spring Constant-500 N/m 20 -20 50 -50 100 -100 -50 50 Top Spring Constant-300 Nim, Right Spring Constant-500 N/m 20 20 50 -50 100 100 -50 50 A 20 50 100 50 R༞ ༅ ༞ R 8 ཇོ 8 0.2001 100 0.500 1.000 -0.500 142.86 0.140 0.350 0.700 -0.350 20 20 0.107 187.50 50 50 0.267 100 100 0.533 50 50 -0.267
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
College Physics
College Physics
Physics
ISBN:
9781305952300
Author:
Raymond A. Serway, Chris Vuille
Publisher:
Cengage Learning
University Physics (14th Edition)
University Physics (14th Edition)
Physics
ISBN:
9780133969290
Author:
Hugh D. Young, Roger A. Freedman
Publisher:
PEARSON
Introduction To Quantum Mechanics
Introduction To Quantum Mechanics
Physics
ISBN:
9781107189638
Author:
Griffiths, David J., Schroeter, Darrell F.
Publisher:
Cambridge University Press
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Lecture- Tutorials for Introductory Astronomy
Lecture- Tutorials for Introductory Astronomy
Physics
ISBN:
9780321820464
Author:
Edward E. Prather, Tim P. Slater, Jeff P. Adams, Gina Brissenden
Publisher:
Addison-Wesley
College Physics: A Strategic Approach (4th Editio…
College Physics: A Strategic Approach (4th Editio…
Physics
ISBN:
9780134609034
Author:
Randall D. Knight (Professor Emeritus), Brian Jones, Stuart Field
Publisher:
PEARSON