Tag Archives: inverse quadratic

Brent’s Method; Update and Examples

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

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