Solved

Excel graph for solving simultaneous equations

Posted on 2011-03-25
9
1,724 Views
Last Modified: 2012-05-11
Need someones help to develop a graph which plots two lines for solving a simultaneous equation. Manually when the graph is plotted with when x=0 and y= a value and when x= a value and y=0 for both sets of equations.

Sample data is as below:

Eqn (1):           -1x - 12y = 54
when x=0, y=-4.5 and when y=0, x= -54

Eqn (2):         4x + 3y = 25
when x=0, y=8.3333 and when y=0, x=6.25

When the two lines are plotted for the above equatons, where they cross I will need the x and y value which is the solution for the simultaneous equation.

I don't mind whether the solution uses vba or not.
0
Comment
Question by:Baber62
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 35216025
This sounds like homework, and you should probably try to do it without posting it here, since that defeats the purpose.

That said, Excel can't plot equations, since it's not a TI calculator. The closest you can get is to do a line graph with a few sample points - since these are linear equations, that shouldn't be too difficult to give it a few example pairs and have it graph them for you.

It won't calculate the intersection though - it's not really designed to do that, so you'll have to do it by hand using substitution.
0
 

Author Comment

by:Baber62
ID: 35216226
Thanks for the tip Ryan, but I am a part time teacher and need this to demonstrate to students. I have attached a workbook I have developed to solve simultaneous equations, all my own work.

That's the difficulty I am having at the moment is trying to understand how to get two lines to plot on one graph from separate datasets.
Simultaneous-Equations.xlsx
0
 
LVL 7

Expert Comment

by:harr22
ID: 35216506
you would have to solve each equation multiple times and list the x,y data points.  Then you could plot a graph with both series.  But its still not going to tell you where they intersect, you would have to eyeball that...or solve for it.

Travis
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 7

Accepted Solution

by:
harr22 earned 167 total points
ID: 35216634
here is a little example using your equations


Simultaneous-Equations.xlsx
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 166 total points
ID: 35217969
To be able to plot the two lines from the four selected points you should move the two points of one line away from the two points of the other so that there is at least one blank space between the data. Then select the data and (Assuming that you are using excel 2007 or later)

Insert tab > Scatter > select one of the last two types.

This will plot the two lines for you.

The problem in this particular example is that the intersection point does not lie on any of the two line segments plotted. They will both have to be extended so that the intersection point is evident

I have modified your range as explained above and plotted a chart in the attached file.

I have also created a similar range and included the intersection point in it and then plotted it to show the intersection point.

Saqib
Copy-of-Simultaneous-Equations.xlsx
0
 
LVL 26

Expert Comment

by:redmondb
ID: 35224576
Baber62,

Must this be an Excel solution? If not, have you considered the (free) (Microsoft Mathematics 4.0? This seems to do everything you want "out of the box".

Regards,
Brian.
0
 
LVL 26

Assisted Solution

by:redmondb
redmondb earned 167 total points
ID: 35224590
Baber62,

For example...

(1) Click on "Equation Solver" on the Ribbon.
(2) Select "Solve a System of 2 Equations".
(3) Enter the two equations and click on "Solve"...
 Solver_I(4) Clicking on "Solution Steps Using Elimination"...
 Solver_II
Regards,
Brian.
0
 

Author Closing Comment

by:Baber62
ID: 35231076
Thanks guys and gals for your help. It is sincerly appreciated.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 35231882
Thanks, Baber62.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question