Develop a multiple linear regression model to predict Wal-Mart revenue,

please see the attached word file for the rubric, and excel file for data you need to use. the assignment has to be done by excel.

• Develop a multiple linear regression model to predict Wal-Mart revenue, using CPI, Personal Consumption, and Retail Sales Index as the independent variables.
• Check the residuals box under residuals and Excel will generate predicted values and residuals at the bottom of the output for the multiple regression model.Then, use these two output values to create the residual plot by Excel’s scatter chart (Insert tab > Charts > Scatter chart).Comment on what you see on the plot.
• Does it seem that Wal-Mart’s revenue is closely related to the general state of the economy?Explain it.
• Identify and remove the five cases corresponding to
  December revenue.

  (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) Check
  the residuals box under residuals and Excel will generate predicted values and
  residuals at the bottom of the output for the multiple regression model. Then, use these two output values to create
  the residual plot by Excel’s scatter chart (Insert tab > Charts > Scatter
  chart). Comment on what you see on the
  plot.

  (c) Does
  it seem that Wal-Mart’s revenue is closely related to the general state of the
  economy?

  (d) Compare
  the results of parts (a) and (d), which of these two models is better? Use R-square values, adjusted R-square
  values, Significance F values, p-values, scatter plot, residual plot and normal
  probability plot to explain your answer.

  (e) Compare
  the results of parts (a) and (d), what can you conclude about the impact of December
  data to Wal-Mart Revenue?