View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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