This is a bit of a different assignment. In the excel file there is data from a restaurant “abc company” and you have to create pivot tables and graphs and explain what the meaning of the data is. This is very important, 1. Examine the data 2. Read question associated with the data 3. Answer questions with combination of pivot table and words. You will notice there are two documents I have attached. The word document is just a reiteration of the questions in the excel spreadsheet so you may copy the answers you arrive at from the excel and paste them in the word doc. Let me know if you have any questions because this seems a bit tricky.
You will need to use the to record your work. The contains the results from 500 completed surveys from patrons of ABC restaurant. The restaurants overall goal is to increase revenue.
Before you begin, review the video on .
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.
|
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 |
NEED ASSIGNMENT HELP?
We guarantee plagiarism-free and AI-free writing services. Every assignment is crafted with originality, precision, and care to meet your academic needs.
Ready to get started? Place your order directly on this post!
Let us help you achieve excellence—authentic work, every time.
Leave a Reply