 ## Monday, March 4, 2019

### Excel for Scientists and Engineers (Numerical Methods) File Size: 14.75 Mb

Description
The solutions to mathematical problems in science and engineering can be obtained by using either analytical or numerical methods. Analytical (or direct) methods involve the use of closed-form equations to obtain an exact solution, in a nonrepetitive fashion; obtaining the roots of a quadratic equation by application of the quadratic formula is an example of an analytical solution. Numerical (or indirect) methods involve the use of an algorithm to obtain an approximate solution; results of a high level of accuracy can usually be obtained by applying the algorithm in a series of successive approximations.

As the complexity of a scientific problem increases, it may no longer be possible to obtain an exact mathematical expression as a solution to the problem. Such problems can usually be solved by numerical methods.

Content:-
Preface
Acknowledgments
Chapter 1: Introducing Visual Basic for Applications
Chapter 2: Fundamentals of Programming with VBA
Chapter 3: Worksheet Functions for Working with Matrices
Chapter 4: Number Series
Chapter 5: Interpolation
Chapter 6: Differentiation
Chapter 7: Integration
Chapter 8: Roots of Equations
Chapter 9: Systems of Simultaneous Equations
Chapter 10: Numerical Integration of Ordinary Differential Equations
Part I: Initial Conditions
Chapter 11: Numerical Integration of Ordinary Differential Equations
Part II: Boundary Conditions
Chapter 12: Partial Differential Equations
Chapter 13: Linear Regression and Curve Fitting
Chapter 14: Nonlinear Regression Using the Solver
Chapter 15: Random Numbers and the Monte Cario Method
APPENDICES
INDEX

Author Details
"E. Joseph Billo"