In this week’s issue of Tips & Tricks, we use the NumXL package to demystify the normality test, a common diagnostic tool in econometric and time series analysis. Using the Analysis Pack Add-in in Excel, we generate 5 series of…
In this week’s issue of Tips & Tricks, we consider the process of model comparison, as well as the selection of the best model. Using a monthly total sales time series for Company X, we conduct our preparatory analysis and…
In this week’s “Tips and Tricks” newsletter, we present the analysis, modeling, and forecast for international airline passenger data. We make use of a familiar example that first appeared in Time Series: Forecast and Control, a textbook by Box, Jenkins,…
This week, the “Tips & Tricks” newsletter tackles the issue of the volatility forecast using GARCH Modeling techniques. Starting with S&P 500 ETF monthly prices, the paper illustrates the few steps it takes to process the raw data; specify a model;…