## 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 | | 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 | | 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 | | 5 Comments