Discovering the trendline parameters

  • Thread starter Thread starter Pavils Jurjans
  • Start date Start date
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
 
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
 
Back
Top