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.
Difference filter- Run the difference operator (i.e. DIFF) with lag order of 1.
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.
댓글
There are three ways to detrend a time series:
댓글을 남기려면 로그인하세요.