Restaurant Grades Case Analysis

1) In Excel, calculate averages for pageviews, calls, and reservations by the treatment group column - you will have three average values, one for each group. Tabulate them. Make comparisons and then inferences.

2) Split the sample based on column F -restaurant type.Now you can analyze based on whether the restaurant is chain/independent. Now recalculate the averages as in step 1 again. See if your inferences hold based on restaurant type.

Use the following questions as guidance as you provide recommendation.

1) In your analysis, how successful is RG's current advertising package? There is a proposal for an alternate design on the table.With the data you have access to, do you recommend staying the course or making the switch?

2) If you had the opportunity to collect more data, which would be the most important elements you would want to add to inform your decision?

3) Given that there were already businesses that were advertising on the platform, did they even need to run this experiment, or could they just have compared outcomes for businesses who advertise and those who do not?

Average Pageviews Calls Reservations Group Code Control 0 Current Design New Ad Design 2 Averages by Restaurant Type Chain Restaurants Average Pageviews Calls Reservations Group Code Control 0 Current Design New Ad Design 2 Independent Restaurants Average Pageviews Calls Reservations Group Code Control 0 Current Design New Ad Design 2