box jenkins forecast

[Hung NH]

How to do a Box-Jenkins forecast in Exel?
Thanks

 

[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

 

[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 -

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

Cheers,
Rajashekhar

 

[Mike]

=IF((A1-FLOOR(A1;5))<(CEILING(A1;5)-A1);FLOOR(A1;5);CEILING(A1;5))

Nearest 5.

 

[Mike]

Sorry, wrong thread.

=IF((A1-FLOOR(A1;5))<(CEILING(A1;5)-A1);FLOOR(A1;5);CEILING(A1;5))

Nearest 5.