How to Automate Copying of trendline equation to a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kmartin - 08 Oct 2007 23:09 GMT

I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values.

For example I have data at time 100, 200, 300 and 500, but want to
automatically have the equation of the trendline fitting my data copy over to
a set of cells where the intermadiate data for time 25,50,75 etc will be
calculated.
I typically fit a polonomial trendline?

Reply to this Message

Bernard Liengme - 09 Oct 2007 02:14 GMT

Polynomial, non-linear, Trendline Coefficients
and Regression Analysis

http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I want to figure out have excel take an equation for a trendline out of a
> chart and paste it into a set of cells to calculate new values.
[quoted text clipped - 5 lines]
> calculated.
> I typically fit a polonomial trendline?

Reply to this Message