Walmart Revenue Case Study (Linear Regression Modeling)

Walmart Revenue Case Study (Linear Regression Modeling).

I need support with this Excel question so I can learn better.

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-Mart’s 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.
  • 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.

Identify and remove the four cases corresponding to December revenue.

INSTRUCTIONS

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.

  • 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).
  • to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.

Walmart Revenue Case Study (Linear Regression Modeling)

"Looking for a Similar Assignment? Order now and Get a Discount!