View the step-by-step solution to:

Question

The purpose of this assignment is to practice working with marketing research data, searching for patterns in the

numbers that might lead you to a new understanding about consumers, their behaviors or their preferences.


Download the McSandwich Excel spreadsheet that lists the responses given by 50 customers of the fast food restaurant. The customers were asked questions about the food (quality & variety), service (friendly, fast & competent), pricing, the overall experience (recommend to a friend, general satisfaction), and some personal information (gender, frequency of dining there, and how close to the restaurant they lived).


In this assignment, you will complete the following steps:


1.    Sort the responses by gender (0 = male, 1 = female) and use the "Average" function to determine if males and females had different opinions about the restaurant's food, service, pricing and overall experience.

2.    Sort the responses again, this time by usage (0 = infrequent diner, 1 = frequent diner). Once again, use the "Average" function to determine if frequent diners and infrequent diners had different opinions about the restaurant's food, service, pricing and overall experience.


3.    Sort the responses one last time, this time by home location (1 = less than a mile from the restaurant, 2 = 1-5 miles from the restaurant, 3 = more than 5 miles from the restaurant). Again, use the "Average" function to determine if nearby and more distant consumers had different opinions about the restaurant's food, service, pricing and overall experience.


4.    In a 2 page document, summarize your conclusions from the three different ways you examined the data.  Please include the specific numeric data that led you to those conclusions. Then, describe at least 3 recommended marketing actions for McSandwich, based on those conclusions.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes