From your new post to the old thread "Trend Line constants as Excel Cell
Values" I wonder if you were looking for a "quintic equation" similar to the
well known quadratic equation. Such a general solution for the roots of a
quintic does not exit
http://en.wikipedia.org/wiki/Quintic
Jerry
"Doublee" wrote:
What I meant to say is that I need the equations for the coefficients of the
polynomial to put into a Fortran program so that I can use them in a do loop
in a program that I am writing. I understand that the the math might be
complicated but I am willing to try it. A published reference that contains
this information would suffice.
"Doublee" wrote:
How do I calculate the coefficients of a 5th order polynomial? A reference
would suffice. The data consists of up to 50 equally spaced data points and
consists of real positive numbers. I am already aware of the equation as
displayed in Excel on the chart but the format is not useful to me because I
want to embed the calculations of the coefficients into an Excel 2007 cell.