Class05 - 1 GEEN 1300 Introduction to Engineering Computing...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 1 GEEN 1300 Introduction to Engineering Computing Class meeting #5 Wednesday, Sept 8 th Spreadsheet Problem Solving 1 Homework #3 is posted: due next Wednesday Targeting Calculations Goal Seek Solver Excels Goal Seek tool spreadsheet calculation inpu outpu calculation involving one or more cells input cell output cell target value compare Goal Seek adjust Data ribbon What-If Analysis Goal Seek... 2 value Goal Seek automatically adjusts the value in an input cell so that the value in an output cell matches a target value. The target value is a literal constant and cannot be a cell reference or a formula. 2 Simple Goal Seek example x sin x 1 adjust the value of x until is equal to the target of 1 x sin x input cell B2 named x output cel output cell numerical result from first value in input cell set up Goal Seek 3 target value: 1 click OK Goal Seek results Success! Target is met So click OK 4 So, . . . , click OK value of input, x, that yields target output 3 Important characteristics of Goal Seek adjusts one input cell value to achieve a specific target value in an output cell is a completely black box operation we cannot see is a completely black box operation we cannot see its method nor control the precision of the result when it doesnt achieve a correct answer, were left in the dark Goal Seek forgets . When we run Goal Seek again, we have to fill in all the fields.have to fill in all the fields....
View Full Document

Page1 / 13

Class05 - 1 GEEN 1300 Introduction to Engineering Computing...

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