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()?

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
....

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top