6th order polynomial equ yields unexpected results

I suppose so... {grin}

On a related topic, maybe you missed my post of the code for extracting
the trendline data to a worksheet. Or, maybe you didn't but have been
busy. In any case, the link:

http://groups.google.com/group/micro...rting/msg/0eda
30f29434786d?dmode=source&hl=en

And, of course, you are welcome to use either email or the NG for
followups.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Since the OP is comparing LINEST with the chart trendline, he must have
already plotted the data. On the assumption that he actually looked at
the plot that he produced, I can only assume that he is interested in
the numerics of the fitting process, not the quality (or lack thereof)
of this particular fit.

Jerry

Tushar Mehta wrote:

If you plot the data you will quickly see that the only trend is a flat
horizontal line or, with the application of a fair dose of imagination,
a slight downward sloping trend.

I don't recall seeing it the first time around. Thank you for pointing
it out. I will review and comment.

Jerry

Tushar Mehta wrote:

I suppose so... {grin}

On a related topic, maybe you missed my post of the code for extracting
the trendline data to a worksheet. Or, maybe you didn't but have been
busy. In any case, the link:

http://groups.google.com/group/micro...rting/msg/0eda
30f29434786d?dmode=source&hl=en

And, of course, you are welcome to use either email or the NG for
followups.