View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Program for calculating a power trend line

the trend line in the Graph Function.

Linest

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST. Perhaps you can adapt a similar approach to working
with your 6th order polynomial equation.

http://www.stfx.ca/people/bliengme/E...Polynomial.htm

--
Regards,
Tom Ogilvy

"Houston banker" <Houston wrote in message
...
I have a set of data that is non-linear and believe it will fit a power

trend
equation. I have been unable to locate a program that will curve fit the
data.