Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forecast | Excel Discussion (Misc queries) | |||
Sales Forecast | Excel Discussion (Misc queries) | |||
Forecast | Excel Worksheet Functions | |||
Box-Jenkins techniques & Time Series | Excel Worksheet Functions | |||
forecast | Excel Discussion (Misc queries) |