Will a customer accept the coupon?

The goal of this project is to use what you know about visualizations and probability distributions to distinguish between customers who accepted a driving coupon versus those that did not.

Observations

1. Bar coupons not seem to be very popular among this population as only 41% of the population accepted the Bar coupon
2. Drivers that go to a bar more than once a month, have passengers that are not a kid and are not widowed seem to be the best candidates for accepting the Bar coupons.
3. Age does not seem to be a deterministic factor as we can see people under the age of 30 that have a very similar acceptance rate to those over the age of 25.
   However, 60% of age 41 that go less than 1 times per month accepted the Bar coupon
4. Drivers with a Kid(s) as a passenger are less responsive to the Bar coupons
5. Those drivers that go to a bar more than once a month are more likely to accept the Bar coupon

Recommendations

1. There is no information about what the discount is, perhaps increasing the discount would attract more drivers to accept the coupon
2. Increasing the expiry date of the Bar coupon could attract more customers.

Comparison Table

coupon	proportion of {COUPON} coupons were accepted	acceptance rate between those who went to a {COUPON} 3 or fewer times a month to those who went more	acceptance rate between drivers who go to a {COUPON} more than once a month and are over the age of 25 to the all others	acceptance rate between drivers who go to a {COUPON} more than once a month and had passengers that were not a kid and had occupations other than farming, fishing, or forestry	Compare the acceptance rates between those drivers who:- go to a {COUPON} more than once a month, had passengers that were not a kid, and were not widowed	go to a {COUPON} more than once a month and are under the age of 30	go to cheap restaurants more than 4 times a month and income is less than 50K
	0 1	0 1	0 1	0 1	0 1	0 1	0 1
Bar	0.589985 0.410015	0.437948 0.562052	0.378466 0.621534	0.376894 0.623106	0.30976 0.69024	0.371919 0.628081	0.406044 0.593956

Note: 0 Not Accepted, 1 Accepted

Independent Investigation

The following observations are a result of the analysis carried out in the table and plots below, as they give a very comprenhensive view of the coupon acceptance among drivers.

Observations

1. Drivers that have their Partner as a passenger and go less than 1 times a month to a Bar are the ones more likely to accept the Bar coupon
2. There is very little difference on who goes as a passenger for those who accepted the Restaurant less than 20 coupon. However, people that go 1 to 3 times a month to a restaurant less than 20 are more likely to accept this coupon.
3. Drivers that go with their partner or with a Friend(s) and go between 1 and 3 times a month are more likely to accept the Carry Away coupon.
4. Drivers that go less than 1 times a month to a Restaurant between 20 and 50 are more likely to accept the Restaurant (20-50) coupon.
5. The portion of Carry out and Take away coupons were the most accepted with 74% followed by Restaurants with less than 20 with 71%
6. There is no difference between those who go 3 times or less to those who go more.
7. Coffee House coupon is the most popular amongst:
   • Drivers that have a Kid(s) or a Friend(s) as a passenger and go to a Coffee House 1 or 3 times a month are the more likely to accept the Coffee House coupon
   • Drivers that go once a month and are over the age of 25
   • Drivers that go more than once a month, have a passenger that is not a kid and their occupation is not farming, fishing or forestry
   • Drivers that go more than once a month, their passenger is not a kid and are not widowed
   • Drivers that go more than once a month and are under the age of 30

Recommendatios

1. Considering that the Bar coupon is the least popular.
   Changing the expiry date of the Bar coupon could attract more customers.
   Also, there is no evidence of this in the information provided but perhaps drink driving might be a restriction for accepting the coupon.
2. Rather than inviting the customer to go to the business premises, perhaps, home delivery would be a more attractive option for the drivers.
   This could be an alternative for those that did not accept the coupon.
3. As mentioned before, there is no information about what the discount is, but variations of the discount depending on the business might attract more customers.
   
4. Drivers that go more than 8 times a month to any business are less likely to accept the coupon.
   So, a different type of discount maybe necessary like a loyalty card that gives them other discounts.

Comparison Table

In this table we can see all the values for the different criteria

coupon	proportion of {COUPON} coupons were accepted	acceptance rate between those who went to a {COUPON} 3 or fewer times a month to those who went more	acceptance rate between drivers who go to a {COUPON} more than once a month and are over the age of 25 to the all others	acceptance rate between drivers who go to a {COUPON} more than once a month and had passengers that were not a kid and had occupations other than farming, fishing, or forestry	Compare the acceptance rates between those drivers who:- go to a {COUPON} more than once a month, had passengers that were not a kid, and were not widowed	go to a {COUPON} more than once a month and are under the age of 30	go to cheap restaurants more than 4 times a month and income is less than 50K
	0 1	0 1	0 1	0 1	0 1	0 1	0 1
Bar	0.589985 0.410015	0.437948 0.562052	0.378466 0.621534	0.376894 0.623106	0.30976 0.69024	0.371919 0.628081	0.406044 0.593956
Coffee House	0.500751 0.499249	0.445091 0.554909	0.374453 0.625547	0.357985 0.642015	0.27299 0.72701	0.329211 0.670789	0.406044 0.593956
Restaurant(<20)	0.292893 0.707107	0.445453 0.554547	0.436398 0.563602	0.419152 0.580848	0.336397 0.663603	0.386693 0.613307	0.406044 0.593956
Carry out & Take away	0.264522 0.735478	0.440574 0.559426	0.428049 0.571951	0.414897 0.585103	0.335053 0.664947	0.392216 0.607784	0.406044 0.593956
Restaurant(20-50)	0.558981 0.441019	0.439104 0.560896	0.405635 0.594365	0.386711 0.613289	0.309091 0.690909	0.34964 0.65036	0.406044 0.593956

Plots

We can see in the following plots the distribution of all coupons in relation to the type of passengers and the frequency of their visits

Same analysis performed in section 1 for Bar coupon but this time for all coupons