Box-Jenkins using Excel

B-J smart is an automated excel template which shows ARIMA modelling in excel using the famous Box Jenkins Methodology. The user needs to just put the data in the data tab and B-J smart does all the steps starting from checking Covariance Stationarity using ACF & PACF plots to validating the model using various Statistical & Accuracy tests like Ljung Box, AIC,BIC etc. What’s more exciting to know is that everything is in excel without any VBA code or macros.