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

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

On Dec 5, 11:05*am, Shane Devenshire
wrote:
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- Hide quoted text -

- 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

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

Nearest 5.

On 5 joulu, 12:36, wrote:
On Dec 5, 11:05*am, Shane Devenshire



wrote:
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- Hide quoted text -

- 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

Sorry, wrong thread.


On 6 joulu, 13:07, Mike wrote:
=IF((A1-FLOOR(A1;5))<(CEILING(A1;5)-A1);FLOOR(A1;5);CEILING(A1;5))

Nearest 5.

On 5 joulu, 12:36, wrote:

On Dec 5, 11:05*am, Shane Devenshire

wrote:
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- Hide quoted text -

- 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