Fall 2022 End-of-Semester Exam Solutions for Data Analysis- Statistics, Brown University

Exam Question 1: What is the current level of customer satisfaction and patronage with the various aspects of Tribeca Grill?

Out of 245 respondents, data about overall satisfaction rating is given by only 197 respondents. The majority of the respondents respond being satisfied (91 respondents) or being very satisfied (62 respondents). 80.7% of respondents are satisfied or very satisfied with the overall experience. Only 3% of respondents were very unsatisfied or unsatisfied with their experience at Tribeca Grill.

Q6 Rate Food taste

Out of 245 respondents, data about food rating is given by only 197 respondents. The majority of the respondents respond being satisfied (75 respondents) or being very satisfied (108 respondents). Only 7.1% of respondents rated their food taste experience as neutral at Tribeca Grill.

Q6 Rate Level of service

From the 197 valid responses, 67% described themselves as satisfied or very satisfied with the level of customer service at Tribeca Grill.

Q6 Rate Interior appearance

From the 197 valid responses, 51.8% described themselves as satisfied or very satisfied with the interior appearance at Tribeca Grill.

Q6 Rate Exterior appearance

From the 197 valid responses, 46.2% described themselves as satisfied or very satisfied with the exterior appearance at Tribeca Grill.

Therefore, the metrics on which Tribeca Grill lacks right now, is the exterior appearance, as less than a majority of the respondents rated them to be satisfactory or very satisfactory.

Exam Question 1b : Request frequency of patronage of Tribeca Grill

Exam Solution 1b :

Descriptive Statistics

A respondent has had an average of 4.97 lunch meals and 4.37 dinner meals at Tribeca Grill in the last 3 months

Exam Question 1c : Solicit likes and dislikes with Tribeca Grill

Exam Solution 1c :

The following frequency table lists the disliked things about the restaurant

Q5 One thing you dislike about Tribeca Grill

61 respondents had things that they disliked about Tribeca Grill. The two main gripes of customers were related to location (20 respondents mentioned it) and parking (23 respondents experienced problems with parking).

The following frequency table lists the liked things about the restaurant

Q4 One thing you like best about Tribeca Grill

Food and service were the most liked things about Tribeca Grill.

Exam Questions 2: Why have individuals not patronized Tribeca Grill?

2a : Determine reasons for not patronizing Tribeca Grill

Exam Solution :

Reasons for Not Eating at Tribeca Grill

There are 48 responses as to why the survey participants don’t eat at Tribeca Grill. The largest contributor to that, is consumer being unaware of the restaurant, followed by location, and bad food (12.5% of responses).

How far do you live from Tribeca Grill?

Data shows that 68% of respondents live within 5 miles of the restaurant.

Exam Question 3: How has the addition of a new competitor down the street impacted Grill’s customer base?

Exam Solution 3a: Determine attitude toward new competitor in relation to Tribeca Grill

Q10 How has the opening of Fisherman's Paradise affected patronage of Tribeca Grill

The opening of the new restaurant has led to a small but significant shift away from dining at Tribeca Grill. There are 25.5% of respondents who have said that they would either quit eating at Tribeca or eat less than Tribeca after the opening of Fisherman’s Paradise, compared to 13.8% who informed that they would eat more at Tribeca Grill. However, the majority (60.6%) opine that they would eat about the same at Tribeca Grill.

Q9 Compared to Tribeca Grill, how would you rate Fisherman's Paradise?

Ratings wise, 45.9% rate Tribeca Grill and Fisherman’s Paradise the same, while 16.4% rate Fisherman’s Paradise to be worse or much worse than Tribeca Grill and 36.6% rate Fisherman’s Paradise to be better or much better than Tribeca Grill.

Therefore, more people rate Fisherman’s Paradise higher than Tribeca Grill, and more people are willing to dine less frequently at Tribeca Grill following the opening of Fisherman’s Paradise

Exam Question 3b: Determine if frequency of patronage of Tribeca Grill declined

Exam Solution:

Q10 How has the opening of Fisherman's Paradise affected patronage of Tribeca Grill

The opening of the new restaurant has led to a small but significant shift away from dining at Tribeca Grill. There are 25.5% of respondents who have said that they would either quit eating at Tribeca, or eat less than Tribeca after the opening of Fisherman’s Paradise, compared to 13.8% who informed that they would eat more at Tribeca Grill. However, the majority (60.6%) opine that they would eat about the same at Tribeca Grill.

Exam Question 4: Would changing Tribeca Grill’s menu, advertising, and/or promotional practice increase sales?

Exam Question 4a: Solicit attitude toward new menu items

Exam Solution

The dataset captures the response of the respondents to proposed changes in the menus such as introduction of mini-deserts, free bread before meal, half-portions of meals, introduction of healthier goods, kids’ menus, and lower prices & smaller portions.

Q11 Add new mini-deserts

42.8% of respondents regarded introduction of new mini-deserts as important or very important.

Q11 Add free bread before meal

74.2% of respondents regarded introduction of free bread before meal as important or very important.

Q11 Add half-portions of meals

50.5% of respondents regarded introduction of half-portion of meals as important or very important.

Q11 Add healthier foods

70.8% of respondents regarded introduction of healthier foods as important or very important.

Q11 Add kid's menus

21.1% of respondents regarded introduction of kids’ menus as important or very important.

From these analyses, we see that giving out free bread before meals, and addition of healthier menu items are the best ways to address any changes to menus, as a large majority of customers regard them as important or very important.

Exam Question 4b: Determine the impact of advertising on patronage decision

Exam Solution 4b:

Q12 Advertising on radio

Only 27.6% of respondents regard the radio as important or very important.

Q12 Advertising on TV

50.5% of respondents regard the radio as important or very important.

Q12 Advertising in the newspaper

Of the total respondents, only 17.3% respondents regard newspaper ads as important or very important.

Therefore, of the 3 types of advertising media, only TV advertising was regarded by a majority of respondents as important or very important.

Exam Question 3c: Identify promotions that may influence patronage decisions

Exam Solution 3c :

Coupons, offering lower prices & smaller lunch portions and price off meals at various times were the different types of promotions proposed in the dataset.

Q11 Offer lower prices and smaller portions for lunch

66.0% of respondents regarded lowering of prices and introducing smaller portions for lunch as important or very important.

Q12 Coupons

43.0% of respondents regarded coupons as important or very important.

Q12 Price-off meals at various times

85.6% of respondents regard the price off meals at various times as important or very important.

Therefore, comparing the consumer attitudes towards the different types of promotions, we see that the price of meals at various times is the most effective way of promotion, followed by lowering of prices and introducing smaller portions for lunch.

__

Survey questions appear to be comprehensive as they cover various aspects of the consumer’s attitudes towards Tribeca Grill, the influence of Fisherman’s Paradise opening up, changes in menu items, various promotion campaigns and ad campaigns

Q7 to 10 appear to be good questions, as they measure the impact of Fisherman’s Paradise and its impact on Tribeca Grill.