LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Simon Y
 
Posts: n/a
Default trendline coefficient accuracy

I am trying to establish the polynomial coefffiecients for a fuel
consumtption curve for one of our ships. I have plotted the recorded
consumption data from the ship and trended them with a 3rd power
polynomial. the curve folllows the data well, however, the set of
genertated coefficients, which when put back into the graph to generte test
curve that in no way refelct the original tend line. and can't be used to
forcatst the fuel budget. I must be doing something stupid.

Thanks,

Simon.

 
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
Trendline Extract Phil Hageman Charts and Charting in Excel 5 July 6th 05 02:27 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Trendline to ignore empty cells Kara Charts and Charting in Excel 0 June 9th 05 05:39 PM
How do I write a trendline constant into a cell? Hanbotkot Charts and Charting in Excel 2 December 31st 04 05:27 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 05:00 PM.

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"