create a regression model to determine the most appropriate recommendation.

Review “Simple Regression Models Case Study: Mystery Shoppers” for this topic’s 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 your approach and the rationale for this method. Evaluate the outcomes of your regression model and the responses to Mrs. Turner’s questions.

Submit a copy of the Excel spreadsheet file you used to design your regression model and to determine statistical significance.

Note: Students should use Excel’s regression option to perform the regression.

Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell).

Mac users can use Stat Plus: mac LE, free of charge, from Analyst Soft.

Stat Plus: mac LE can be used with Excel 2011 to perform statistical functions.

Go to the Analyst Soft website and follow the installation instructions: http://www.analystsoft.com/en/products/statplusmacle/.

Once installed, Apple users can use Stat Plus: mac LE to complete homework problems that require the use of Excel’s data analysis statistical functions.

Prepare the written portion of this assignment according to the guidelines found in the APA Style Guide. An abstract is not required.

This assignment uses a rubric (SEE BELOW). Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

RUBRIC

Simple Regression Models Case Study: Mystery Shoppers

  1 Unsatisfactory 0.00% 2 Less than Satisfactory 74.00% 3 Satisfactory 79.00% 4 Good 87.00% 5 Excellent 100.00%
70.0 %Content  
15.0 % Predict Final Scores and Statistical Significance A prediction of final scores and the statistical significance is not included. A prediction of final scores and the statistical significance is present, but it is inaccurate or incomplete. A basic prediction of final scores and the statistical significance is present. A prediction of final scores and the statistical significance is clearly provided and well-developed. A precise prediction of final scores and the statistical significance is thoroughly developed with supporting details.
15.0 % Recommend Whether Store Location Should be Closed A recommendation of whether a particular store location should be closed is not included. A recommendation of whether a particular store location should be closed is included, but it lacks detail or is incomplete. A recommendation of whether a particular store location should be closed is included. A clear recommendation of whether a particular store location should be closed is provided and well-developed. A comprehensive recommendation of whether a particular store location should be closed is thoroughly developed with supporting details.
15.0 % Explain Approach and Rationale An explanation of the approach and rationale for method used to provide predictions and recommendation is not included. An explanation of the approach and rationale for method used to provide predictions and recommendation is included, but it lacks detail or is incomplete. An explanation of the approach and rationale for method used to provide predictions and recommendation is included. A clear explanation of the approach and rationale for method used to provide predictions and recommendation is included. A comprehensive explanation of the approach and rationale for method used to provide predictions and recommendation is thoroughly developed with supporting details.
15.0 % Evaluate Outcomes of Regression Model An evaluation of the outcomes of the selected regression model and responses to questions from Mrs. Turner is not included. An evaluation of the outcomes of the selected regression model and responses to questions from Mrs. Turner is included, but it lacks detail or is incomplete. An evaluation of the outcomes of the selected regression model and responses to questions from Mrs. Turner is included. A complete evaluation of the outcomes of the selected regression model and responses to questions from Mrs. Turner is included. A comprehensive evaluation of the outcomes of the selected regression model and responses to questions from Mrs. Turner is thoroughly developed with supporting details.
10.0 % Excel Spreadsheet A copy of the Excel spreadsheet file used to design the regression model and to determine statistical significance is not included. A copy of the Excel spreadsheet file used to design the regression model and to determine statistical significance is included but lacks accuracy or is incomplete. A copy of the Excel spreadsheet file used to design the regression model and to determine statistical significance is included. A complete copy of the Excel spreadsheet file used to design the regression model and to determine statistical significance is included. A detailed and accurate copy of the Excel spreadsheet file used to design the regression model and to determine statistical significance is included.
20.0 %Organization and Effectiveness  
7.0 % Thesis Development and Purpose Paper lacks any discernible overall purpose or organizing claim. Thesis is insufficiently developed or vague. Purpose is not clear. Thesis is apparent and appropriate to purpose. Thesis is clear and forecasts the development of the paper. Thesis is descriptive and reflective of the arguments and appropriate to the purpose. Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear.
8.0 % Argument Logic and Construction Statement of purpose is not justified by the conclusion. The conclusion does not support the claim made. Argument is incoherent and uses noncredible sources. Sufficient justification of claims is lacking. Argument lacks consistent unity. There are obvious flaws in the logic. Some sources have questionable credibility. Argument is orderly, but may have a few inconsistencies. The argument presents minimal justification of claims. Argument logically, but not thoroughly, supports the purpose. Sources used are credible. Introduction and conclusion bracket the thesis. Argument shows logical progressions. Techniques of argumentation are evident. There is a smooth progression of claims from introduction to conclusion. Most sources are authoritative. Clear and convincing argument that presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative.
5.0 % Mechanics of Writing (includes spelling, punctuation, grammar, language use) Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed. Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech. Writer is clearly in command of standard, written, academic English.
10.0 %Format  
5.0 % Paper Format (use of appropriate style for the major and assignment) Template is not used appropriately or documentation format is rarely followed correctly. Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent. Appropriate template is used. Formatting is correct, although some minor errors may be present. Appropriate template is fully used. There are virtually no errors in formatting style. All format elements are correct.
5.0 % Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style) Sources are not documented. Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors. Sources are documented, as appropriate to assignment and style, although some formatting errors may be present. Sources are documented, as appropriate to assignment and style, and format is mostly correct. Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error.
100 % Total Weightage