Pls use EXCEL..Identify and remove the six cases corresponding to December revenue.Then, use the new data set (without the December data) to complete the following problems.

(a)Develop a multiple linear regression model to predict Wal-Mart revenue, using CPI, Personal Consumption, and Retail Sales Index as the independent variables.You also need to create residual plots, scatter plots and normal probability plots by selecting residual plots box and line fit plots box under "Residuals", and normal probability plots box under "Normal Probability".Note: Those plots are for the individual 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.Note: This residual plot is for the entire model.

(c)Does it seem that Wal-Mart's revenue is closely related to the general state of the economy?Use all plots and statistical criteria on the Excel Regression output to explain it.

(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 plots, residual plots and normal probability plots to explain your answer.

Date Wal Mart Personal Retail Sales Revenue CPI Consumption Index December 11/28/2003 14.764 552.7 7868495 301337 0 12/30/2003 23.106 552.1 7885264 357704 1 1/30/2004 12.131 554.9 7977730 281463 0 2/27/2004 13.628 557.9 8005878 282445 0 3/31/2004 16.722 561.5 8070480 319107 0 4/29/2004 13.98 563.2 8086579 315278 0 5/28/2004 14.388 566.4 8196516 328499 0 6/30/2004 18.111 568.2 8161271 321151 0 7/27/2004 13.764 567.5 8235349 328025 0 8/27/2004 14.296 567.6 8246121 326280 0 9/30/2004 17.169 568.7 8313670 313444 0 10/29/2004 13.915 571.9 8371605 319639 0 11/29/2004 15.739 572.2 8410820 324067 0 12/31/2004 26.177 570.1 8462026 386918 1 1/21/2005 13.17 571.2 8469443 293027 0 2/24/2005 15.139 574.5 8520687 294892 0 3/30/2005 18.683 579 8568959 338969 0 4/29/2005 14.829 582.9 8654352 335626 0 5/25/2005 15.697 582.4 8644646 345400 0 6/28/2005 19.23 582.6 8724753 351068 0 7/28/2005 17.26 580.2 8833907 351887 0 8/26/2005 15.709 588.2 8825450 355897 0 9/30/2005 18.618 595.4 8882536 333652 0 10/31/2005 15.397 596.7 8911627 336662 0 11/28/2005 17.384 592 8916377 344441 0 12/30/2005 27.92 589.4 8955472 406510 1 1/27/2006 14.555 593.9 9034368 322222 0 2/23/2006 18.684 595.2 9079246 318184 0 3/31/2006 16.639 598.6 9123848 366989 0 4/28/2006 20.17 603.5 9175181 357334 0 5/25/2006 16.901 606.5 9238576 380085 0 6/30/2006 21.47 607.8 9270505 373279 0 7/28/2006 16.542 609.6 9338876 368611 0 8/29/2006 16.98 610.9 9352650 382600 0 9/28/2006 18.091 607.9 9368494 352686 0 10/20/2006 16.583 604.6 9376027 354740 0 11/24/2006 18.761 603.6 9410758 363468 0 12/29/2006 28.795 604.5 9478531 424946 1 1/26/2007 20.473 606.348 9540335 332797 0 2/23/2007 20.984 611.2 9539246 327686 0 3/30/2007 18.939 614.9 9583848 376491 0 4/27/2007 22.47 619.8 9635181 366936 0 5/25/2007 19.201 622.8 9698576 389687 0 6/29/2007 23.77 623.9 9731285 382781 0 7/27/2007 18.942 625.6 9799656 378113 0 8/31/2007 19.38 626.9 9813630 392125 0 9/28/2007 22.491 623.9 9809274 362211 0 10/26/2007 18.983 621.6 9836807 364265 0 11/30/2007 21.161 620.6 9870758 372970 0 12/28/2007 31.245 622.5 9946331 434488 1 1/25/2008 22.923 623.35 10008141 342422 0 2/29/2008 21.512 622.28 10032148 344464 0 3/28/2008 22.023 626.9 10030959 339463 0 4/25/2008 20.178 631.2 10075561 388158 0 5/30/2008 23.509 636.1 10126994 378653 0 6/27/2008 21.24 638.7 10190289 401354 0 7/25/2008 24.809 640.2 10223995 394488 0 8/29/2008 20.981 641.9 10291369 389780 0 9/26/2008 20.419 643.2 10305343 403812 0 10/31/2008 23.53 641.2 10301087 373978 0 11/28/2008 21.022 637.9 10328520 375932 0 12/26/2008 23.2 636.9 10362495 384677 0 1/30/2009 32.784 637.8 10438041 446195 1 2/27/2009 23.962 639.65 10499948 353997 0 3/27/2009 22.951 638.948 10523764 356183 0 4/24/2009 24.062 643.7 10522721 351032 0