Polynomial Trendline

  • Thread starter Thread starter Royi Avital
  • Start date Start date
R

Royi Avital

Hello.
I found the Trendline function in Charts very useful.
My question is: Are there equivalent functions?

hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline
there are Polynomial Approximations, Exponential Approximations etc... Which
I couldn't find anywhere. Are they available? How can I create the dataset
according to Excel approximation?

Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least
Squares, etc..)?

I'm using Office 2007.

Thanks.
 
As noted by example in the previous link, pretty much all of the chart
trendlines can be fit via LINEST using either array formulas or tranformation
to linearity. A couple of comments are in order, though.

For the transformed fit to be optimal, you must assume equal variance
(across x values) on the transformed scale, not the original scale.
Otherwise either a weighted or nonlinear fit is more appropriate; neither of
which is natively available in Excel, though you could "roll you own" if you
know what you are doing.

Assuming north american regional settings, the polynomial fits shown at the
link assume that the x and y values are given in columns. If they are given
in rows, then the power separater would be a simicolon instead of a comma.

Jerry
 
As noted by example in the previous link, pretty much all of the chart
trendlines can be fit via LINEST using either array formulas or tranformation
to linearity. A couple of comments are in order, though.

For the transformed fit to be optimal, you must assume equal variance
(across x values) on the transformed scale, not the original scale.
Otherwise either a weighted or nonlinear fit is more appropriate; neither of
which is natively available in Excel, though you could "roll you own" if you
know what you are doing.

Assuming north american regional settings, the polynomial fits shown at the
link assume that the x and y values are given in columns. If they are given
in rows, then the power separater would be a simicolon instead of a comma.

Jerry
 
Are those "Official" formulas by Microsoft?
I see they didn't let the user get the results as a data set.


Thank you very much.
 
Are those "Official" formulas by Microsoft?
I see they didn't let the user get the results as a data set.


Thank you very much.
 
Back
Top