Skip to main content
Contents Calc Dark Mode Prev Up Next \(\newcommand{\Volume}{\mathrm{Volume}}
\newcommand{\xLow}{\mathrm{xLow}}
\newcommand{\xHigh}{\mathrm{xHigh}}
\newcommand{\Mcost}{\operatorname{Marginal Cost}}
\newcommand{\cost}{\operatorname{Cost}}
\newcommand{\Mrev}{\operatorname{Marginal Revenue}}
\newcommand{\revenue}{\operatorname{Revenue}}
\newcommand{\profit}{\operatorname{Profit}}
\newcommand{\Mprofit}{\operatorname{Marginal Profit}}
\newcommand{\Pprofit}{\operatorname{Predicted Profit}}
\newcommand{\price}{\operatorname{Price}}
\newcommand{\Dprice}{\operatorname{Demand Price}}
\newcommand{\Pprice}{\operatorname{Purchase Price}}
\newcommand{\Sprice}{\operatorname{Supply Price}}
\newcommand{\marginal}{\operatorname{Marginal}\,}
\newcommand{\linear}{\operatorname{Linear}\,}
\newcommand{\abs}[1]{\left\lvert #1\right\rvert}
\newcommand{\quantity}{\mathrm{Quantity}}
\newcommand{\AnnualCost}{\operatorname{Annual Cost}}
\newcommand{\AnnualExpense}{\operatorname{Annual Expense}}
\newcommand{\RepairFactor}{\mathrm{Repair Factor}}
\newcommand{\Sales}{\operatorname{Sales}}
\newcommand{\prediction}{\operatorname{prediction}}
\newcommand{\FutureValue}{\operatorname{Future Value}}
\newcommand{\demand}{\operatorname{Demand}}
\newcommand{\val}{\operatorname{Value}}
\newcommand{\raw}{\mathrm{raw}}
\newcommand{\gizmos}{\operatorname{gizmos}}
\newcommand{\intermediate}{\mathrm{intermediate}}
\newcommand{\tax}{\operatorname{tax}}
\newcommand{\FaceValue}{\operatorname{Face Value}}
\newcommand{\rate}{\mathrm{rate}}
\newcommand{\years}{\mathrm{years}}
\newcommand{\expense}{\operatorname{expense}}
\newcommand{\FutureAmount}{\operatorname{FutureAmount}}
\newcommand{\InitialDeposit}{\mathrm{InitialDeposit}}
\newcommand{\ppy}{\mathrm{ppy}}
\newcommand{\PresentAmount}{\operatorname{PresentAmount}}
\newcommand{\PriceGizmo}{\mathrm{PriceGizmos}}
\newcommand{\QuantityGizmo}{\mathrm{QuantityGizmos}}
\newcommand{\QuantityGadget}{\mathrm{QuantityGadgets}}
\newcommand{\QuantityWidget}{\mathrm{QuantityWidgets}}
\newcommand{\PriceWidget}{\mathrm{PriceWidgets}}
\newcommand{\PriceGadget}{\mathrm{PriceGadgets}}
\newcommand{\QW}{\mathrm{QW}}
\newcommand{\QG}{\mathrm{QG}}
\newcommand{\PW}{\mathrm{PW}}
\newcommand{\PG}{\mathrm{PG}}
\newcommand{\Production}{\operatorname{Production}}
\newcommand{\Labor}{\mathrm{Labor}}
\newcommand{\Capital}{\mathrm{Capital}}
\newcommand{\Linear}{\operatorname{Linear}\,}
\newcommand{\PriceX}{\mathrm{PriceX}}
\newcommand{\PriceY}{\mathrm{PriceY}}
\newcommand{\predicted}{\operatorname{predicted}}
\newcommand{\Time}{\mathrm{time}}
\newcommand{\TotalAmount}{\operatorname{TotalAmount}}
\newcommand{\TotalValue}{\operatorname{TotalValue}}
\newcommand{\CashAmount}{\mathrm{CashAmount}}
\newcommand{\DepositAmount}{\mathrm{DepositAmount}}
\newcommand{\AvailableTrees}{\operatorname{AvailableTrees}}
\newcommand{\Capacity}{\mathrm{Capacity}}
\newcommand{\Amount}{\operatorname{Amount}}
\newcommand{\InitialAmount}{\mathrm{InitialAmount}}
\newcommand{\InvestmentAmount}{\mathrm{InvestmentAmount}}
\newcommand{\Return}{\operatorname{Return}}
\newcommand{\SD}{\mathrm{SD}}
\newcommand{\Antideriv}{\operatorname{Antideriv}}
\newcommand{\MC}{\operatorname{MC}}
\newcommand{\MP}{\operatorname{MP}}
\newcommand{\MR}{\operatorname{MR}}
\newcommand{\CDFf}{\operatorname{CDFf}}
\newcommand{\Principal}{\operatorname{Principal}}
\newcommand{\ProducerSurplus}{\mathrm{ProducerSurplus}}
\newcommand{\ConsumerSurplus}{\mathrm{ConsumerSurplus}}
\newcommand{\TotalSocialGain}{\mathrm{TotalSocialGain}}
\newcommand{\Elasticity}{\operatorname{Elasticity}}
\newcommand{\lt}{<}
\newcommand{\gt}{>}
\newcommand{\amp}{&}
\definecolor{fillinmathshade}{gray}{0.9}
\newcommand{\fillinmath}[1]{\mathchoice{\colorbox{fillinmathshade}{$\displaystyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\textstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptscriptstyle\phantom{\,#1\,}$}}}
\)
Section A.4 From Section 1.6 Using Goal Seek
Goal Seek is a tool for
What If Analysis . Given a formula
\(f(x)=y\text{,}\) it asks what value of
\(x\) will produce a desired value of
\(y\text{.}\) It should be noted that, by defualt, it thinks values are equal if within 0.001 of each other.
To find
Goal Seek , select the "Data" tab, then select the "What-If Analysis" menu and the "Goal Seek" item. You need to identify an input cell with a number in to be the variable to change. You also need to identify an output cell to that contains a formula that depend on the input cell.
We often want to use Goal Seek to find the
intersection of two curves 1.6.5 .We simply define the difference of the fuunctions as a new formula and ust it for the output.
Avoiding traps of Goal Seek Since Goal Seek finds results numerically, using a variant of Newton’s method, there are several cautions to keep in mind:
Goal Seek thinks two values are equal when they are within 0.001 of each other. It will produce an answer to
\(\frac{1}{x^4}=0\text{.}\)
Goal seek works best when given a starting point close to an actual solution. On a function with several solutions, different starting points lead to different solutions.
Goal seek is confused by corners and discontinuities.
