Tag Archives: Numerical methods

Brent’s Method and a daft engineer’s blog

Posted on December 23, 2016 by

Browsing links on Brent’s Method I found: Daft Engineer – Numerical Methods and Excel* which is well worth a look (plenty of stuff on statistics and Python, with the odd dash of Excel).  The link has VBA code for a … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , | 3 Comments

XNumbers and Tropical Events

Posted on March 10, 2011 by

My on-line friend Al Vachris recently sent me a link to the Tropical Events site, which features a detailed analysis of the orbital motion of the Earth and the other bodies of the solar system, all done in Excel, and … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration | Tagged , , , | 16 Comments

Evaluating higher order polynomials …

Posted on January 17, 2011 by

… and a better solution for quadratics. Having written a better solver for high order polynomials, that raises a few other issues.  The error in the roots found by the RPolyJT was checked by simply substituting each root as the … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 4 Comments

Solving higher order polynomials

Posted on January 13, 2011 by

The Quartic spreadsheet presented here previously (most recently here) uses algebraic techniques to provide an “exact” solution to polynomial equations of up to fouth order.  For polynomials of higher order there is no general algebraic solution, and numerical methods are … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 12 Comments

Numerical solutions with CSpline

Posted on May 5, 2010 by

The CSpline function presented in a previous post  fits a series of cubic polynomial curves to a specified series of points, returning the Y values for listed intermediate X values.  I was recently asked if this could be reversed to … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

Gaussian Quadrature

Posted on April 10, 2009 by

The previous post on integration provided an Excel User Defined Function (UDF) to perform numerical integration using Simpson’s Rule or the Trapezoidal Rule.  A third method is Gaussian Quadrature which is often much more accurate and/or quicker than Simpson’s Rule.  The UDF GaussInt() … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 27 Comments