Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance (https://www.askmehelpdesk.com/forumdisplay.php?f=125)
-   -   I need to know the Excel formulas for an ARIMA analysis of a time series. (https://www.askmehelpdesk.com/showthread.php?t=457588)

  • Mar 14, 2010, 03:00 AM
    greasedlight
    I need to know the Excel formulas for an ARIMA analysis of a time series.
    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,
  • Mar 14, 2010, 04:02 AM
    ROLCAM

    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.
  • Mar 14, 2010, 04:08 AM
    ROLCAM

    greasedlight,

    Please see:-

    Introduction to ARIMA models
  • Feb 15, 2012, 06:26 PM
    spiderxl
    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.