Confused on recieving just one K value for elongation and oscilliation

Click For Summary
SUMMARY

The discussion centers on calculating the spring constant (K) using Hooke's Law based on experimental data from a spring-mass system. The user observed slight variations in K values when using different masses, specifically 4.311 for 0.05 kg and 4.317 for 0.06 kg. The consensus is that these variations are due to experimental error, and the user should aim to derive a single average K value from the trendline of their graph. To achieve this, the user needs to select a point on the trendline using Excel to apply the formula F = k(y - yo).

PREREQUISITES
  • Understanding of Hooke's Law and its application in spring mechanics.
  • Familiarity with graphing techniques and trendline analysis in Excel.
  • Basic knowledge of experimental error and its impact on measurements.
  • Ability to manipulate equations to solve for unknown variables.
NEXT STEPS
  • Learn how to create and manipulate trendlines in Excel for data analysis.
  • Study the principles of experimental error and how to minimize it in physics experiments.
  • Explore advanced applications of Hooke's Law in different spring systems.
  • Understand the significance of averaging multiple measurements in scientific experiments.
USEFUL FOR

Students in physics, particularly those conducting experiments involving springs and oscillations, as well as educators teaching concepts related to Hooke's Law and data analysis in Excel.

Crusaderking1
Messages
158
Reaction score
0
Confused on receiving just one K value for elongation and oscillation

Homework Statement



Ok. For lab, I had to place 5 different masses on a spring and calculate its initial and final position. I did this with a small, medium and large spring.

Then after I gathered my values, I made a graph, and fit a trendline through it.

The book says to use the slope and Hooke's law to find the K constant. However, when I use the slope and equation, I get very slightly different K constant values for the different masses on the same string. (like 4.311 for 0.05kg, and 4.317 for 0.06 kg).

How am I suppose to get just one K constant using the slope and equation? The book probably would have told me to average the K values if I was meant to get more than one.


Same scenario applies for the oscillation of the spring.

What should I do? Thanks.



Homework Equations





The Attempt at a Solution

 
Last edited:
Physics news on Phys.org
The spring constant probably did not change. It was an experiment! There is going to be error (your numbers were still pretty close).
 
Spinnor said:
The spring constant probably did not change. It was an experiment! There is going to be error (your numbers were still pretty close).

Yes, I see your point.

I am suppose to use the slope to find one k value. I suppose that the trendline is suppose to provide values of the line that all equal the "average k", which I think I need.

However, I do not know how to choose a point on the trendline using excel(not a point used to find the trendline).

I think that's what I need, since I can plug that y-value and x-value into the equation F=k(y-yo), which will give me the one k value I need. I just don't know how to select a point on the trendline.
 

Similar threads

  • · Replies 10 ·
Replies
10
Views
2K
Replies
6
Views
2K
Replies
3
Views
2K
Replies
1
Views
1K
  • · Replies 18 ·
Replies
18
Views
6K
  • · Replies 17 ·
Replies
17
Views
3K
Replies
25
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 11 ·
Replies
11
Views
5K
Replies
3
Views
2K