#### linear and exponential graphs and x,y intercepts

```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.

``` 0 7/31/2006 1:22:24 PM excel.charting  18370 articles. 0 followers. 3 Replies 695 Views Similar Articles

[PageSpeed] 34

```I would suggest that y=0.0021x+9e-16 is essentially y=0.0021x (the error in
m is greater then the value of c)
This makes the math trivial
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<Mozam.ali@asterand.com> wrote in message
>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.
>

``` 0 7/31/2006 2:46:48 PM
```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

Mozam.ali@asterand.com 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.
>
>
``` 0 7/31/2006 3:11:13 PM
```More help needed.

I do not have solver installed on my PC and the logistics of getting it
put onto every PC at work is going to be impossible.  So I can't use
the solver.  I do have GoalSeak if thats any help.

Next although the y-value for this equation is near zero that will not
be the case in all the eqautions i deal with.  the equations are just
an example.

I want to know at what X-value do the two lines cross.

I would preferably want it as an eqaution because I need to construct
it using XL.  Also I have done much in the way of mathematics since uni
(about 7 years ago) so you will have to go slow.  I know it's a
terrible excuse, but I need to understand it all.

mc+c=c^bx   (^=exp).

``` 0 8/7/2006 1:29:18 PM Similar Artilces:

how do i export a graph from excel to power point?
i am trying to export a graph from excel into my presentation in power point. Is there a way to do that? lisajensen21 Wrote: > i am trying to export a graph from excel into my presentation in power > point. > Is there a way to do that? Hi. Just click on the chart so that you get black dots at the corners and mid points of the chart Then go to Edit - copy. Open the powerpoint page you want and then make a text box Click inside the text box and then go to Edit - paste. HTHs -- badkitti* ------------------------------------------------------------------------ badkitti*'s ...

Auditing and graphs
I would like to be able to tell if a cell is being used in any graph in my workbook. The standard <Audit> <Show dependants> does not seem to concider Graphs as dependents (Help specifically talks about dependent "cells" in the auditing write up) Is anyone aware of a built in method for determining whther a cell is used in a chart, or does anyone have a recomended macro I can build on? You are right in that the 'Show Dependents' doesn't consider graphs as dependents. In fact, there is no easy way to find all the cell references in a workbook. As f...

Graph and Input box for Date Range
All, This is just my thought but have no idea how to proceed. Can someone please provide a solution, I will really appreciate. Not sure how to attach a spreadsheet by my data spreadsheet is uploaded to File section known as DATA.XLSX. Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K contains data starting year 2001-2010 for the same dates. I would like to create a Date Range Input box so whenever I specify date ranges, it automatically pulls data of those dates from 2001 to 2010 and creates some type of line chart. E.g I specify date1: 3-march and date2: 10-June then line graph sho...

Sliding dates on a graph?
I have created stacked column graphs using the OFFSET function to automatically update when each week's information is added to the worksheet. However, now my boss want's only the last 4-6 weeks of information to be displayed on the graph. Is there a way to do this without manually changing each data point (there are 6 for each week for each chart--YIKES) every week? Thank you for your time, Dee I found it! http://www.peltiertech.com/Excel/Charts/DynamicLast12.html "Dee Sperling" <sperling@infimed.com> wrote in message news:uE\$hZxiLFHA.3064@TK2MSFTNGP12.phx.gbl....

Microsoft Office X Future
I read an enlightening, pro-mac article inferring that Microsoft's discontinuation of IE development is one indication the plug might be pulled on Office as well. Is there any reassurance out there that this won't happen? This is a quote from Jessica Sommer [MS]: "We are working diligently on the next version of Office -- these [IE and Office] are not connected in any way. Office is still intact and going strong -- there are no plans to stop development on Office for Mac even after the next version is released." <http://maccentral.macworld.com/news/2003/06/13/explorer/&g...

linear and exponential graphs and x,y intercepts
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&...

Srolling Price History Graphs
If it were possible to scroll all the Graphs using the mouse wheel (or page up/down or Up/Down Arrow) would be a very useful tool to display all the items in the portfolio very quickly. Currently, I have to return to the portfolio and select the investment and return to the graph display. Using the "Compare to" feature does not answer the issue. Also, when using the "Compare to" feature, Buy/Sell tags does not display. This would be nice also. Anyone agree? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions w...

