Detrended time series


My time series exhibits a trend, and I wish to separate the trend from my data so I am looking at a stationary process. How can I do this with NumXL?


1 comment
  • There are three ways to detrend a time series:

    1. Linear detrend - Run a linear regression of your time series on t (time) and subtract that trend out. Use NxTrend function with a linear trend-type. This is method is often applied for time series with a non-stochastic/deterministic trend pattern.
    2. Difference filter- Run the difference operator (i.e. DIFF) with lag order of 1. 
    3. Other filters - Define  a new variable as a complex combination of your current and lagged time series. Most popular is called Hodrick-Prescott filter - which is part of X-12-ARIMA Function in NumXL.
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post