In MATLAB you can use the forecast function, as far as you have the econometrics toolbox.
In EXCEL I would suggest, that you either program it in VBA or use R in background to do your time series calculations.
Why dont you try Minitab packge to run this method. I think it much easy
Textbook: P. Brockwell and R. Davis
Introduction to Time Series and Forecasting
Springer-Verlag, New York, 2002,1996. [TS]
There is complementary ITSM program which may be downloaded
from the Springer site
http://extras.springer.com/2002/978-0-387-95351-9.
Best wishes.
try to use Minitab, SPSS, or EViews package software to get coefficient or ARIMA parameter, then you can use them on Excel with your best fitt ARIMA model on timeseries data
Simply use the formula for arima model (including autoregrerssive part and moving average part) where you have to input a past inflow for the correlation and two previous inflows to represent the trend (increasing or decreasing flow from one period to the next). Good luck, Ricardo
whats the difference in using ARIMA Model in Excel ,Minitab,XLSTAT. Why ARIMA model best suites in forecasting
If yu specifically want to implement it in excel, then either use XLSTAT or NumXL
- Badges
- Science topic