Statistic Case Study needed with 24hours

in /by

Statistic Case Study needed with 24hours

DUE IN 24 HOURS!!!!Please use one Excel file to complete this case study, and use one spreadsheet for one problem.Finally, upload the Excel file to the submission link for grading.No credit will be granted for problems that are not completed using Excel.

Wal-Mart is the second largest retailer in the world.The data file (Wal-Mart Revenue 2003-2008.xlsx) is posted below the case study one file, 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 values, Significance F values, p-values and other appropriate criteria to explain your answer.
  • Generate a residual plot and a line fit plot for the best model in part (d) and comment on what you see.
  • 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, Significance F values, p-values and other appropriate criteria to explain your answer.
  • Generate a residual plot and a line fit plot for the best model in part (i) and comment on what you see.
  • Comparing the results of parts (d) and (i), which of these two models is better?Use R-square values, Significance F values, p-values and plots to explain your answer.

Identify and remove the five cases corresponding to December revenue.

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30


Click ORDER NOW..

order custom paper