Page 8 - Excel for Scientists and Engineers: Numerical Methods

Summary of Contents

..
Detailed Table of Contents .................................................................................. v11
Preface ................................................................................................................ xv
Acknowledgments ............................................................................................... xix
About the Author ................................................................................................. xix

Chapter 1 Introducing Visual Basic for Applications .................................... 1
Chapter 2 Fundamentals of Programming with VBA .................................. 15
Chapter 3 Worksheet Functions for Working with Matrices ....................... 57
Chapter 4 Number Series ............................................................................. 69
Chapter 5 Interpolation ................................................................................ 77
Chapter 6 Differentiation ............................................................................. 99
Chapter 7 Integration ................................................................................. 127
Chapter 8 Roots of Equations .................................................................... 147
Chapter 9 Systems of Simultaneous Equations .......................................... 189
Chapter 10 Numerical Integration of Ordinary Differential Equations
Part I: Initial Conditions ............................................................ 217
Chapter 11 Numerical Integration of Ordinary Differential Equations
Part 11: Boundary Conditions ..................................................... 245
Chapter 12 Partial Differential Equations .................................................... 263
Chapter 13 Linear Regression and Curve Fitting ......................................... 287
Chapter 14 Nonlinear Regression Using the Solver ..................................... 313
Chapter 15 Random Numbers and the Monte Carlo Method ....................... 341

APPENDICES
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

V