Introduction

In this chapter we're going to focus on numerically solving ordinary differential equations using Excel.

There are many methods available for numerically solving ordinary differential equations. Solution methods for initial value problems include such standard methods as Euler's method, the improved Euler method, the Runge-Kutta method, the leap frog method, various implicit schemes, as well as various adaptive schemes. Texts on numerical methods are full of such methods.

Other classes of problems dealing with ordinary differential equations include boundary value problems and initial-boundary value problems. Methods available for boundary value problems include the shooting method and variants, the band matrix method, Richardson extrapolation, various finite difference methods, and many others.

I aim to show you a few selected methods in this chapter to show you how you might implement some of these well known methods in Excel. Numerical methods texts contain detailed descriptions of these, as well as other methods. The Excel techniques I'll show you in this chapter will allow you to implement many of the standard methods in Excel.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data

Charting

Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations

Index



Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net