Tag Archives: iterative solution

Solving the Lagrangian Point equation for the Moon

Posted on June 23, 2019 by dougaj4

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading →

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

Brent’s Method; Update and Examples

Posted on December 6, 2017 by dougaj4

Brent’s Method is a refinement of Newton’s Method for the numerical solution of any equation with one variable.  The User Defined Function (UDF) QuadBrent was described in:  The Inverse Quadratic Method 3 – Brent’s Method Following a recent question, I have … Continue reading →

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

The Inverse Quadratic Method 3 – Brent’s Method

Posted on April 13, 2010 by dougaj4

The previous post in this series presented iterative methods to solve polynomial equations using direct or inverse quadratic interpolation.  These methods have two disadvantages: In some circumstances the function may converge very slowly, or not at all. The name of … Continue reading →

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