# Excel for Scientists and Engineers - Numerical Methods

## Excel for Scientists and Engineers - Numerical Methods

E. Joseph Billo

Preference :

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 non-repetitive 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 :
• Introducing Visual Basic for Applications
• Fundamentals of Programming with VBA
• Worksheet Functions for Working with Matrices
• Number Series
• Interpolation
• Differentiation
• Integration
• Roots of Equations
• Numerical Integration of Ordinary Differential Equations
• Part I: Initial Conditions
• Numerical Integration of Ordinary Differential Equations
• Part 11: Boundary Conditions
• Partial Differential Equations
• Nonlinear Regression Using the Solver
• Random Numbers and the Monte Carlo Method