Order from us for quality, customized work in due time of your choice.
Data Analysis and Report
Top of Form
Hide Assignment Information
Turn
Data Analysis and Report
Top of Form
Hide Assignment Information
Turnitin™
This assignment will be submitted to Turnitin™.
Instructions
Instructions
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.
Video link: https://leocontent.umgc.edu/content/umuc/tus/mrkt/…
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
Submit your assignment to the dropbox below or to the assignments folder.
Due on Jul 30, 2024 11:59 PM
Available until Jul 30, 2024 11:59 PM. Access restricted after availability ends.
Hide Rubrics
Rubric Name: Assignment 3: Data Analysis and Report
Print
Criteria
Exceeds Expectations
Meets Expectations
Needs Improvement
Not Evident
Criterion Score
Questions 1A
78 points
(78 – 69.43 Points)
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
69.42 points
(69.42-62.5 Points)
Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data
62.4 points
(62.4 – 1 Points)
Answers the question but does not sufficiently explain the rationale for the responses and recommendations, or does not incorporate references/citations to relevant sources to support the response
0 points
Does not answer the question
Score of Questions 1A,
/ 78
Questions 1B
78 points
(78 – 69.43 Points)
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
69.42 points
(69.42 – 61.63 Points)
Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data
61.62 points
(61.62 – 1 Points)
Answers the question but does not sufficiently explain the rationale for the responses and recommendations, or does not incorporate references/citations to relevant sources to support the response
0 points
Does not answer the question
Score of Questions 1B,
/ 78
Questions 1C
78 points
(78 – 69.43 Points)
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
69.42 points
(69.42 – 61.63 Points)
Develops pivot table(s) that correctly calculate the answer and offers practical recommendations based on the analysis of the data
61.62 points
(61.62 – 1 Points)
Answers the question but does not sufficiently explain the rationale for the responses and recommendations, or does not incorporate references/citations to relevant sources to support the response
0 points
Does not answer the question
Score of Questions 1C,
/ 78
Articulation of response
26 points
(26 – 23.15 Points)
Submission is free of errors related to citations, grammar, spelling, syntax, and organization, and is presented in a professional and easy-to-read format
23.14 points
(23.14 – 20.55 Points)
Submission has no major errors related to citations, grammar, spelling, syntax, or organization
20.54 points
(20.54 – 1 Points)
Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas
0 points
Submission has critical errors related to citations, grammar, spelling, syntax or organization that prevent understanding of ideas.
Score of Articulation of response,
/ 26
Order from us for quality, customized work in due time of your choice.