Page 344 - Excel for Scientists and Engineers: Numerical Methods
P. 344

CHAPTER 14        NONLINEAR REGRESSION USING THE SOLVER              32 1






























                                 Figure 14-7.  The Solver Options dialog box.




                   For reasons that will be explained in a subsequent section, press the Options
                button to display the Solver Options dialog box (Figure 14-7) and check the Use
               Automatic Scaling box.


















                                 Figure 14-8.  The Solver Results dialog box.


                   Press  OK to exit from  Solver Options and return to the  Solver Parameters
                dialog box.  Press the Solve button.
   339   340   341   342   343   344   345   346   347   348   349