Answered You can hire a professional tutor to get the answer.
Wal-Mart Revenue: Case Study One Wal-Mart is the second largest retailer in the world. The data file (WalMart_revenue.xlsx) is included in the Excel...
Hello,
Please look into the attached document to resolve the case study.
Wal-Mart is the second largest retailer in the world. The data file (WalMart_revenue.xlsx) is included in the Excel data zip file in week one, and it holds monthly data on Wal-Mart's revenue, along with several possibly related economic variables.
(a) Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
(b) Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
(c) Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
(d) Which of these three models is the best? Use R-square value, Significance F values and other appropriate criteria to explain your answer.
Identify and remove the four cases corresponding to December revenue.
(e) Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
(f) Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
(g) Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
(h) Which of these three models is the best? Use R-square values and Significance F values to explain your answer.
(i) Comparing the results of parts (d) and (h), which of these two models is better? Use R-square values, Significance F values and other appropriate criteria to explain your answer.
- Attachment 1
- Attachment 2