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
Download Excel for Scientists and Engineers - Numerical Methods free PDF
EmoticonEmoticon