Book123

    Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " Excel For Scientists And Engineers Numerical Methods " from UseNet for FREE!

Author(s) : E. Joseph Billo

Publisher : Wiley

Year : Apr 2007

ISBN 10 : 0471387347

ISBN 13 : 9780471387343

Language : English

Pages : 480

File type : PDF

Size : 30.5 MB

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.This is a book about numerical methods. I have emphasized the methods and have kept the mathematical theory behind the methods to a minimum. In many cases, formulas are introduced with little or no description of the underlying theory. (I assume that the reader will be familiar with linear interpolation, simple calculus, regression, etc.) Other topics, such as cubic interpolation, methods for solving differential equations, and so on, are covered in more detail, and a few topics, such as Bairstow's method for obtaining the roots of a regular polynomial, are discussed in detail.In this book I have provided a wide range of Excel solutions to problems. In many cases I provide a series of examples that progress from a very simple implementation of the problem (useful for understanding the logic and construction of the spreadsheet or VBA code) to a more sophisticated one that is more general. Some of the VBA macros are simple "starting points" and I encourage the reader to modify them; others are (or at least I intended them to be) "finished products" that I hope users can employ on a regular basis.Nearly 100% of the material in this book applies equally to the PC or Macintosh versions of Excel. In a few cases I have pointed out the different keystrokes requires for the Macintosh version.TABLE OF CONTENT:

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 2

Chapter 11 Numerical Integration of Ordinary Differential Equations part 2

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 Buy Book at Lowest Price on Amazon

password:ganelon

Rating:
2.5 out of 5 by Book123