LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
E0sysengiineer
 
Posts: n/a
Default Results of trend line in Excel

I fitted some data using the trend line tool. The fit purportedly was a 3-rd
order polynmial. When I create a column of values using the coefficients
that Excel found (Display equation), I find the data does not overlay the
trend line. I created data in the range of the fit so there is no error due
to extrapolation and the fit R value was 0.9999. Is there an error in the
routine that reports the coefficients for polynomial fits? If so, is the re
a patch or work around?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quantify trend line Brisbane Rob Excel Discussion (Misc queries) 3 March 5th 06 07:45 PM
Getting values from a trend line Andrew Excel Discussion (Misc queries) 3 February 22nd 06 06:27 PM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 06:32 PM
how to change line spacing for text box in excel chart Anne Charts and Charting in Excel 1 October 5th 05 12:11 AM
How do I get a value of a calculated point on an excel line chart? klc6778 Charts and Charting in Excel 3 September 26th 05 02:17 AM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"