Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. 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:

  1. Perform any required data cleaning within the worksheet.


  1. Review the data.


  1. Add a column named "Codes".
  2. Code the data and add the codes within this new column.


  1. Add a new Worksheet named "Themes".
  2. Identify patterns in the data and create a list of themes on this new worksheet.
  3. Add a description of the themes that you have identified on this worksheet.
  4. Add a column in the original data worksheet named "Themes".
  5. List themes specific to the data in this new column.
  6. Use at least one chart to visualize the patterns within the data.
  7. Put your chart(s) on the "Themes" worksheet.


  1. Add a Worksheet in the file named "Conclusions".
  2. Make a recommendation for an improvement at the restaurant based on the data. Write your recommendation on this new sheet.


  1. 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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Thomas Beechy, Umashanker Trivedi, Kenneth MacAulay

6th edition

013703038X, 978-0137030385

More Books

Students also viewed these Human Resource Management questions

Question

What is level mixed-model sequencing and why is it important?

Answered: 1 week ago

Question

To what extent has technology had an impact on JIT/lean systems?

Answered: 1 week ago