Page 17 - Excel for Scientists and Engineers: Numerical Methods

xiv EXCEL: NUMERICAL METHODS

Importing the Trendline Equation from a Chart into a Worksheet .............. 305
Problems ............................................................................................................. 309
Chapter 14 Nonlinear Regression Using the Solver 313
Nonlinear Least-Squares Curve Fitting .............................................................. 314
Introducing the Solver ................................................................................. 316
How the Solver Works ................................................................................. 316
Loading the Solver Add-In .......................................................................... 317
Why Use the Solver for Nonlinear Regression? .......................................... 317
Nonlinear Regression Using the Solver: An Example ................................. 318
Some Notes on Using the Solver ................................................................. 323
Some Notes on the Solver Parameters Dialog Box ..................................... 323
Some Notes on the Solver Options Dialog Box ........................................... 324
When to Use Manual Scaling ...................................................................... 326
Statistics of Nonlinear Regression ..................................................................... 327
The Solver Statistics Macro ......................................................................... 328
Be Cautious When Using Linearized Forms of Nonlinear Equations ......... 329
Problems ............................................................................................................. 332
Chapter 15 Random Numbers and the Monte Cario Method 341
Random Numbers in Excel ................................................................................. 341
How Excel Generates Random Numbers .................................................... 341
Using Random Numbers in Excel ............................................................... 342
Adding "Noise" to a Signal Generated by a Formula .................................. 344
Selecting Items Randomly from a List ........................................................ 345
Random Sampling by Using Analysis Tools ............................................... 347
Simulating a Normal Random Distribution of a Variable ........................... 349
Monte Carlo Simulation ..................................................................................... 350
Monte Carlo Integration ..................................................................................... 354
The Area of an Irregular Polygon ................................................................ 354
Problems ............................................................................................................. 362
APPENDICES 363
Appendix 1 Selected VBA Keywords ........................................................... 365
Appendix 2 Shortcut Keys for VBA ............................................................. 387
Appendix 3 Custom Functions Help File ...................................................... 389
Appendix 4 Some Equations for Curve Fitting ............................................. 409
Appendix 5 Engineering and Other Functions .............................................. 423
Appendix 6 ASCII Codes .............................................................................. 427
Appendix 7 Bibliography .............................................................................. 429
Appendix 8 Answers and Comments for End-of-Chapter Problems ............ 431
INDEX .............................................................................................................. 443