Discovering the trendline parameters

[Pavils Jurjans]

Hello,

Here's a question on charting/trendlines:

If I have a sample data set I have based a 2D scatter graph. and I have
added a trandline to it, specifying that it's a 3rd order polynomial graph,
is there any way to discover the ploynomial parameters Excel calculated to
display this trendline?

Thanks,

-- Pavils

 

[Jerry W. Lewis]

Check out the Options tab in the Add Trendline dialog.

Alternately, you could use LINEST(ydata,xdata^{1,2,3}),
but the chart trendline is numerically better in versions prior to 2003.

Jerry