View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default coefficients of polynomial

http://lib.stat.cmu.edu/apstat/274
or
http://lib.stat.cmu.edu/apstat/274-90

give Fortran (or Fortran90) code for solving models that are linear in the
unkown parameters (such as polynomials).

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.