Polynomial regression

[EpsilonRho]

Is there any way to transfer automatically the polynomial regression factors
(of a higher order) calculated in charting to a spreadsheet without being
forced to copying them by hand, digit by digit?
TIA,
Gene

 

[Guest]

Unless you are fitting a higher order polynomial, where you need the better
algorithm of the chart trendline to get meaningful results, it is easier to
use LINEST for this purpose
http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm

Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline.
http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29434786d

Jerry