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 would be useful to have a UDF that would evaluate a polynomial for complex roots, and in writing that I added some new functions to the ALGLIB complex number spreadsheet presented in this post.  The end result of this work is:

Three new functions for the AL-Complex spreadsheet (as always, all the spreadsheets mentioned here are available for download, including full open source code)

ALGLIB Complex number functions, click for full size view

A new complex number function for the EvalPoly spreadsheet:

EvalPoly spreadsheet

And corrected code for the Quartic function in the Polynomial Spreadsheet, plus evaluation of the maximum error in the input function using the roots generated by the Quartic and CubicC functions:

Quartic spreadsheet

Advertisements
This entry was posted in AlgLib, Excel, Maths, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

2 Responses to Complex Numbers and Solving Quartic Polynomial Equations

  1. Pingback: Solving higher order polynomials | Newton Excel Bach, not (just) an Excel Blog

  2. Pingback: Daily Download 19: Solving polynomials | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s