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? |