Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Commenting a block of code in VBA
- Contour plots with Excel and Matplotlib
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Goal Seek on Multiple Cells
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
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
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 Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
12 Comments