Question

j. Create a Conditional Probabilities Pivot Table (% of column) for ‘Gender’ and ‘Prefer Scent’, to know the probability that a customer will be of a certain gender given Yes or No preference for the scent. (For example, that if a customer comes into the store because they prefer the scent, what is the probability that the customer will be a female). Create another Conditional Probabilities Table (% of row) for ‘Gender’ and ‘Prefer Scent’, to know the probability that a customer of a given gender will answer Yes or No. (For example, that if a female customer comes into the store, what is the probability that she will prefer the scent)

TABLE C3-1: Teen Shoppers at ForU21 by Gender, Age, Scent Preference, Purpose of Visit, and Total $ Spent
Customer	Gender	Age Group	Prefer Scent	Purpose of Visit	Total Spent
1	M	13-14	YES	PURCHASE	25
2	M	15-16	NO	FRIENDS	16
3	F	13-14	NO	PURCHASE	11
4	M	17-18	YES	FRIENDS	68
5	F	19-20	YES	IMPULSIVE	34
6	F	13-14	NO	PURCHASE	23
7	M	19-20	YES	PURCHASE	46
8	F	13-14	YES	FRIENDS	10
9	F	15-16	YES	FRIENDS	75
10	F	15-16	NO	IMPULSIVE	68
11	M	13-14	NO	IMPULSIVE	17
12	F	17-18	NO	PURCHASE	22
13	M	13-14	NO	FRIENDS	7
14	M	19-20	YES	IMPULSIVE	41
15	F	17-18	YES	FRIENDS	26
16	M	17-18	NO	PURCHASE	12
17	M	15-16	YES	PURCHASE	19
18	F	17-18	NO	FRIENDS	4
19	F	19-20	YES	IMPULSIVE	39
20	F	13-14	YES	PURCHASE	8

Answer 1

Gender Male Female Totals YES5 6 Prefer Scent 9 9 11 20 P(Customer will pre scent!Male)-(5/9) * 100-55.56% P(Customer will not pre scent! Male) (4/9) * 100 44.44% P(Customer will pre scent!Female)-(6/11) * 100 54.55% P(Customer will not pre scent!Female)-(5/11) * 100-45.45% P(Male|Customer will pre scent-(5/11) * 100-45.45% P(Female|Customer will pre scent)-(6/11) * 100-54.55% P(Male|Customer will not pre scent) (4/9) * 100 44.44% P(Female|Customer will not pre scent)-(5/9) * 100-55.56%