How to get polynome (or other type) coefficients of a trendline?
 

I would like to get coefficients of a trendline (any type) from a chart into
a cell for further analysis.Thanks

You can use LINEST for this purpose
http://www.stfx.ca/people/blie ngme/ExcelTips/Polynomial.htm
Help for LINEST may have misled you into thinking that it is far more
limited than it really is.

Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells

http://groups.google.com/groups?selm....microsoft.com

The advantage of using the chart coefficients (either manually or via
Braden's code) is that pre-2003 LINEST uses a numerically poor algorithm
that can give inaccurate results with some data sets. The chart
trendline (extracted by Braden's code) is much better numerically,
provided you format the equation to display to full precision
(scientific notation with 14 decimal places).

Jerry



GoranR wrote:

I would like to get coefficients of a trendline (any type) from a chart into
a cell for further analysis.Thanks