View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default linear and exponential graphs and x,y intercepts

The way to solve this is to set the 2 equations equal to one another and
then solve for x. So, you will get
0.0021x+9e-16 = 0.0022*EXP(0.0046x)

For all practical purposes 9e-16 is zero. So, we get
0.0021x = 0.0022*EXP(0.0046x)

This cannot be solved algebriacally but it can be solved numerically.

Designate a cell, say B2 as the one containing the X value. Then, in C2,
enter the formula =0.0021*B2. In D2, enter the formula
=0.0022*EXP(0.0046*B2). In E2 enter the formula =C2-D2.

Now, use GoalSeek (Tools | Goal Seek...) to set E2 to zero by changing B2.
Though, given the scale of the numbers, I would go with Solver (Tools |
Solver...) Set the target as E2, set the desired value of 0 and click
Solve.

I get two results, both borne out by a chart. The first intersection is
reached if you start with an initial value of 0 in B2. The second by
starting with an initial value of 2000.

And, for the larger result, I don't get 1631 but 1593.

--
Regards,

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

In article om,
says...
I have two lines one linear (y=mx+c) and one exponential (y=c^bx) and
they intercept each other. I believe it is possible to calculate where
the lines intercept. Although I can do this by graphing the data, it
takes time and allows for user error so a calculation would speed
things along greatly.

The problem:

So for the first line using the equation y=mx+c the numbers for the
13kPa line are y=0.0021x+9e-16

And for the exponential line (y=c^bx) which we produce to using the
myograph is y=0.0022^0.0046x (^=Exp)

I know that the two lines intercept at 1613. But no matter what I try
I can't get the equations to simplify and produce a x value.