You will need to use the Data Analysis and Report Template to record your work. The MS Excel Workboo ...

---

You will need to use the Data Analysis and Report Template to record your work. The MS Excel Workbook contains the results from 500 completed surveys from patrons of ABC restaurant. The restaurant’s overall goal is to increase revenue. For this assignment, you will Analyze the data using pivot tables to address a series of questions. Analyze the data and use the data to develop strategic recommendations. Report findings and recommendations using a narrative, charts, and graphs. Important You will submit the MS Excel workbook, and the MS Word report so that you can provide answers to the questions. Be sure to copy and paste the pivot table from the MS Excel workbook into your Data Analysis Report. How Your Work Will Be Evaluated The MS Excel Workbook and MS Word Report both must be submitted. Answers that require a pivot table will be evaluated based on whether the answer is correct. For questions asking for recommendations based on the data, your answers will be evaluated based on how you apply the data and course concepts to support your recommendations. Your submission should be free of errors related to citations, grammar, spelling, syntax, and organization, and be presented in a professional and easy-to-read format Criteria Exceeds Expectations Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data, citing relevant sources that support the rationale/recommendation Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data, citing relevant sources that support the rationale/recommendation Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data, citing relevant sources that support the rationale/recommendation Submission is free of errors related to citations, grammar, spelling, syntax, and organization, and is presented in a professional and easy-to-read format