Removing the Linear Trend from Data Set with x and y Values

  • Thread starter Thread starter andrey21
  • Start date Start date
  • Tags Tags
    Data Linear Set
Click For Summary
To remove the linear trend from a dataset with x and y values, the process involves plotting the values, establishing a linear trend line equation in the form y = mx + c, and substituting x values back into this equation to generate new y values. The calculated line equation y = 0.0832x - 104.54 was derived using Microsoft Excel based on two points. After obtaining the new y values, the next step is to subtract these from the original y values to effectively remove the linear trend. This method is confirmed as a valid approach for detrending the data. The discussion emphasizes the importance of correct calculations and the steps involved in the process.
andrey21
Messages
475
Reaction score
0
1. Now I have been given a data set with values for x and y. The question states to remove the linear trend.




Am i right in doing the following:

Plotting the two values against each other on a graph
Establishing a linear trend line equation in the form y =mx + c
Finally substituting values for x back into linear trend equation to give me new values for y??

Any feedback would be great thanks
 
Physics news on Phys.org
Given two points (x1, y1), (x2, y2), what is the equation of the line passing through these points?
 
Well I have calculated the line to be y = 0.0832x-104.54. This has bin done using Microsoft Excel. Now is the next step I stated above correct to sub values back into get new y values.
 
Any more opinions?
 
Well, if you started out with two points, and if you want a linear interpolation for some other value, then it seems to be a correct approach.
 
Ok well i have now subtracted the newly established y values from the original data set, so is this a correct method of removing the linear trend?
 
Question: A clock's minute hand has length 4 and its hour hand has length 3. What is the distance between the tips at the moment when it is increasing most rapidly?(Putnam Exam Question) Answer: Making assumption that both the hands moves at constant angular velocities, the answer is ## \sqrt{7} .## But don't you think this assumption is somewhat doubtful and wrong?

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 4 ·
Replies
4
Views
5K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 7 ·
Replies
7
Views
2K
Replies
3
Views
1K