### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Retrieving unique values from a range or array ...
- Writing Arrays to the worksheet - VBA function

### Recent Comments

#Excel Super Links #… on Excel to Alglib via xlwin… Excel to Alglib via… on Installing xlwings 0.11.4 Excel to Alglib via… on Alglib/Python spline functions… dougaj4 on Smart Indenter and Excel … ThunderFrame on Smart Indenter and Excel … dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LinEst() on data with… Joe on Using LINEST for non-linear cu… Julian on Using LinEst() on data with… dougaj4 on Cubic Splines James on Cubic Splines ravinder on Linking AlgLib C++ to Excel… Alberto on 3DFrame update Using the Frame Anal… on 3D Frames, axes and stiffness… dougaj4 on 3DFrame with spring relea…

# Tag Archives: Jenkins-Traub

## Solving Quadratic, Cubic, Quartic and higher order equations; examples

A previous post presented a spreadsheet with functions for solving cubic and quartic equations, and this has been extended with another function solving higher order polynomials. The functions are actually very easy to use, but the documentation in the spreadsheets is quite brief, … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged Cubic, Excel, Higher order polynomials, Jenkins-Traub, Python, Quadratic, Quartic, solving polynomials, UDF, VBA
6 Comments

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

## Linest, NPV, IRR and solving polynomials

In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, IRR, Jenkins-Traub, NPV, polynomial solution, UDF, VBA
3 Comments

## Evaluating higher order polynomials …

… and a better solution for quadratics. Having written a better solver for high order polynomials, that raises a few other issues. The error in the roots found by the RPolyJT was checked by simply substituting each root as the … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
4 Comments

## Solving higher order polynomials

The Quartic spreadsheet presented here previously (most recently here) uses algebraic techniques to provide an “exact” solution to polynomial equations of up to fouth order. For polynomials of higher order there is no general algebraic solution, and numerical methods are … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
11 Comments