Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have been hired as a consultant to review the feedback and suggest an improvement to the restaurant Manager that would improve their customer satisfaction
You have been hired as a consultant to review the feedback and suggest an improvement to the restaurant Manager that would improve their customer satisfaction rating. Perform qualitative analysis to make a recommendation for the Manager.
Complete the following:
- Import the file into Excel. Save the file as a MS Excel workbook with the name A3_Your userID (i.e. A3-azehr12345.xlsx).
Following the 5 step process for Qualitative Data Analysis, complete the following:
- Perform any required data cleaning within the worksheet.
- Review the data.
- Add a column named "Codes".
- Code the data and add the codes within this new column.
- Add a new Worksheet named "Themes".
- Identify patterns in the data and create a list of themes on this new worksheet.
- Add a description of the themes that you have identified on this worksheet.
- Add a column in the original data worksheet named "Themes".
- List themes specific to the data in this new column.
- Use at least one chart to visualize the patterns within the data.
- Put your chart(s) on the "Themes" worksheet.
- Add a Worksheet in the file named "Conclusions".
- Make a recommendation for an improvement at the restaurant based on the data. Write your recommendation on this new sheet.
- In your conclusions, provide a justification for making this recommendation based on the data. Write your justification on the "Conclusions" sheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
I can guide you through the process so you can perform the steps yourself Data Cleaning Open the Exc...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started