I think that's exactly right. If you regress on the original series yt and there is a slope (well... a significant slope) then you have to first difference it. Then, regress on the differenced series to get the coefficient of your AR(1) model. To do an AR(2) you have to have a two variable regression... unfortunately the add-in in excel won't do this (because you have to do the regression simultaneously). I found a program online that does multivariate regression. If you use SAS at all that will do it for you too. I wish we were given a program that went a long w/ this class and that procedures we needed to do.
[NEAS: The comment about a significant slope is not correct. The add-in can handle an AR(2) model well enough for the student project. Statistical software like SAS can be expensive; we do as much as possible in Excel.
Jacob: If we regress the original series on the same series lagged one period (regress yt on yt-1) and the slope coefficient is significant, should we take first differences?
Rachel: That depends on the slope coefficient.
If 0 < β < 1, the time series process may be autoregressive and stationary with a positive parameter. We do not necessarily take first differences; we examine the residuals for various ARIMA models, such as AR(1), AR(2), MA(1), ARMA(1,1), starting with the most reasonable model, usually AR(1), and testing other models if the simpler ones don’t fit.
If –1 < β < 0, the time series process may be autoregressive, stationary, and oscillatory with a negative parameter. This process is less common but not unusual. We examine the economic, financial, or actuarial relations to understand the negative parameter. The negative β may also stem from measurement error, rounding, or other random errors.
If β . 1, the time series may be a random walk. It is not stationary, but its first differences may be a stationary white noise process. This type of process is common in financial and actuarial work.
If β > 1, we graph the series on a logarithmic scale. If the series appears linear, we regress ln(yt) on ln(yt-1). If β . 1, the logarithm of the time series may be a random walk. This is very common in financial and actuarial work. Stock prices and inflation indices are examples.
If β . –1, or β # –1, the time series is unusual. You should re-check the data before going on.
Jacob: What if β = 0.90? Is that close enough to 1 that the time series is a random walk?
Rachel: That depends on the number of observations. We use tests of significance to see if we can reject the null hypothesis that β = 1.
Jacob: Can we use the Excel regression add-in for an AR(2) model?
Rachel: Yes; choose yt as the dependent variable, and the two independent variables are yt-1 and yt-2.