My Math Forum  

Go Back   My Math Forum > High School Math Forum > Elementary Math

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


Thanks Tree1Thanks
  • 1 Post By mathman
Reply
 
LinkBack Thread Tools Display Modes
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?
aspn is offline  
 
August 29th, 2015, 01:07 PM   #2
Global Moderator
 
Joined: Dec 2006

Posts: 18,433
Thanks: 1462

Where do these values come from?
skipjack is offline  
August 29th, 2015, 01:16 PM   #3
Newbie
 
Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
Originally Posted by skipjack View Post
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.
aspn is offline  
August 29th, 2015, 02:12 PM   #4
Global Moderator
 
Joined: May 2007

Posts: 6,416
Thanks: 558

The simplest solution is a straight line fit.
mathman is online now  
August 29th, 2015, 02:48 PM   #5
Newbie
 
Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
Originally Posted by mathman View Post
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.
aspn is offline  
August 30th, 2015, 01:26 AM   #6
Senior Member
 
Joined: Jun 2015
From: England

Posts: 717
Thanks: 203

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.
studiot is offline  
August 30th, 2015, 02:04 PM   #7
Global Moderator
 
Joined: May 2007

Posts: 6,416
Thanks: 558

Quote:
Originally Posted by aspn View Post
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.
Thanks from aspn
mathman is online now  
September 1st, 2015, 10:44 AM   #8
Newbie
 
Joined: Aug 2015
From: India

Posts: 4
Thanks: 0

Quote:
Originally Posted by mathman View Post
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.
aspn is offline  
Reply

  My Math Forum > High School Math Forum > Elementary Math

Tags
data, relation, sets



Thread Tools
Display Modes


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





Copyright © 2018 My Math Forum. All rights reserved.