Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- RCInteract and RC Design Functions 7.03
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
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 Brents method, Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
5 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 Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
12 Comments