## Wednesday, April 11, 2018

Excel for Scientists and Engineers Numerical Methods By E. Joseph Bill0
Summary of Contents
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
Chapter 11 Numerical Integration of Ordinary Differential Equations
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 Carlo Method

Preface
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 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.
The Objective of This Book
Numerical methods require extensive calculation, which is easily accomplished using today's desktop computers. A number of books have been written in which numerical methods are implemented using a specific programming language, such as FORTRAN or C++. Most scientists and engineers received some training in computer programming in their college days,but they (or their computer) may no longer have the capability to write or run programs in, for example, FORTRAN. This book shows how to implement numerical methods using Microsoft Excel,the most widely used spreadsheet software package. Excel provides at least three ways for the scientist or engineer to apply numerical methods to problems.

### DMCA

Disclaimer for MEP Engineering Café (“MEP Engineering Café”) respects the intellectual property rights of others and expects its users to do the same. In accordance with the Digital Millennium Copyright Act of 1998, the text of which may be found on the U.S. Copyright Office website at http://www.copyright.gov/legislation/dmca.pdf, MEP Engineering Café will respond expeditiously to claims of copyright infringement committed using the MEP Engineering Café service and/or the MEP Engineering Café website. 