implemantation of an equation.

  • Thread starter Thread starter bevag
  • Start date Start date
B

bevag

Hi,
I am a new user and I need help.
My problem is that have some data(x,y) and I done a chart for them
However, I need to draw a curve which has this type: y=ax/(1+ax) an
then I draw the erros. I don't know how I can implement this equation
Could someone help me? It is urgent for me.
In the attachment image you can see what I want exactly.
Thanks

+-------------------------------------------------------------------
|Filename: curve.JPG
|Download: http://www.excelforum.com/attachment.php?postid=5227
+-------------------------------------------------------------------
 
The trendline is defined by excel (linear, exponential, power etc.).
don't want to add one fo these trendlines. I want to use as trendlin
this equation y=ax/(1+ax
 
Ummm...you can rewrite the equation y=ax/(1+ax) as
1/y = 1/(ax)+1 as long as you have no y=0 or x=0 points.

Substitute y'=1/y, x'=1/x and you get y'=a'x'+1, with a'=1/a.

Solve the linear equation with LINEST or a chart trendline.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top