box jenkins forecast

S

Shane Devenshire

Hi,

There is nothing built in to do ARIMA forecasting but you can use Excel's
functions or you can write code to do it.

Take a look at this:
Business Analysis with Excel 2nd Edition, Que, 2002, has VBA code that
calculates and charts a time series' ACFs and PACFs. Once you've identified
the ARIMA model you're in a position to create the forecast using Excel's
worksheet functions.

Conrad Carlberg
Excel Sales Forecasting for Dummies, Wiley, 2005
 
R

rajashekharkr

Hi,

There is nothing built in to do ARIMA forecasting but you can use Excel's
functions or you can write code to do it.

Take a look at this:
Business Analysis with Excel 2nd Edition, Que, 2002, has VBA code that  
calculates and charts a time series' ACFs and PACFs. Once you've identified  
the ARIMA model you're in a position to create the forecast using Excel's 
worksheet functions.

Conrad Carlberg  
Excel Sales Forecasting for Dummies, Wiley, 2005  

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire





- Show quoted text -
Click to expand...

Hi Shane,
THanks for your valuble feed back, Could you please send me an example
for noxJenkins model in excell.

Cheers,
Rajashekhar
 
Top