Numerical Methods with VBA Programming
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.
Chapter 1 Introduction
Arithmetic InputOutput and All That
Chapter 3 Errors Series and Uncertainty
Which Is Bigger? How Many Times?
Chapter 5 Numerical Integration
Take One Step Forward
Computer Representation of Numbers
VBA Command Summary
Numerical Methods with the Casio fx115MS Calculator
Excel Functions in VBA
CashKarp RungeKutta VBA Program for Two Ordinary Differential Equations
Other editions - View all
answer Apply your program array average calculated cell Chapter coefficients Collatz criterion column Consider the equation convergence correct value curve fit defined diagonal dialog box displays dV dt ea’s End Sub equation set Euler method evaluate example Excel flowchart formula function Gaussian elimination Gaussian–Seidel independent variable InputBox integral interval inverse label languages linear equations loop Maclaurin series magnitude matrix menu MsgBox Newton–Raphson method number of terms obtain ordinary differential equations Perform three iterations pivoting plot problem program to input program to solve quadratic equation radians rearrangement relative error require Romberg integration root Runge–Kutta method secant rule second-order significant figures Simpson’s 1/3 rule solution spline spreadsheet square starting values statements step subprogram Taylor series tion trapezoid rule true error uncertainty VBA program velocity Write a program xn+1 yields zero