MBA 6022-Wal-Mart is the second largest retailer in the world

Question # 00568674 Posted By: rey_writer Updated on: 07/31/2017 07:00 AM Due on: 07/31/2017
Subject Statistics Topic General Statistics Tutorials:
Question
Dot Image

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.

  1. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
  2. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
  3. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
  4. 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.

  1. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.
  2. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.
  3. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.
  4. Which of these three models is the best? Use R-square values and Significance F values to explain your answer.
  5. 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 the 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.

Dot Image
Tutorials for this Question
  1. Tutorial # 00566362 Posted By: rey_writer Posted on: 07/31/2017 07:01 AM
    Puchased By: 5
    Tutorial Preview
    The solution of MBA 6022-Wal-Mart is the second largest retailer in the world...
    Attachments
    Walmart.docx (14.84 KB)
    WalMart_revenue.xlsx (20.76 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    a...e3k Rating Impressive homework help services 09/13/2018
    F...in Rating Interactive and easily understandable tutorials 05/29/2018
    do...09 Rating Late-night online help available 04/01/2018

Great! We have found the solution of this question!

Whatsapp Lisa