I have a weekly numerical time series for which I need to forecast the nest in the series. ARIMA seems a promising approach. Can anyone who is a statistics wiseguy supply the Excel formulas?
TIA,
![]() |
I have a weekly numerical time series for which I need to forecast the nest in the series. ARIMA seems a promising approach. Can anyone who is a statistics wiseguy supply the Excel formulas?
TIA,
Spreadsheet implementation: ARIMA models such as those described above are easy to implement on a spreadsheet. The prediction equation is simply a linear equation that refers to past values of original time series and past values of the errors. Thus, you can set up an ARIMA forecasting spreadsheet by storing the data in column A, the forecasting formula in column B, and the errors (data minus forecasts) in column C. The forecasting formula in a typical cell in column B would simply be a linear expression referring to values in preceding rows of columns A and C, multiplied by the appropriate AR or MA coefficients stored in cells elsewhere on the spreadsheet.
greasedlight,
Please see:-
Introduction to ARIMA models
Calculating the forecast errors for an ARIMA model is not straight-forward, and without a proper confidence interval, any forecast is worthless.
I strongly recommend to either use a statistical package with Excel Add-in interface (e.g. E-Views, SAS, R, SPSS, S-Plus), or a Econometric excel add-in (e.g. XLStat, NumXL, etc). They all enhance excel analytical capabilities and make econometric type of analysis much easier.
Regards.
All times are GMT -7. The time now is 03:04 AM. |