box jenkins forecast
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
"Hung NH" wrote:
How to do a Box-Jenkins forecast in Exel?
Thanks
|