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

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

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

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

View Full Document
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
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

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

View Full Document
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
Ask a homework question - tutors are online