The variables of interest are oil imports to Germany, and temperature in Germany. The latter is used as a leading indicator for the former, to improve on the forecast obtained by the univariate model. Both variables are collected over a time range from January 1985 until and including December 1997, whereas the last year is not used for constructing the optimal forecast, obtained by fitting a model through the data until the end of 1996. This will enable us to forecast the year 1997 using our model, and then comparing it to the actual data. Assuming no large one time shock, meaning that it is not captured by seasonality or cyclical behaviour in the data, occurs in this year, a graphical comparison of our forecast and the whole data range (including 1997) will tell us something about the preciseness of our model. Both variables are of monthly frequency. On the one hand this will leave us with enough observations (144) to have a reliable forecast; on the other hand, due to the nature of the data it makes intuitive sense to use monthly data at the project at hand. The data series are not seasonally adjusted.
First we will smooth the series by transforming the data on oil demand into their logarithmic form. The log transformation allows the model to be less vulnerable to outliers in the data, and thus enables for a more precise forecasting model. Next the data series must be checked for trend and seasonality. Figure 1.1 shows the time series plot for the log transformation of oil imports in Germany from 1985M01 until 1996M12. [pic]
Before fitting a trend and seasonal dummies to the model, we must include an intercept, because we are obviously not starting at 0. The time path of oil imports in Germany is clearly trending upwards through time. This makes intuitive sense as population is growing, increasing the demand for oil. Even so it appears to be definite that we have a linear trend, the series will be regressed using a linear, a quadratic and exponential trend. Their Schwarz-statistics are 0.270771, 0.273061 and 0.510128 respectively. Therefore the linear trend will be characterizing the steady upward moving from here on. Next we can identify a cyclical pattern with its peaks in the winter and lows in the summer. Therefore monthly seasonal dummies are included into the model, with base January. After adding 11 monthly dummies to the model, the Schwarz-statistic falls to -1.347847.
|Dependent Variable: LNIMPO | | | |Method: Least Squares | | | |Date: 03/26/12 Time: 11:25 | | | |Sample: 1985M01 1996M12 | | | |Included observations: 144 | | | | | | | | | | | | | | | |Variable |Coefficient |Std. Error |t-Statistic |Prob. | | | | | | | | | | | | | |C |11.88281 |0.032918 |360.9821 |0.0000 | |TIME |0.005747 |0.000208 |27.64934 |0.0000 | |@MONTH=2 |-0.116650 |0.042182 |-2.765377 |0.0065 | |@MONTH=3 |-0.165850 |0.042184 |-3.931585 |0.0001 | |@MONTH=4 |-0.347689 |0.042186 |-8.241727 |0.0000 | |@MONTH=5...