View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default How can I curve fit in Excel?

Why do you think it incorrect. My bet is you have too few decimals
displayed. Format the trendline equation to show 15 places and try again.
Then experiment with LINEST to get polynomial coefficients as shown at
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jimg" wrote in message
...
I am trying to determine the equation defining a curve in Excel. When I
apply a trendline using a polynomial equation, the equation returned is
incorrect. Is there a method to "fit a curve" and determine the equation
defining the curve?