Review Simple Regression Models Case Study: Mystery shoppers for this topics case study, a request to evaluate consignment stores from mystery shopper data. Based on the information presented in the case study, create a regression model to determine the most appropriate recommendation. Prepare a 250-500 word response to Mrs. Turner's questions about predicting final scores, statistical significance, and whether a store location should be closed based on the data provided. Explain the approach and rationale for this model. Evaluate the outcomes of the regression model and the responses to Mrs. Turner's questions. Provide a copy of the Excel spreadsheet used to design the regression model and determine statistical significance. (Use Excel's regression option to perform the regression). Use Excel spreadsheet for the calculations and explanations. Cells should contain the formulas used to calculate the entry in the cell) Prepare the written portion of this assignment according to APY Style Guide, an abstract is not required