### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- A very un-useful "feature"
- Commenting a block of code in VBA
- Time in hours and minutes between two dates
- Fitting high order polynomials
- Cubic Splines
- Installing Adobe Reader non-DC version.
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting

### Recent Comments

dougaj4 on Using LinEst() on data with… Chris on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Chris on Using LinEst() on data with… dougaj4 on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … Sunny on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … Sunny on Concrete ULS spreadsheet … Using Numba with Exc… on Two Timers masood bhatti on Deflections and Moments in Rec… Kapasitas Lateral Ti… on LatPile – Analysis of La… mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness…

# Tag Archives: Solve polynomial

## Polynomial Update

Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quartic, Solve polynomial, UDF, VBA
12 Comments

## Daily Download 19: Solving polynomials

Today’s download provides analytic solutions to polynomial equations up to fourth order (that is quadratic, cubic and quartic equations) and an iterative method to solve equations of higher order. All these functions are found in the download file: http://interactiveds.com.au/software/Polynomial.zip The … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quadratic, Quartic, Solve polynomial, UDF, VBA
1 Comment

## Ping Back Ping Backs

One of the nice things about writing a blog is that when people follow a link to your site you get a link to where they came from, which often leads to interesting places you would not have otherwise found. … Continue reading

Posted in Excel, Newton, VBA
Tagged Colin Legg, EE Times, links, RAD Excel, Solve polynomial
Leave a comment

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