Here€™s a regression of monthly revenue of Wal-Mart Corp, relating that revenue to the Total U.S. Retail Sales, the Personal Consumption Index, and the Consumer Price Index.
Dependent variable is: Wal-Mart_Revenue
R squared = 66.7% R squared (adjusted) = 63.8%
s = 2.327 with 39 - 4 = 35 degrees of freedom

a) Write the regression model.
b) Interpret the coefficient of the Consumer Price Index (CPI). Does it surprise you that the sign of this coefficient is negative? Explain.
c) Test the standard null hypothesis for the coefficient of CPI and state your conclusions.

Transcribed Image Text:

Dependent variable s: Wal-Mart Revenue R squared-66.7% R squared (adjusted)-63.8% s= 2.327 with 39-4=35 degrees of freedom Source Regression 378.749 Residua 189.474 Sum of Squares df Mean Square F-ratio 3 126.250 35 5.41354 23.3 Variable Coeff Intercept 87.0089 Retail SE(Coeff) t-ratio P-value 0.0139 0.000015 6.67 <0.0001 0.0165 33.60 2.59 Sales 0.000103 Persnl Consmp 0.00001108 0.000004 2.52 CPI -0.344795 0.1203 -2.87 0.0070 2.5 0.0 -2.5 -1.25 0.00 1.25 Nscores