My Math Forum Relation between two sets of data
 User Name Remember Me? Password

 Elementary Math Fractions, Percentages, Word Problems, Equations, Inequations, Factorization, Expansion

 August 29th, 2015, 01:00 PM #1 Newbie   Joined: Aug 2015 From: India Posts: 4 Thanks: 0 Relation between two sets of data I am struggling to find the relation between two set of numbers, 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?
 August 29th, 2015, 01:07 PM #2 Global Moderator   Joined: Dec 2006 Posts: 20,113 Thanks: 1909 Where do these values come from?
August 29th, 2015, 01:16 PM   #3
Newbie

Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
 Originally Posted by skipjack 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.

 August 29th, 2015, 02:12 PM #4 Global Moderator   Joined: May 2007 Posts: 6,665 Thanks: 651 The simplest solution is a straight line fit.
August 29th, 2015, 02:48 PM   #5
Newbie

Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
 Originally Posted by mathman 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.

Last edited by aspn; August 29th, 2015 at 03:04 PM.

August 30th, 2015, 01:26 AM   #6
Senior Member

Joined: Jun 2015
From: England

Posts: 891
Thanks: 269

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.

August 30th, 2015, 02:04 PM   #7
Global Moderator

Joined: May 2007

Posts: 6,665
Thanks: 651

Quote:
 Originally Posted by aspn 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.

September 1st, 2015, 10:44 AM   #8
Newbie

Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
 Originally Posted by mathman 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.

Last edited by aspn; September 1st, 2015 at 10:46 AM.

 Tags data, relation, sets

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post datameng Linear Algebra 2 September 3rd, 2014 06:30 AM Simon39 Abstract Algebra 4 November 29th, 2013 10:41 PM godric Real Analysis 1 August 31st, 2012 06:53 AM Shakarii Advanced Statistics 1 August 10th, 2012 03:32 AM vivek_master146 Algebra 5 December 3rd, 2007 01:28 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top