4th Order Polynomial in Excel
4th Order Polynomial in Excel
(OP)
I am looking to solve a 4th order polynomial in an Excel spread sheet. I am currently using an add-in function I found on the web however this add-in is password protected and the spread sheet that I created can not be shared with anyone with out this add in. I am looking to create a function that I can call out in the spread sheet and be able to share this spread sheet with others. This spread sheet is only to share among colleagues for informational purposes.
Is there code I can cut and paste into a VB module that could achieve this?
Is there code I can cut and paste into a VB module that could achieve this?





RE: 4th Order Polynomial in Excel
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: 4th Order Polynomial in Excel
There is a non-iterative algorithm for the solution of the general quartic equation, but it's not all that easy. I have never attempted to code it.
This is an engineering forum, and with most engineering problems the engineer has a rough idea of the answer to a problem before beginning to solve it. If this applies to your case, you could devise your own iterative algorithm tailored to the general characteristics of the problem. You could then code that in VBA as a user-defined function. Finally, test it to the very limits of your likely range of actual problems, or slightly beyond those limits, then build in some traps for problems that exceed your tested limits.
HTH
RE: 4th Order Polynomial in Excel
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: 4th Order Polynomial in Excel
Four
although some may be imaginary and/or repeated.
Cheers
Greg Locock
RE: 4th Order Polynomial in Excel
RE: 4th Order Polynomial in Excel
imaginary and repeated roots?
TTFN
RE: 4th Order Polynomial in Excel
RE: 4th Order Polynomial in Excel
TTFN
RE: 4th Order Polynomial in Excel
Mathematics should be beautifully and brilliantly precise.
Problems always arise when we intermingle the two.
To express the same sentiment in a bad haiku:
Words show shades of grey.
Maths is all ways black and white.
Take care when you mix.
RE: 4th Order Polynomial in Excel
I always use XYMath for serious curve fitting
athomas236