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
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
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