coefficients of trend line

R

raymondvillain

I have made a graph of my data and used the "trend" feature of Excel 2007 to
add a polynomial trend line to the graph. I need to use the coefficients in
subsequent calculations. It is tedious to type them into cells manually. Is
there not a way to have Excel automatically enter them into a cell, without
using LINEST() or TREND()?
thanks,
Henry
 
J

joeu2004

I have made a graph of my data and used the "trend" feature of Excel 2007 to
add a polynomial trend line to the graph. I need to use the coefficients in
subsequent calculations. It is tedious to type them into cells manually. Is
there not a way to have Excel automatically enter them into a cell, without
using LINEST() or TREND()?
Click to expand...

Why not use LINEST()? See the bottom of
http://j-walk.com/ss/excel/tips/tip101.htm .
 
R

raymondvillain

Thanks, I will use this, but still, if one adds a trend line to a graph, the
coefficients of the curve fit have to be somewhere in Excel, so it seems like
it ought to be possible to have them written to specific cells, instead of
just "appearing" in the label of the curve fit. If I can edit the format of
the coefficients (scientific, number of decimal places, etc.) then it sure
would be nice to have them in a location accessible to the rest of the spread
sheet.
 
H

Harlan Grove

joeu2004 said:
On Jul 7, 8:02 pm, raymondvillain

Why not use LINEST()? See the bottom of
Click to expand...
....

LINEST doesn't always provide the same result as chart trend lines. Prior to
Excel 2007, the numeric programming behind chart trendlines was superior to
that behind LINEST. I've seen postings that this may have been reversed in
Excel 2007, so OP may be better off using LINEST even if it does give
different results than chart trendlines.

But FTHOI, see

http://groups.google.com/group/microsoft.public.excel.misc/msg/4d440d271303e0d6
 
Top