Question
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 data zip
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 data zip file in week one, and it holds monthly data on Wal-Marts revenue, along with several possibly related economic variables.
Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
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.
Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
Which of these three models is the best? Use R-square values and Significance F values to explain your answer.
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.
Please use one Excel file to complete this problem, and use one sheet for one sub-problem. Use a Microsoft Word document to answer questions. Finally, upload the files to the submission link for grading.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started