LAB 2 - Goal-Seek and Solver Sort and Filter Advanced...

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

View Full Document Right Arrow Icon
Goal-Seek and Solver (Ch. 2, pp. 65 – 81) Sort and Filter (Ch. 1, pp. 33 – 43) Advanced Excel Functionalities (Ch. 2, pp. 57 – 64) Project #1
Background image of page 1

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

View Full DocumentRight Arrow Icon
r Step 1: Set up the problem statement on Excel Ex.: Calculate the value of X that satisfies X 2 = 97.25 r Step 2: Open Goal-Seek Data b What-If Analysis b Goal-Seek Goal-Seek Note formula r Step 3: Specify the inputs Set cell: Cell to optimize. Here, we want to find X when Cell(2,2) = 97.25. To value: Value we want cell(2,2) to equal By changing cell: Variable to be determined. In this case, X, which is stored in Cell(1,2) r Step 4: Hit the “OK” button to solve
Background image of page 2
Similar to Goal-Seek, more powerful. r Can be used for optimization instead of just solving equations. r Can be used for multivariable solutions. Goal-Seek can only solve for 1 variable at a time. r Solver is a separate Add-In to excel. To add the “Solver” routine to excel the excel ribbon, follow the following path on your excel window. File
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/12/2011 for the course ENGR 1412 taught by Professor Staff during the Spring '08 term at Oklahoma State.

Page1 / 7

LAB 2 - Goal-Seek and Solver Sort and Filter Advanced...

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

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