My Math Forum (http://mymathforum.com/math-forums.php)
-   Elementary Math (http://mymathforum.com/elementary-math/)
-   -   Relation between two sets of data (http://mymathforum.com/elementary-math/153037-relation-between-two-sets-data.html)

 aspn August 29th, 2015 12:00 PM

Relation between two sets of data

I am struggling to find the relation between two set of numbers:furious:, I have the following relation. I need to find an equation or a way to establish the relation in between these values

x1 x2
A 339 1073
B 0 90

y1 y2
C 521 103
D 0 1

In the first set, when x1 shows as 339 its actual value is 0 (Row B) and when 1073 it is 90. What I am trying to find is an equation or a way to calculate the values for say 500 in first row A. The data in the second row (ie, 0-90) is fixed but the values between 339-1073 will change. I want to find the value value between 0-90 when the value in the first row is specified. Say, if the value in row A is 500, what will be its equivalent value in row B.

Similarly, I want to find a relation in the y series. Can someone help me or lead me in the right direction?

 skipjack August 29th, 2015 12:07 PM

Where do these values come from?

 aspn August 29th, 2015 12:16 PM

Quote:
 Originally Posted by skipjack (Post 337131) Where do these values come from?
I have a lot of data from work. I am trying to find the relation and set a formula in Excel to predict values in between. I cannot just find the difference and use it as a multiplication factor. It simply does not work.

 mathman August 29th, 2015 01:12 PM

The simplest solution is a straight line fit.

 aspn August 29th, 2015 01:48 PM

Quote:
 Originally Posted by mathman (Post 337140) The simplest solution is a straight line fit.
You mean like using a straight line equation, y = mx + c.

I thought about that at first but since I have only two values, fitting a line between those two points will lead to a lot of inaccuracy. Is there a better solution than that? Please. :)

 studiot August 30th, 2015 12:26 AM

Quote:
 I have a lot of data from work but since I have only two values
How are these two statements compatible?

If you can't be bothered to tell us the full story then you are wasting your own time as well as everyone else's.

 mathman August 30th, 2015 01:04 PM

Quote:
 Originally Posted by aspn (Post 337151) You mean like using a straight line equation, y = mx + c. I thought about that at first but since I have only two values, fitting a line between those two points will lead to a lot of inaccuracy. Is there a better solution than that? Please. :)
If you have only two values, a straight line fit will be exact for these two values.

 aspn September 1st, 2015 09:44 AM

Quote:
 Originally Posted by mathman (Post 338346) If you have only two values, a straight line fit will be exact for these two values.
I agree. I used the straight line fit and I am getting expected results. Thank you very much for your help.

 All times are GMT -8. The time now is 02:03 AM.