View Single Post
  #6   Spotlight this post!  
Unread 25-02-2012, 20:04
Ether's Avatar
Ether Ether is offline
systems engineer (retired)
no team
 
Join Date: Nov 2009
Rookie Year: 1969
Location: US
Posts: 8,042
Ether has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond repute
Re: Complex math equation



Just use the two-point formula:

y = y1+(x-x1)/(x2-x1)*(y2-y1)

with x1=8, x2=13, y1=0, y2=100 this gives y = 20*(x-8)

or plot your data in Excel

8,0
9,20
12.5,90
13,100

to see the shape, and then

click on "add trendline" and select an appropriate model (linear in this case) to fit (and it will give you the equation)


Last edited by Ether : 25-02-2012 at 20:07.
Reply With Quote