Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Calling Add-in functions from VBA
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Passing variable argument lists from Excel to Python via xlwings
Recent Comments
Tag Archives: quadratic interpolation
Interpolation Update
The interpolation functions in IP2.xls have been given an overhaul: The linear and quadratic interpolations routines have been modified to accept negative values. All the routines have been modified to convert the table range to an array, rather than using a … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Interpolation, logarithmic interpolation, quadratic interpolation, UDF, VBA
4 Comments
The Inverse Quadratic Method – 2
Firstly a clarification from the previous post in this series. The method presented in that post was a direct application of quadratic interpolation, rather than the inverse quadratic method, as implied by the post title. The inverse quadratic method will be … Continue reading
Posted in Excel, Maths, UDFs, VBA
Tagged Excel, quadratic interpolation, Solve polynomial, UDF, VBA
3 Comments
Function roots with the Inverse Quadratic Method
An earlier post presented various methods for finding the roots of polynomial functions based on the use of linear interpolation. It is sometimes advantageous to use a quadratic interpolation function, and methods using this approach will be presented in this and following … Continue reading
Posted in Excel, Maths, UDFs, VBA
Tagged Excel, quadratic interpolation, Solve polynomial, UDF, VBA
5 Comments