Thread: Error in formula displayed for linear and 2nd order curve fits inExcel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default Error in formula displayed for linear and 2nd order curve fits in Excel 2003
What version of Excel? Could you include the data in a follow up post (not
as an attachment), along with the coefficients you've computed?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
I have created trendlines for some pretty simple data using both 2nd
order polynomial and linear fits. In both cases, the displayed
formulas have their 1st and 2nd order coefficients wrong by a factor
of 10!! (I have read lots of posts about increasing precision but this
is not what I am up against). Has anyone seen this?


Reply With QuoteReply With Quote