Need help with chart graph not on chart wizard
Need help in creating chart graph. For example, we have tarped and untarped data we need to track. I want to create a chart for 9 landfill sites and show the tarped and untarped percentages on the same bar graph. I am comparing October and November data. I am using excel 2003. Does anyone know if this can be done? The chart wizards has something similar, but not showing the data the way we want to present it. Thanks! Neither of your posts described what you want to show, or how you want to show it. I'm sure what you want can be done, but I don't know yet what that is. -...

Linear Programming
In Excel how do you set up a 3 variable linear programming problem on a spreadsheet with a a number of constaints using Solver? Franklin - See the tutorials and examples at www.solver.com. Or, search your drive for the file solvsamp.xls, which is installed when Solver is installed and which has a 3-variable nonlinear example that is easily converted to linear. - Mike www.mikemiddleton.com +++++++++++++++++++ "Franklin" <anonymous@discussions.microsoft.com> wrote in message news:0c5a01c500bf\$8f5038c0\$a501280a@phx.gbl... > In Excel how do you set up a 3 variable ...

how do I graph a linear equation?
I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I do this? On my TI-83 Plus I could easily do this. I also know I could create a data table and use the table of values to chart the line in excel. But I want just enter the equation in excel and have excel graph it. Thanks. On Sun, 9 Jan 2005, in microsoft.public.excel.charting, Throstle <Throstle@discussions.microsoft.com> said: >I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I >do this? On my TI-83 Plus I could easily do this. I also know I could create >a data table and ...

Graphs #9
Can someone explain how to do a graph? Specifically for a finance class. I need to do a breakeven graph and a EBIT-EPS indifference graph. Select a cell that is in the table that you want to graph, then press F11. What you graph will depend on what variables you have available to base your calculation on. eg. variable / fixed costs, etc. Steve Kellique wrote: > Can someone explain how to do a graph? Specifically for a finance class. I > need to do a breakeven graph and a EBIT-EPS indifference graph. ...

using linear / non linear graphs to extract results
Hi, A frequent function of my job is to analyse data on graphs/charts to extract data for engineering data , i.e power / temperature/flowrates etc etc Is the a microsoft based programe i.e. Excel/Access that is capable of understanding data on a scaled X-Y axis that if an X value was entered in a cell, the programme would extract a corresponding Y value from a line on a graph ? If anyone has any woring examples of such a thing, I'd appreciate a link Thx Hi, If there is a linear relationship between X and Y use the function FORECAST It a power series is needed use LINEST - see examp...

