By changing cell should point to a cell which has the initial guess of the value of x. Set cell should point to the cell that contains a formula for f( x). A small dialog box appears and you need to enter values for the following fields: Excel provides a capability called goal-seeking which enables you to find roots of a polynomial equation and a variety of other problems which are typically solved using iterative methods. Essentially you want to find a value of x such that f( x) = a for a constant a.Įxcel’s goal-seeking capability can be found by going to the Data tab and pressing the small down arrow to the right of the What-If Analysis option from among the Data Tools and then selecting Goal Seek.
0 kommentar(er)
