Numerical methods - JohnDFenton

← Back to document page

April 21, 2010. Numerical methods John D. Fenton Institute of Hydraulic and Water Resources Engineering, Vienna University of Technology Karlsplatz 13/222, 1040 Vienna, Austria Abstract These notes provide an introduction to Numerical methods for the solution of physical problems. Extensive use will be made of Excel Solver for the solving or approximating the solution of systems of equations. Table of Contents 1. Introduction . . . . . . . . . . . . . . . . . . . . . 2. 2. Accuracy, errors and computer arithmetic . . . . . . . . . . . . 3. Accuracy . . . . . . . . . . . . . . . . . . . . 3. Rounding . . . . . . . . . . . . . . . . . . . 3. Errors . . . . . . . . . . . . . . . . . . . . . 3. 3. Excel functions . . . . . . . . . . . . . . . . . . . . 5. 4. Solutions of nonlinear equations . . . . . . . . . . . . . . 7. The problem.

Numerical methods John D. Fenton a pair of modules, Goal Seek and Solver, which obviate the need for much programming and computations. Goal Seek, is easy to use, but it is limited – with it one can solve a single equation, however complicated or however many spreadsheet cells are involved, whether the equation is linear or nonlinear.

  Linear, Numerical