TABLE 16-4 Given below are EXCEL outputs for various estimated autoregressive models for Coca-Cola's real operating revenues (in billions of dollars) from 1975 to 1998. From the data, we also know that the real operating revenues for 1996, 1997, and 1998 are 11.7909, 11.7757 and, 11.5537, respectively. AR(1) Model:
| Coefficients | Standard Error | t Stat | P-value | |
| Intercept | 0.1802077 | 0.39797154 | 0.452815546 | 0.655325119 |
| XLag1 | 1.011222533 | 0.049685158 | 20.35260757 | 0.643735615 |
AR(2) Model:
| Coefficients | Standard Error | t Stat | P-value | |
| Intercept | 0.30047473 | 0.4407641 | 0.681713257 | 0.503646149 |
| X Lag 1 | 1.17322186 | 0.234737881 | 4.998008229 | 7.98541E-05 |
| X Lag 2 | -0.183028189 | 0.030716669 | -0.730020026 | 0.034283347 |
AR(3) Model:
| Coefficients | Standard Error | t Stat | P-value | |
| Intercept | 0.313043288 | 0.514437257 | 0.608515972 | 0.550890271 |
| XLag1 | 1.173719587 | 0.246490594 | 4.761721601 | 0.000180926 |
| XLag2 | -0.069378567 | 0.373086508 | -0.185958391 | 0.004678245 |
| XLag3 | -0.122123515 | 0.282031297 | -0.433014053 | 0.30448392 |
Referring to Table 16-4 and using a 5% level of significance, what is the model that uses the most lag variables?
options:
|
linear |
|
|
AR(3) |
|
|
AR(1) |
|
|
AR(2) |
ANSWER:
In statistics and econometrics, a distributed lag model is a model for time arrangement of series of data in which a regression condition is utilized to predict current estimations of a dependent variable dependent on both the current values of a explantory variable and thelagged (past period) estimations of this explanatory variable.
AR(3) utilizes the most lag factors
REGRESSION STATISTICS Multiple R .142620229 R Square .02034053 Standard Error 20.25979924 Observations 22 Coefficients Standard Error T Stat P-Value Intercept 39.39.027309 37.24347659 1.057642216 .302826622 Attendance .340583573 .52852452 .644404489 .526635689 _______ In the table above, the proportion of the variation in "Score received on the exam" that can be explained by the variation in attendance is given by -standard error -R Square -The P-value -Intercept
Problem: (parts a, b, & C-3 points each:-part d-16 points). This problem continues on the next pagg SUMMARYOUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.913173122 0.83388515 0.832924949 13.03760503 175 CARSPENDtotal expenditure on new automobiles in the United States (s, billions) DISPOSINCnational disposable income in the United States (S, billions) ations ANOVA df MS Regression 1147618.0707 147618.0707 868.4481311 2.43543E-69 173 29406.39206 169.9791449 174 177024.4628 Coefficients Starndard Eror Stat Lower 95% Upper 95% 20.1767114 1.562143144 12.9160451 0129299790.000438759...
Table 4.1 SUMMARY OUTPUT Regression Statistics Multiple R 0.99794806 R Square Missing Adjusted R Square 0.99513164 Standard Error 1.64839211 Observations 20 ANOVA df SS MS F Significance F Regression Missing 10561.07486 Missing 1295.585 2.66E-19 Residual 16 43.47514498 2.717197 Total 19 10604.55 Coefficients Standard Error t Stat P-Value Intercept 0.562 1.327 0.424 0.677 X1 0.959 0.038 25.245 0.000 X2 1.117 0.125 8.916 0.000 X3 1.460 0.066 22.185 0.000 Consider the output shown in Table...
What is the SCL equation for your regression output?
A D 1 SUMMARY OUTPUT 2 Regression Statistics L3 4 Multiple R 5 R Square 6 Adjusted R Square 7 Standard Error 8 Observations 0.147788325 0.021841389 0.004680712 0.112847351 59 10 11 12 Coefficients Standard Error P-value 0.015008141 0.043055201 0.965808003 t Stat 13 Intercept 14 S&P 500 HPR 0.000646179 0.490477908 0.434756954 1.128165755 0.263976201 15
A D 1 SUMMARY OUTPUT 2 Regression Statistics L3 4 Multiple R 5 R Square 6 Adjusted R...
Problem 6 Part A.5 Consider the following regression output for the Single Index Model where excess returns on Microsoft Corp (MSFT) index regressed on the excess returns for the S&P500 are RMSFT ()aMFTPrsSPTRS&PS00 ()+eFT (t) S&P500 Regression Statistics Multiple R 0.5764 R Square 0.3322 Adjusted R Square 0.3302 Standard Error 3.1156 Observations 338 Coefficients Standard Error t Stat P-value 0.7064 -0.0639 0.1695 -0.3770 Intercept 0.0000 R_S&P500 0.8139 0.0629 12.9294 Interpret the regression output
Problem 6 Part A.5 Consider the following...
An economist estimates the following model: y = 6g + 61x + E. She would like to construct interval estimates for ywhen x equals 2. She estimates a modified model where y is the response variable and the explanatory variable is now defined as x = x - 2. A portion of the regression results is shown in the accompanying table. Regression Statistics R Square 0.42 Standard Error 3.86 Observations 12 Standard Coefficients Lower 95% Error t-stat p-value Upper 95%...
An economist estimates the following model: y = β0 + β1x + ε. She would like to construct interval estimates for y when x equals 2. She estimates a modified model where y is the response variable and the explanatory variable is now defined as x+ = x – 2. A portion of the regression results is shown in the accompanying table. Regression Statistics R Square 0.42 Standard Error 3.86 Observations 12 Coefficients Standard Error t-stat p-value Lower 95% Upper...
Classified ads in the local paper offered several used cars of a particular model for sale. The used car ages are measured in years and the advertised selling prices in dollars. Simple linear regression results: Dependent Variable: ad price Independent Variable: age Price_Advertised_($) = 12288.813 - 921.27273 Age_(yr) Sample size: **** R (correlation coefficient) = ****** R-sq = 0.89346768 Estimate of error standard deviation: 1218.3026 Parameter estimates: Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 12288.813 574.62041 ≠ 0...
(d) Write down the fitted simple linear regression model (equation) and discuss its merits using the following output. Consider the intercept, slope, overall goodness of model etc. when commenting. (Note that, in Excel, the time variable begins at Year 1900, i.e. 01/01/1900, 12am). [4 marks] Intercept X Variable 1 Coefficients -164070 5.736757 Standard Error t Stat P-value 28361.13278 -5.785021448 1.64E-06 0.749106082 7.65813654 6.68E-09 Lower 95% Upper 95% -221706.5175 -106433.01 4.214389946 7.2591234
She estimates the following model as Rent = β0 + β1 Bedroom + β2 Bath + β3 Sqft + ε. The following ANOVA table shows a portion of the regression results. df SS MS F Regression 3 5,694,717 1,898,239 50.88 Residual 36 1,343,176 37,310 Total 39 7,037,893 Coefficients Standard Error t-stat p-value Intercept 300 84.0 3.57 0.0010 Bedroom 226 60.3 3.75 0.0006 Bath 89 55.9 1.59 0.1195 Sqft 0.2 0.09 2.22 0.0276 The coefficient of determination indicates that ________.