Subscripted text in the legend of a graph
Hi, I have been trying to write a legend in a graph which has some of its part subscripted. However, I have not been able to do so. Could anybody show me a way out. nure If your superscripts are just 2 and 3 (squared and cubed) then for toy axis header use something like y +ALT0179 or y+ALT0179 (digits on the number pad) to get y� and y� For other digits you need a fond such as Chemistry font (see http://www.scs-intl.com/frameload.htm?/chemfont.htm) which has sub and superscripts for all digits. So does the Calibri font in Office 2007 but they do not have sequential ASCII values. See...

Linear Regression
I have five numbers in: A1,B1,C1,D1,E1 Is there a function that will give me the linear regression of those numbers that can be put in D1, with charting etc? TIA Linear regression works with ordered pairs. row 1: 1,2,3,4,5 row 2: 2,4,6,8,<formula> formula in E2 : =FORECAST(E1,A2:D2,A1:D1) will return 10 Any use? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Saxman" <john.h.williamsREMOVETHIS@btinternet.com> wrote in message news:XpidnXpInZMDMx7WnZ2dnUVZ8m1i4p2d@bt.com... > I have five numbers in: &...

line graphs
Hi, i have a spread sheet that i am trying to form a line graph to show the amounts paid in that period and in this period. how do i go about with the formula that i need to through. thanks EXCEL 2007 Hi Ray, please check out:- http://www.pierrefondes.com/ - item number 55. All you need to do is to adapt this to you own needs. If my comments have helped please hit Yes. Thanks. "ray" wrote: > Hi, > > i have a spread sheet that i am trying to form a line graph to show the > amounts paid in that period and in this period....

Linear Equations
I am having difficulty graphing a linear equation in two variables by using three ordered pair 1/2 y = 2x + My ordered pair x 0 1 y 2 6 10 see as follow Pairs x (0, 2 (1, 6 (2, 10 I am unable to graph this problem and need help!!! Just select the range containing the ordered pairs and Insert|Chart. Jerry Angela Mitchell wrote: > I am having difficulty graphing a linear equation in two variables by using three ordered pairs > > 1/2 y = 2x + 1 > > My ordered pairs > x 0 1 2 > y 2 6 10 see as follows > > Pairs: > x y > (0, 2) >...

linear increments
Hi, I am kind of new to excel and was wondering if excel is capable of doing linear increments. I want increments that can vary, meaning in one case i want to go from 0 to 10 in increments of 2 and in other cases i want to go from 0 to 10 in increments of 5. The number of cells change. Is it possible for excel to do this w/o having to specify the number of cells needed? -- NewGuy100 ------------------------------------------------------------------------ NewGuy100's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27935 View this thread: http://www.excelforum.com...

Performance Graph in Monthly Reports
I only use Money 2006 to track my investments and have set up a file to include one account which contains a certain type of investment. All investments in that account have now been sold. Why is it that when I go to monthly reports, under 'Performance of Your Investments", it registers a percentage reading and underneath it says "This year investments in your account have outperformed all other investment accounts..." Most of the investments have been completely sold for several years although one was last sold late last year? I have checked previous monthly repor...

Printed scalable graphs
I have created an xy scatter graph that draws a rectangular shape. The rectangle is rotated based on an input angle which varies. (0<angle<=90). It appears to be rotating correctly, but as it does, there is some distortion so that the rectangle becomes a parallelogram. Is there any way to correct that? there's a newsgroup devoted to graphing. news://msnews.microsoft.com/microsoft.public.excel.charting If you don't get a reply, you may want to visit there. There's less traffic there and those charting experts may see your question (instead of having it buried in thi...

Account Balance Graph
I am a recent convert from Quicken, and I'm just getting used to the features of Money. One thing I really liked, in Quicken was the bar graph that showed up under the Calendar that would show a bar graph of the balance in an account of my choosing. This was great because I could quickly see if I was going to head into the negative anytime soon and make spendnig adjustments. I can't find anything similar in Money. Is there something like that? Thanks. The "forecast your cash flow" page is probably what you require. Click on 'cash flow' in the menu on the le...

Control X axis order
I want to make an adjustment to the order on the X axis. I have my months listed in this order in the source range: March (listed vertically) April May My chart shows this order: Apr May Jun........Mar When I reverse them I get Mar Feb Jan.......Apr I want Mar Apr May.... (the way I have it listed in the source range) What I want to present is how this month's data relates to the same month last year then give a head's up on what to expect next month.... Hi, The only thing I can think of that would change the order of the axis labels is that there are really dates. And that t...

How can I draw a Parabola in Excel? like y = x^2 + 3
In a1:a10 enter numbers such as 1,2,3.... In b1 type =a1^2+3 copy this down to B10 select a1:b10; click chart wizard; select XY chart done now play with values in A to get what you need best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Max" <Max@discussions.microsoft.com> wrote in message news:F72AB641-F882-4DAD-B0C3-322297A124FC@microsoft.com... > ...

2 Lined Line Graph
I am trying to plot quarterly and monthly data using two lines. My quarterly line is broken into points instead of a continuous line, is there a way I can get it to connect to the quarter points? If the cells in between are blank, go to Tools menu > Options > Chart tab, and choose the Interpolate option for dealing with blank cells. If the cells contain anything else, including a formula that returns "" (which is NOT blank), change "" to NA(), which puts an #N/A error in the cell, which ain't pretty in the worksheet but which results in an interpolated lin...

Chart X Axis value label on both left and right sides
Can I add a second X axis value on both left and right sides of a chart? At present scrolling the chart to the right there are no axis label values to easily read the chart. Beemer Beemer, You have to have at least two Data Series to do that. Right click on the second of them, choose Format Data Series, then on the Axis tab, choose secondary axis. Note that Excel may change the relative values between the first and second axes, so you should set the Max and Min for both manually. HTH, Bernie MS Excel MVP "Beemer" <Beemer@nowhere.com> wrote in message news:MPG.1b2a2779...

Excel 2007; graph the best fit line from a regression analysis?
Try using this white space to ask you question with a bit more detail best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mattz" <mattz@discussions.microsoft.com> wrote in message news:574CCC66-72EA-44D0-8D36-2147B6C7C279@microsoft.com... > ...