1 / 11

GOAL SEEK AND SOLVER

GOAL SEEK AND SOLVER. Both of these tools come with the standard Excel package, but Solver has to be installed. If it is not on your computer, do the following: Open Excel and go to Tools|AddIns

giza
Télécharger la présentation

GOAL SEEK AND SOLVER

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GOAL SEEK AND SOLVER Both of these tools come with the standard Excel package, but Solver has to be installed. If it is not on your computer, do the following: Open Excel and go to Tools|AddIns After clicking AddIns, you’ll get a drop- down menu; scroll down to Solver Add-in and click the box.

  2. GOAL SEEK AND SOLVER Suppose we’re trying to graph the Equation y = x^3-2x^2-3x-121 We can do this in Excel as follows:

  3. GOAL SEEK AND SOLVER

  4. GOAL SEEK AND SOLVER Now we want to find the x such that the corresponding y is 21. You can tell from the table that the value will be somewhere between 5 and 6. To solve for it, we go to the Excel command Tools|Goal Seek.

  5. GOAL SEEK AND SOLVER

  6. GOAL SEEK AND SOLVER We can do the same calculation with Solver.

  7. GOAL SEEK AND SOLVER

  8. GOAL SEEK AND SOLVER The difference between Solver and Goal Seek. Solver remembers, Goal Seek forgets Solver is more flexible We use the function y = x^2-7x-14

  9. GOAL SEEK AND SOLVER

  10. GOAL SEEK AND SOLVER There are two roots. If you use Goal Seek, you cannot specify which x to find. With Solver, however, you can specify constraints on the variables:

  11. GOAL SEEK AND SOLVER

More Related