Facts and Myths about Normality Test

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…

Classic – Airline Passenger Data

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,…

Volatility Forecast with GARCH

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;…