# Assignment 1 with solution

**Topics:**Regression analysis, Normal distribution, Trend estimation

**Pages:**5 (1174 words)

**Published:**December 29, 2014

You are the chief analyst to monitor an eastern city’s government consumption expenditures. Using the city’s quarterly government consumption data {yt} measured in billion dollars from 2007-Q1 to 2014-Q3, you are trying to estimate the linear trend model: yt = + t + ut, where ut ~ N(0, ). (A)Supposing t = 1 for the starting quarter (i.e., 2007-Q1), then what is t for 2014-Q3?(1 mark) (B)Suppose your OLS (ordinary least squares) estimates for the trend model are = 1.62 and = 3.55, and the sum of squared residuals (SSR) = ût2 = 725. Based on your estimated trend model, construct a point forecast and an interval forecast for the city’s government consumption expenditures in 2014-Q4.(9 marks) (C)It is calculated that = 928. Use the Durbin-Watson (DW) test to determine if there is (first-order) serial-correlation in the population errors {ut} at the 5% significance level. (The corresponding lower and upper critical values of the DW-test is dL = 1.363 and dU = 1.496 respectively.) (5 marks)

2. The quarterly data for U.S.’s beverage manufacturer product shipments (yt) from Q1-1992 to Q4-2006 is given in the data file: Asgn1_data.xls, based on which some models are required to estimate and some forecasts to make. 2.1Estimating trend and making trend forecasts(11 marks) (A)Indicate the patterns in the data (by plotting the data and observing the graph).(1 mark) (B)Fit a regression trend line ŷt =+t to the data using the ordinary least squares (OLS) method, and write down the fitted trend line. (3 marks) (C)Denoting the in-sample fitted errors by et = yt – ŷt, find the standard error of regression () for the linear trend model and write down the formula for it (using et).(2 marks) (D)Is the fitted trend line a good one? Comment using R2 and t-test.(1 mark) (E) Based on your trend line, forecast the shipments (yt) values from Q1-2007 to Q4-2007. Also find the confidence interval for the forecast for Q4-2012. (4 marks)

2.2Estimating seasonality and making seasonal forecasts(13 marks) (F)Indicate the patterns in the above-fitted errors {et} (by plotting the data and observing the graph).(1 mark) (G)Define and write down the four quarterly dummy variables D1t, D2t, D3t and D4t.(2 marks) (H)Regress {et} on the quarterly dummy variables: et = 1D1t + 2D2t + 3D3t + 4D4t + t. Write down this new fitted-model, and briefly explain the meanings of the results.(3 marks) (I)Is this model a good one? Comment using R2 and t-test.(2 marks) (J) Based on this fitted model, forecast the et values from Q1-2007 to Q4-2007. Also find the confidence interval for the forecast for Q4-2012. (3 marks) (K)Adding up the above two forecasts [one for trend and one for errors] results in the final forecasts for yt. Write down these forecasts from Q1-2007 to Q4-2007.(2 marks) 2.3Estimating and forecasting trend and seasonality using one model(11 marks) The above two steps can be combined to form a single model to forecast yt as follows: yt = + 0t + 1D1t + 2D2t + 3D3t + t.

(L)Explain why D4t is not included into this new model.(1 mark) (M)Estimate this new model, and write down the fitted model.(2 marks) (N)Is this model a good one? Comment using R2 and t-test.(2 marks) (O)Compare this model’s fitted results with the above two models’ results, and make comments. (2 marks) (P) Based on this model, forecast the shipments (yt) values from Q1-2007 to Q4-2007. Also find the confidence interval for the forecast for Q4-2012. Are these forecasts the same as those obtained above?(4 marks) Solutions to Q1:

(A)t = 31 for 2014-Q3.(1 mark)

(B)Residual variance: = SSR / (31-2) = 725/29 = 25.(3 marks) Standard error of regression: = 251/2 = 5.(1 mark) Point forecast for 2014-Q4 (t = 32):ŷ32 = 1.62 + 3.55(32) = 115.22 billion...

Please join StudyMode to read the full document