Wal-Mart Revenue: Case Study Two
Question # 00547867
Posted By:
Updated on: 06/17/2017 05:41 AM Due on: 06/17/2017
Wal-Mart Revenue: Case Study Two 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 multiple linear regression model to predict Wal-Mart revenue, using CPI,
Personal Consumption, and Retail Sales Index as the independent variables.
(b) Plot the residuals against the predicted values and comment on what you see.
(c) Does it seem that Wal-Mart’s revenue is closely related to the general state of the
economy?
Identify and remove the four cases corresponding to December revenue.
(d) Develop a multiple linear regression model to predict Wal-Mart revenue, using CPI,
Personal Consumption, and Retail Sales Index as the independent variables.
(e) Plot the residuals against the predicted values and comment on what you see.
(f) Does it seem that Wal-Mart’s revenue is closely related to the general state of the
economy?
(g) Comparing the results of parts (a) and (d), which of these two models is better? Use Rsquare values, adjusted R-square values, Significance F values, p-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 file to the submission link
for grading.
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 multiple linear regression model to predict Wal-Mart revenue, using CPI,
Personal Consumption, and Retail Sales Index as the independent variables.
(b) Plot the residuals against the predicted values and comment on what you see.
(c) Does it seem that Wal-Mart’s revenue is closely related to the general state of the
economy?
Identify and remove the four cases corresponding to December revenue.
(d) Develop a multiple linear regression model to predict Wal-Mart revenue, using CPI,
Personal Consumption, and Retail Sales Index as the independent variables.
(e) Plot the residuals against the predicted values and comment on what you see.
(f) Does it seem that Wal-Mart’s revenue is closely related to the general state of the
economy?
(g) Comparing the results of parts (a) and (d), which of these two models is better? Use Rsquare values, adjusted R-square values, Significance F values, p-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 file to the submission link
for grading.
Complete Case study two . You will be expected to:
- perform certain calculations discussed in the assigned reading in order to derive an answer for each problem.
- use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.
- have each worksheet be clearly labeled to identify the associated problem.to show all calculations or other work performed to derive your answer(s) for each problem.
- have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).
-
Rating:
/5
Solution: Wal-Mart Revenue: Case Study Two