Numerical Methods with VBA Programming

Front Cover
Jones & Bartlett Learning, 2008 - Computers - 285 pages
Numerical Methods with VBA Programming provides a unique and unified treatment of numerical methods and VBA computer programming, topics that naturally support one another within the study of engineering and science. This engaging text incorporates real-world scenarios to motivate technical material, helping students understand and retain difficult and key concepts. Such examples include comparing a two-point boundary value problem to determining when you should leave for the airport to catch a scheduled flight. Numerical examples are accompanied by closed-form solutions to demonstrate their correctness. Within the programming sections, tips are included that go beyond language basics to make programming more accessible for students. A unique section suggest ways in which the starting values for non-linear equations may be estimated. Flow charts for many of the numerical techniques discussed provide general guidance to students without revealing all of the details. Useful appendices provide summaries of Excel and VBA commands, Excel functions accessible in VBA, basics of differentiation, and more!
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 Introduction
1
Arithmetic InputOutput and All That
5
Chapter 3 Errors Series and Uncertainty
43
Which Is Bigger? How Many Times?
63
Chapter 5 Numerical Integration
81
Useful Specialists
101
Finding Zero
111
Take One Step Forward
137
Excel Basics
253
Computer Representation of Numbers
259
VBA Command Summary
263
Glossary
267
Numerical Methods with the Casio fx115MS Calculator
269
Excel Functions in VBA
273
Differentiation Fundamentals
275
CashKarp RungeKutta VBA Program for Two Ordinary Differential Equations
277

Chapter 9 Sets of Linear Equations
173
Variables with a Family Name
199
Chapter 11 Curve Fitting
219
Chapter 12 Elliptic Partial Differential Equations
243

Other editions - View all

Common terms and phrases

About the author (2008)

The University of Tennessee at Chattanooga

Bibliographic information