Wal-Mart Revenue: Case Study Two 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. (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) Plot the residuals against the predicted values and comment on what you see. (c) Does it seem that Wal-Mart's revenue is closely related to the general state of the economy? Identify and remove the four cases corresponding to December revenue. (d) Develop a multiple linear regression model to predict Wal-Mart revenue, using CPI, Personal Consumption, and Retail Sales Index as the independent variables. (e) Plot the residuals against the predicted values and comment on what you see. (f) Does it seem that Wal-Mart's revenue is closely related to the general state of the economy? (g) Comparing the results of parts (a) and (d), which of these two models is better? Use Rsquare values, adjusted R-square values, Significance F values, p-values and other appropriate criteria to explain your answer. Please use one Excel file to complete this problem, and use one sheet for one sub-problem. Use a Microsoft Word document to answer questions. Finally, upload the file to the submission link for grading