Excel Problem Walmart Inc. has made historical sales data available for 45 stores located in different regions throughout the United States. Go to the student download page at http://www.pearsonhighered.com/romney and download the files labeled

“WalmartSales.csv” and “WalmartFeatures.csv”.

REQUIRED

Using this data, answer the question “which elements best explain why department sales differ?” To do this, compute the following regression models. For each model, interpret the output for each variable and discuss the important business insights you can derive from the model results (Hint: be careful in setting up the data that you transform it correctly).

a. Regress total sales for each department on unemployment.

b. Regress weekly sales data on temperature, fuel prices, CPI, unemployment, and IsHoliday.