- UID
- 223331
- 帖子
- 289
- 主题
- 53
- 注册时间
- 2011-7-11
- 最后登录
- 2014-2-27
|
76#
发表于 2012-3-26 14:18
| 只看该作者
Rebecca Anderson, CFA, has recently accepted a position as a financial analyst with Eagle Investments. She will be responsible for providing analytical data to Eagle’s portfolio manager for several industries. In addition, she will follow each of the major public corporations within each of those industries. As one of her first assignments, Anderson has been asked to provide a detailed report on one of Eagle’s current investments. She was given the following data on sales for Company XYZ, the maker of toilet tissue, as well as toilet tissue industry sales ($ millions). She has been asked to develop a model to aid in the prediction of future sales levels for Company XYZ. She proceeds by recalling some of the basic concepts of regression analysis she learned while she was preparing for the CFA exam.Year | Industry Sales (X) | Company Sales (Y) | (X-X)2 | 1 | $3,000 | $750 | 84,100 | 2 | $3,200 | $800 | 8,100 | 3 | $3,400 | $850 | 12,100 | 4 | $3,350 | $825 | 3,600 | 5 | $3,500 | $900 | 44,100 | Totals | $16,450 | $4,125 | 152,000 |
Coefficient Estimates |
Predictor | Coefficient | Stand. Error of
the Coefficient | t-statistic |
Intercept | -94.88 | 32.97 | ?? |
Slope (Industry Sales) | 0.2796 | 0.0363 | ?? |
Analysis of Variance Table (ANOVA) |
Source | df
(Degrees of Freedom) | SS
(Sum of Squares) | Mean Square (SS/df) | F-statistic |
Regression | 1 (# of independent variables) | 11,899.50 (SSR) | 11,899.50 (MSR) | 59.45 |
Error | 3 (n-2) | 600.50 (SSE) | 200.17 (MSE) |
|
Total | 4 (n-1) | 12,500 (SS Total) |
|
|
Abbreviated Two-tailed t-table | df | 10% | 5% | 2 | 2.920 | 4.303 | 3 | 2.353 | 3.182 | 4 | 2.132 | 2.776 |
Standard error of forecast is 15.5028.Which of the following is the correct value of the correlation coefficient between industry sales and company sales?
The R2 = (SST − SSE) / SST = (12,500 − 600.50) / 12,500 = 0.952
The correlation coefficient is √R2 in a simple linear regression, which is √0.952 = 0.9757. (Study Session 3, LOS 11.a)
Which of the following reports the correct value and interpretation of the R2 for this regression? The R2 is: A)
| 0.048, indicating that the variability of industry sales explains about 4.8% of the variability of company sales. |
| B)
| 0.952, indicating the variability of company sales explains about 95.2% of the variability of industry sales. |
| C)
| 0.952, indicating that the variability of industry sales explains about 95.2% of the variability of company sales. |
|
The R2 = (SST − SSE) / SST = (12,500 − 600.50) / 12,500 = 0.952
The interpretation of this R2 is that 95.2% of the variation in company XYZ's sales is explained by the variation in tissue industry sales. (Study Session 3, LOS 11.a)
What is the predicted value for sales of Company XYZ given industry sales of $3,500?
The regression equation is Y = (−94.88) + 0.2796 × X = −94.88 + 0.2796 × (3,500) = 883.72. (Study Session 3, LOS 11.h)
What is the upper limit of a 95% confidence interval for the predicted value of company sales (Y) given industry sales of $3,300?
The predicted value is Ŷ = −94.88 + 0.2796 × 3,300 = 827.8.
The upper limit for a 95% confidence interval = Ŷ + tcsf = 827.8 + 3.182 × 15.5028 = 827.8 + 49.33 = 877.13.
The critical value of tc at 95% confidence and 3 degrees of freedom is 3.182.
(Study Session 3, LOS 11.h)
What is the lower limit of a 95% confidence interval for the predicted value of company sales (Y) given industry sales of $3,300?
The predicted value is Ŷ = -94.88 + 0.2796 × 3,300 = 827.8.
The lower limit for a 95% confidence interval = Ŷ − tcsf = 827.8 − 3.182 × 15.5028 = 827.8 − 49.33 = 778.47.
The critical value of tc at 95% confidence and 3 degrees of freedom is 3.182.
(Study Session 3, LOS 11.h)
What is the t-statistic for the slope of the regression line?
Tb = (b1hat − b1) / sb1 = (0.2796 − 0) / 0.0363 = 7.7025. (Study Session 3, LOS 11.g) |
|