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 . . . . . . . . . . . . . . . . . . . 7. methods . . . . . . . . . . . . . . . . . . . . 7. excel Solver.

XLS Basic Excel functions 2-SOLUTION.XLS Solution of a single equation in a single variable 3-SOLVER.XLS Solver applied to solution of equations, interpolation, and approximation 4-FITTING.XLS Acurvefitting example where using Excel Trendline gave poor results 5-DIFF-EQNS.XLS Different problems solved by different methods 6-SPLINES.

  Basics, Excel, Numerical, Excel basics