Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Using Excel to Solve Nonlinear Equations Goal Seek

3 USING EXCEL TO SOLVE NONLINEAR EQUATIONS (GOAL SEEK) [Pg.8]

Therefore, the algorithm used by Goal Seek is somewhat similar to the secant method with some enhancements. If Goal Seek fails, it is usually due to a poor initial [Pg.8]

In the following spreadsheet, cell Bl contains the initial guess for the independent variable, x. When a correct value is found for x, then the function/(x) = 0 [the formula for fix) is in cell B2 and is = Bl-Bl (1/3) - 2], [Pg.9]

The following is the Goal Seek window obtained from the Data/What If Analysis/Goal Seek Menu. [Pg.9]

After hitting the OK button on the Goal Seek window, the spreadsheet changes [Pg.9]




SEARCH



Equation Solving

Equation, nonlinear

Excel

Excellence

Goal Seek...

Nonlinear/nonlinearity equations

Solving nonlinear equations

Useful Equations

© 2024 chempedia.info