Discovering the trendline parameters

P

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
 
J

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
 
Top