2 HOURS ECONOMIC FORECASTING EXAM
The exel file for number 21 thru 25 is attached
PLEASE MINITAB 6 WILL BE NEEDED
FOR ARCHMAGE ONLY
Problem 22
Month | Monthy Truck | Sales | Data for Exam 2 Problem 22 through 25 | |||||||||||||||||||||||||||||||||
Jan | 135 | |||||||||||||||||||||||||||||||||||
Feb | 131 | |||||||||||||||||||||||||||||||||||
Mar | 139 | |||||||||||||||||||||||||||||||||||
Apr | ||||||||||||||||||||||||||||||||||||
May | 134 | |||||||||||||||||||||||||||||||||||
Jun | ||||||||||||||||||||||||||||||||||||
Jul | ||||||||||||||||||||||||||||||||||||
Aug | 136 | |||||||||||||||||||||||||||||||||||
Sep | ||||||||||||||||||||||||||||||||||||
Oct | 133 | |||||||||||||||||||||||||||||||||||
Nov | ||||||||||||||||||||||||||||||||||||
Dec | 137 | |||||||||||||||||||||||||||||||||||
138 | ||||||||||||||||||||||||||||||||||||
140 | ||||||||||||||||||||||||||||||||||||
142 | ||||||||||||||||||||||||||||||||||||
144 | ||||||||||||||||||||||||||||||||||||
141 | ||||||||||||||||||||||||||||||||||||
132 | ||||||||||||||||||||||||||||||||||||
129 | ||||||||||||||||||||||||||||||||||||
130 | ||||||||||||||||||||||||||||||||||||
Problem 21
Quarter | Data for Exam 2 Problem 21 | ||||
Q1 | 152 | ||||
Q2 | 262 | ||||
Q3 | 273 | ||||
Q4 | 250 | ||||
225 | |||||
258 | |||||
143 | |||||
246 | |||||
299 | |||||
287 | |||||
169 | |||||
223 | |||||
394 | |||||
Sheet3
Exam 2
Class,
This exam consists of 25 multiple choice questions and problems. Be sure to answer every question and complete the exam within the 2 hour time limit. This exam must be completed by Sunday, November 10 at midnight when it closes since there will be no make-up exams or time extensions. Take the test in a single session to avoid losing your answers. The data for the exam can be found in Doc Sharing under Exam 2 Data in excel format. Download it into Mintab to complete the problems as required. Be sure to make this exam your own work.
Question 1.1. What are at lest two diagnostic checks you should apply to a Box-Jenkins model to determine its reliability (excluding error measures such as MSE, RMSE, etc.)? (Points : 3.5)
t-test of the coefficients and residual lag Chi-square values. Question 2.2. The “I” in the ARIMA technique represents (Points : 3.5) the minimum error that is generated by the Moving Average process. Question 3.3. Given the following Chi-Square statistics from and ARIMA model at 95% confidence the residuals are not significantly autoregressive only through the 12th lag. Question 4.4. The AR and MA and ARMA model forms can be applied to data with what major requirements? (Points : 3.5) Adequate time series data. Question 5.5. What two autoregressive statistics are used to determine the type of ARIMA model that may be appropriate? (Points : 3.5) standard deviation and variance Question 6.6. A second order MA model implies that (Points : 3.5) the autocorrelation function of the data has two significant early lags. Question 7.7. Given an ARIMA model of monthly data described by the menu (1,3,0)(2,2,0) how many data observations will be lost due to differencing to make the series stationary? (Points : 3.5) 24 Question 8.8. Natural log data transformation is useful because it (Points : 3.5) enables ARIMA to be run with fewer observations. Question 9.9. A data series required one seasonal difference and two non seasonal differences to make it stationary. You have found two early spikes in the partial autocorrelation function after the non seasonal differences with converging autocorrelations. In addition you found one early lag spike in the autocorrelation function for the seasonal differenced data along with converging partial autocorrelations. Which is the appropriate ARIMA menu for the model? (Points : 3.5) (1,0, 1)(2,2,0) Question 10.10. The major disadvantages of differencing to make data stationary include (Points : 3.5) Observations (degrees of freedom) will be lost and it requires a large amount of data. Question 11.11. What is the rule of parsimony in ARIMA forecasting? (Points : 3.5) Better forecast results can be obtained from more complex ARIMA models Question 12.12. Given the ARIMA menus below which will result in 4 model coefficients excluding a constant term? (Points : 3.5) (1,1,2)(2,1,0) Question 13.13. In an ARIMA model with monthly data how many coefficients (excluding the constant term) are in the ARIMA model specified as (1,1,2)(0,1,1) and how many observations are 3 coefficients and 5 observations lost Question 14.14. Which ARIMA model type is used to derive forecasts of a variable based only on a linear function of its past data values? (Points : 3.5) a moving average model Question 15.15. The Chi-Square values in ARIMA results determine the (Points : 3.5) need for additional differencing. Question 16.16. Autocorrelations differ from partial autocorrelations in that (Points : 3.5) autocorrelation is the total effect correlation between lag values of a time series that could include previous lag autoregressive effects while partial autocorrelation is the direct correlation only between the specific lag value and the data observation. Question 17.17. You have a quarterly data series ACFs and the first four autocorrelation are significantly different from zero while the subsequent autocorrelations decreases slowly toward zero. In addition the autocorrelations for lag 8, 12 and 16 are significantly different from zero. What are your data autoregressive characteristics? (Points : 3.5) trend and cycle Question 18.18. In the standard ARIMA menu notation what does P stand for? (Points : 3.5) The measure of the probability of residuals equal to zero Question 19.19. What is the value of the coefficient if the standard error of the coefficient is 1.25 and the t-value is 2.80? (Points : 3.5) 3.5 Question 20.20. Some ARIMA models do not require a constant term. What determines the need for it? (Points : 3.5) The t-value of the coefficients. Question 21.21. Given the data found in DocSharing under Exam 2 Data Problem 21 what is the first differenced value of the second seasonal difference of the sales data? (Take 2 seasonal differences) (Points : 6) 110 Question 22.22. Given the following data for monthly pickup truck sales for a large Texas dealership. Determine the best ARIMA model to apply and select the menu for the model in (0,0,0)(0,0,0) form. (Remember that I will only accept this ARIMA model with non-significant residuals.) (0,1,0)(1,1,1) an Seasonal ARMA model with one seasonal difference and a MA1 model with one non seasonal difference Question 23.23. What are the significant coefficient(s) of the best ARIMA model found in the question above excluding the constant term? (Points : 6) .3833, .2930 and -.3209 Question 24.24. What is the fit period MAPE of the best ARIMA model? (Points : 6) 2.503 Question 25.25. What is the forecast value for the 6th month from the end of the data series? Develop a forecast with the best ARIMA model—then choose the value for the 6the month. (Points : 6) 353.234 |
Time Remaining: |