Each week about 100 million customers€”nearly one-third of the U.S. population€”visit one of Walmart€™s U.S. stores. How does Walmart€™s revenue relate to the state of the economy in general? Before 2009, Walmart reported sales each month, but since then it has switched to quarters. Here€™s a regression table predicting Walmart€™s monthly revenue ($Billion) from the end of 2003 through the start of 2007 from the consumer price index (CPI), and a scatterplot of the relationship.

A scatterplot can give us some clues as to why they turned away from monthly reporting.

a) The points plotted with x are the December values. We can construct a variable that is €œ1€ for those four values and €œ0€ otherwise. What is such a variable called?
Here€™s the resulting regression.

b) What is the interpretation of the coefficient of the constructed variable December?
c) What additional assumption is required to include the variable December in this model? Is there reason to believe that it is satisfied?

Transcribed Image Text:

Dependent variable is: WM Revenue R-squared-11.4% R-squared (adjusted)-9.0% s 3.689 with 39 37 degrees of freedom Intercept 24.4085 19.25 CPI iable Coeff SE(Coeff) t-ratio P-value -1.27 0.2127 0.071792 0.0330 2.18 0.0358 28 24 Tx 16t 562.5 575.0 587.5 600.0 CPI Dependent variable is: WM Revenue R-squared-80.3% R-squared (adjusted)-79.2% s= 1.762 with 39-3=36 degrees of freedom SE(Coeff) t ratio P-value 0.0006 Variable Coeff Intercept 34 CPI December 10.4905 0.9337 11.2 <0.0001 7755 9.238 0.087707 0.0158 -3.76 5.55 <0.0001