ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I determine which order to use in a polynomial trendline? (https://www.excelbanter.com/charts-charting-excel/127725-how-do-i-determine-order-use-polynomial-trendline.html)

Nina

How do I determine which order to use in a polynomial trendline?
 
I have two years worth of monthly revenue data. I'd like to forecast the next
year based on this data. Should I use the polynomial trendline? If so, which
order do I need to use?

Jerry W. Lewis

How do I determine which order to use in a polynomial trendline?
 
Most business have a strong seasonal component which would typically involve
a Fourier analysis. After removing the seasonal component, you could look
for a systematic trend, which might involve a low order polynomial.

When fitting polynomials without a theoretical justification for the model,
beware of overfitting the data.

Jerry

"Nina" wrote:

I have two years worth of monthly revenue data. I'd like to forecast the next
year based on this data. Should I use the polynomial trendline? If so, which
order do I need to use?



All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com