Unraveling Equations with Goal Seek for Microsoft Excel 2000 .


28 views
Uploaded on:
Category: Sales / Marketing
Description
Solving Equations with Goal Seek for Microsoft Excel 2000. A Simple Problem. grades, grades, grades*…. You would love to have a quiz average of 80 points (or better) in the QTM1300 course by the end of the semester.
Transcripts
Slide 1

Illuminating Equations with Goal Seek for Microsoft Excel 2000

Slide 2

A Simple Problem grades, grades, grades*… You would love to have a test normal of 80 focuses (or better) in the QTM1300 course before the end of the semester. Your test scores on the initial nine tests are given in the table underneath. What score do you have to acquire on the 10 th and last test with a specific end goal to meet your objective normal of 80 focuses? * from FCL Excel Notes by Joyce Gordon, Babson College, 1998.

Slide 3

Quiz Average 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 Formulate the Problem acquire condition to be explained You are searching for x = score on 10 th test so that NOTE: Only utilize Goal Seek if the condition contains stand out factor; has the right-hand side equivalent to a steady.

Slide 4

Preparing the Worksheet for Goal Seek begin with a clear sheet

Slide 5

Preparing the Worksheet for Goal Seek enter names and constants Enter names in cells A1:A13 and B1

Slide 6

Preparing the Worksheet for Goal Seek enter marks and constants NOTE: These names are not crucial for the utilization of Goal Seek

Slide 7

Remember… Quiz 1 2 3 4 5 6 7 8 9 Score 90 88 78 68 84 82 66 74 72 Preparing the Worksheet for Goal Seek enter names and constants Enter constants in cells B2:B10

Slide 8

Remember… 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 x Preparing the Worksheet for Goal Seek enter recipe Variable values in cell B11 Left-hand side of condition in cell B13 NOTE: These phones will be hued to demonstrate that they are key for Goal Seek

Slide 9

Remember… 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 Preparing the Worksheet for Goal Seek enter recipe Click on cell B13

Slide 10

Remember… 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 Preparing the Worksheet for Goal Seek enter recipe Type in =AVERAGE(

Slide 11

Remember… 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 Preparing the Worksheet for Goal Seek enter equation Highlight cells B2:B11

Slide 12

Remember… 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + 72 + x = 80 10 Preparing the Worksheet for Goal Seek enter recipe Type in ) and hit Enter

Slide 13

Preparing the Worksheet for Goal Seek enter recipe NOTE: Alternative recipe for cell B13 : =( B2 + B3 + B4 + B5 + B6 + B7 + B8 + B9 + B10 + B11 )/10

Slide 14

Preparing the Worksheet for Goal Seek enter recipe NOTE: The capacity AVERAGE entered in cell B13 gives back the normal of the qualities in cells B2:B11 ; clear cells are overlooked

Slide 15

Using Goal Seek conjure Goal Seek Click on Tools

Slide 16

Using Goal Seek summon Goal Seek Click on Goal Seek

Slide 17

Using Goal Seek conjure Goal Seek

Slide 18

NOTE: The phone showed in the Set cell: box must contain the recipe for the left-hand side of the condition (cell B13 ) Using Goal Seek finish the Goal Seek discourse box Click on cell B13

Slide 19

Using Goal Seek finish the Goal Seek exchange box Click on the To esteem: box

Slide 20

Using Goal Seek finish the Goal Seek discourse confine Type 80 NOTE: The esteem showed in the To esteem: box must be the steady on the right-hand side of the condition ( 80 )

Slide 21

Using Goal Seek finish the Goal Seek exchange box Click on the By evolving cell: box

Slide 22

Using Goal Seek finish the Goal Seek discourse box Click on cell B11 NOTE: The phone showed in the By evolving cell: box must be the phone containing variable qualities (cell B11 )

Slide 23

Using Goal Seek execute Goal Seek Click on OK

Slide 24

Using Goal Seek read arrangement You have to win a score of 98 on the 10 th test to meet your objective normal of 80 focuses. NOTE: If the condition has various arrangements, Goal Seek for the most part finds the nearest answer for the underlying variable esteem.

Slide 25

Back to examining! Utilizing Goal Seek end execution Click on OK

Slide 26

Final Comments Goal Seek won\'t not locate the correct arrangement… Goal Seek has an accuracy of 0.001: when the variable esteem returned by Goal Seek is connected to one side hand side of the condition, the outcome will be inside 0.001 of the right-hand side; utilize Excel Solver for higher exactness and/or conditions with different factors.

Recommended
View more...