- UID
- 223322
- 帖子
- 613
- 主题
- 115
- 注册时间
- 2011-7-11
- 最后登录
- 2013-6-27
|
45#
发表于 2012-3-27 10:21
| 只看该作者
Manuel Mercado, CFA has performed the following two regressions on sales data for a given industry. He wants to forecast sales for each quarter of the upcoming year.Model ONE | Regression Statistics | Multiple R | 0.941828 | R2 | 0.887039 | Adjusted R2 | 0.863258 | Standard Error | 2.543272 | Observations | 24 |
Durbin-Watson test statistic = 0.7856ANOVA | | df | SS | MS | F | Significance F | Regression | 4 | 965.0619 | 241.2655 | 37.30006 | 9.49E−09 | Residual | 19 | 122.8964 | 6.4682 | | | Total | 23 | 1087.9583 | | | |
| Coefficients | Standard Error | t-Statistic | Intercept | 31.40833 | 1.4866 | 21.12763 | Q1 | −3.77798 | 1.485952 | −2.54246 | Q2 | −2.46310 | 1.476204 | −1.66853 | Q3 | −0.14821 | 1.470324 | −0.10080 | TREND | 0.851786 | 0.075335 | 11.20848 |
Model TWO | Regression Statistics | Multiple R | 0.941796 | R2 | 0.886979 | Adjusted R2 | 0.870026 | Standard Error | 2.479538 | Observations | 24 |
Durbin-Watson test statistic = 0.7860 | df | SS | MS | F | Significance F | Regression | 3 | 964.9962 | 321.6654 | 52.3194 | 1.19E−09 | Residual | 20 | 122.9622 | 6.14811 | | | Total | 23 | 1087.9584 | | | |
| Coefficients | Standard Error | t-Statistic | Intercept | 31.32888 | 1.228865 | 25.49416 | Q1 | −3.70288 | 1.253493 | −2.95405 | Q2 | −2.38839 | 1.244727 | −1.91881 | TREND | 0.85218 | 0.073991 | 11.51732 |
The dependent variable is the level of sales for each quarter, in $ millions, which began with the first quarter of the first year. Q1, Q2, and Q3 are seasonal dummy variables representing each quarter of the year. For the first four observations the dummy variables are as follows: Q11,0,0,0), Q20,1,0,0), Q30,0,1,0). The TREND is a series that begins with one and increases by one each period to end with 24. For all tests, Mercado will use a 5% level of significance. Tests of coefficients will be two-tailed, and all others are one-tailed.Which model would be a better choice for making a forecast? A)
| Model TWO because serial correlation is not a problem. |
| B)
| Model ONE because it has a higher R2. |
| C)
| Model TWO because it has a higher adjusted R2. |
|
Model TWO has a higher adjusted R2 and thus would produce the more reliable estimates. As is always the case when a variable is removed, R2 for Model TWO is lower. The increase in adjusted R2 indicates that the removed variable, Q3, has very little explanatory power, and removing it should improve the accuracy of the estimates. With respect to the references to autocorrelation, we can compare the Durbin-Watson statistics to the critical values on a Durbin-Watson table. Since the critical DW statistics for Model ONE and TWO respectively are 1.01 (>0.7856) and 1.10 (>0.7860), serial correlation is a problem for both equations. (Study Session 3, LOS 12.f)
Using Model ONE, what is the sales forecast for the second quarter of the next year?
The estimate for the second quarter of the following year would be (in millions): 31.4083 + (−2.4631) + (24 + 2) × 0.851786 = 51.091666. (Study Session 3, LOS 12.c)
Which of the coefficients that appear in both models are not significant at the 5% level in a two-tailed test? A)
| The coefficients on Q1 and Q2 only. |
| B)
| The coefficient on Q2 only. |
| |
The absolute value of the critical T-statistics for Model ONE and TWO are 2.093 and 2.086, respectively. Since the t-statistics for Q2 in Models ONE and TWO are −1.6685 and −1.9188, respectively, these fall below the critical values for both models. (Study Session 3, LOS 12.a)
If it is determined that conditional heteroskedasticity is present in model one, which of the following inferences are most accurate? A)
| Regression coefficients will be biased but standard errors will be unbiased. |
| B)
| Both the regression coefficients and the standard errors will be biased. |
| C)
| Regression coefficients will be unbiased but standard errors will be biased. |
|
Presence of conditional heteroskedasticity will not affect the consistency of regression coefficients but will bias the standard errors leading to incorrect application of t-tests for statistical significance of regression parameters. (Study Session 3, LOS 12.i)
Mercado probably did not include a fourth dummy variable Q4, which would have had 0, 0, 0, 1 as its first four observations because: A)
| it would have lowered the explanatory power of the equation. |
| B)
| the intercept is essentially the dummy for the fourth quarter. |
| C)
| it would not have been significant. |
|
The fourth quarter serves as the base quarter, and for the fourth quarter, Q1 = Q2 = Q3 = 0. Had the model included a Q4 as specified, we could not have had an intercept. In that case, for Model ONE for example, the estimate of Q4 would have been 31.40833. The dummies for the other quarters would be the 31.40833 plus the estimated dummies from the Model ONE. In a model that included Q1, Q2, Q3, and Q4 but no intercept, for example: Q1 = 31.40833 + (−3.77798) = 27.63035 Such a model would produce the same estimated values for the dependent variable. (Study Session 3, LOS 12.h)
If Mercado determines that Model TWO is the appropriate specification, then he is essentially saying that for each year, value of sales from quarter three to four is expected to: A)
| remain approximately the same. |
| B)
| grow, but by less than $1,000,000. |
| C)
| grow by more than $1,000,000. |
|
The specification of Model TWO essentially assumes there is no difference attributed to the change of the season from the third to fourth quarter. However, the time trend is significant. The trend effect for moving from one season to the next is the coefficient on TREND times $1,000,000 which is $852,182 for Equation TWO. (Study Session 3, LOS 13.a) |
|