Case Study Two: WalMa Revenue Due Date: 06:95 Please use DNLY one Excel file to complete this case study, and use one tab for each p Finally, upload the Excel file to the submission link (Week 6 case study} for grading. will he granted for problems that are not completed using Excel. WalMart is the second largest retailer in the world. The data le MalMart Revenue data.xlsx} is posted below the case study two tile, and it holds monthly data on WalM revenue, along with several possibly related economic variables. {a} Develop a multiple linear regression model to predict WalMart revenue, using Personal Consumption, and Retail Sales Index as the independent variables. Y need to create residual plots and scatter plots by selecting residual plots box an plots box under \"Residuals\". Note: Those plots are for the individual independ variables. (b) To generate the residual plot for the entire model, you need to follow the instru below. Check the Residuals box under \"Residuals\" and Excel will generate pr values and residuals at the bottom of the output for the multiple regression mo highlight these two output values to create the residual plot hy Excel's scatter c [Insert tab is Charm 3- Scatter chart}. Comment on what you see on the plot. N residual plot is for the entire model. (c) Does it seem that WalMart's revenue is closely related to the general state of economy? Use all the plots and statistical criteria on the Regression Analysis o generated by Excel to explain it. Identify and male those six cases corresponding to December revenue. Then, use data set (without the December data) to complete the following problems. {d} Develop a multiple linear regression model to predict WalMart revenue, using Personal Consumption, and Retail Sales Index as the independent variables. Y need to create residual plots and scatter plots by selecting residual plots box an plots box under \"Residuals\". Note: Those plots are for the individual independ variables. (e) Check the Residuals box under \"Residuals\" and Excel will generate predicted residuals at the bottom of the output for the multiple regression model. Then, these two output values to create the residual plot by Excel's scatter chart [htse Charts } Scatter chart]. Comment on what you see on the plot. Note: This resi is for the entire model. {f} Does it seem that Wall'vlart's revenue is closely related to the general state of