Tag Archives: Cubic

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

Posted on January 14, 2014 by dougaj4

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 , , , , , , , , , | 13 Comments

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

Posted on October 13, 2013 by dougaj4

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

Polynomial Update

Posted on October 30, 2012 by dougaj4

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

Daily Download 19: Solving polynomials

Posted on October 6, 2012 by dougaj4

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 , , , , , , , , | 1 Comment

Complex Numbers and Solving Quartic Polynomial Equations

Posted on September 19, 2010 by dougaj4

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 , , , , , , | 2 Comments