On Thu, 28 Jul 2005 14:41:03 -0700, "Simon Y" <Simon
wrote:

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.

I assume you are looking at the generated coefficients from the graph of the
trendline. The display is not, by default, formatted to show you the real
results.

To change this, right click in the area of the equation and select Format Data
Label. Then format Number to 15 places and the resultant numbers should give
you the result you desire.


--ron