Excel for Scientists and Engineers Numerical Methods By E. Joseph Bill0

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.

Download The Book For Free In PDF Format

Download