Transcription of Numerical methods - JohnDFenton
{{id}} {{{paragraph}}}
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 .. 11. 5. Systems of equations .. 11. Solution by optimisation.
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.XLS Use of cubic splines for interpolation SPLINES.XLS Contains the spline functions necessary for the previous ...
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}