### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Writing Arrays to the worksheet - VBA function
- Fitting high order polynomials
- Cubic Splines
- Biaxial bending update

### Recent Comments

dougaj4 on Daily Download 5: Frame A… robertocastanocrespo on Daily Download 5: Frame A… Rober on Daily Download 5: Frame A… dougaj4 on Deflections and Moments in Rec… debamita on Deflections and Moments in Rec… A Numpy trap –… on Using Numba with Excel and pyx… dougaj4 on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… Benata on ULS Design Functions upda… Benata on ULS Design Functions upda… Benata on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… Ata on ULS Design Functions upda… dougaj4 on ULS Design Functions upda… SHAMIL NURI on ULS Design Functions upda…

# Tag Archives: Cubic

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

## Python for VBA users – 5; Using built in numpy functions

Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged complex numbers, Cubic, Excel, high order polynomials, Jenkins-Traub Method, Polynomial, Python, PyXLL, Quadratic, Quartic, UDF, VBA
5 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
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

## Complex Numbers and Solving Quartic Polynomial Equations

It was recently pointed out to me that the User Defined Function (UDF) for solving quartic polynomial equations presented in this post returned an error for some input values. In tracking down the source of the error I decided that it … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Cubic, Excel, Polynomial, Quartic, UDF, VBA
2 Comments