Solver Write-up

Solver Write-up - Setting-up Solver Consider solving a set...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Setting-up Solver Consider solving a set of equations: Example 1: Find “x” such that “7x+5=19” Example 2: Find “x” and “y” such that “x+y=3” and “x-y=1” The figure below lists two examples of using the Solver routine on excel. The various steps required to set up the spreadsheet for using Solver are: 1. Assign cells to get the input for the variable(s): Example 1: the only variable is “x” set up a cell to get an initial guess for “x” from the user. Example 2: Similarly for Example 2, we have two variables “x” and “y” and hence the spreadsheet is set up accordingly. 2. Assign cells to calculate the equation(s) to solve: Example 1: Only one equation is to be solved “7x + 5 = 19”. Based on the users guess for “x”, this cell will have a corresponding value. (ex. if “x = 1” then the cell corresponding to “7x + 5 = ” will read 12) Example 2: Example two consists of two equations. Set up cells for both the equations as shown in the figure below.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3. Open
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Solver Write-up - Setting-up Solver Consider solving a set...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online