You will need to use the Data Analysis and Report Template to record your work.

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.
Before you begin, review the video on How to Create Pivot Tables in Excel. (https://leocontent.umgc.edu/content/umuc/tus/mrkt/mrkt412/2242/learning-topic-list/how-to-create-pivot-tables-in-excel.html?ou=928903#)
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 so that your work on the pivot tables can be evaluated, 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.