Hi there I need assistance with A-D and am hoping you could showcase answers as well as how they were found, thank you so much!

1. Table C6-1 shows different variables collected by the XYZ surveyor relating to customers of the ForU21 store observed. Note the 'Key to Variables', which will help you to understand variables in order to better interpret your results. Assuming XYZ will be cross-tabulating some of the data to find out more about the shoppers, use the data in Table C6-1 to do the following:

A. how do I Create a Pivot Table that cross-tabulates the variables 'Gender' and 'Prefer Scent' with the value Count of Customer, to know the total in each gender answering Yes and No. Create another Pivot Table that cross-tabulates 'Age Group' and 'Prefer Scent' with the value Count of Customer, to know the total in each age group answering Yes and No. Create yet another Pivot Table that cross-tabulates 'Purpose of Visit' and 'Prefer Scent' with the value Count of Customer, to know the total in each age group answering Yes and No.

B.how do I Create a Joint Probability (% of Total) Pivot Table that cross-tabulates 'Gender' and 'Prefer Scent' with the value being Count of Customer (showing values as % of grand total), to know the percentage of customers who will be both a given gender and a specified Yes or No preference. (For example, the percentage of customers who are both Female and answered Yes; etc.). Create another Joint Probability (% of Total) Pivot Table that cross-tabulates 'Age Group' and 'Prefer Scent' with the value being Count of Customer (showing values as % of grand total), to know the percentage of customers who will be both within a given group and a specified Yes or No preference. Create yet another Joint Probability (% of Total) Pivot Table that cross-tabulates 'Purpose of Visit' and 'Prefer Scent' with the value being Count of Customer (showing values as % of grand total), to know the percentage of customers who will be both within a given group and a specified Yes or No preference.

c.how do I 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 ConditionalProbabilities 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). Following the model above, create four more Conditional Probabilities Pivot Tables representing (% of column) and (% of row) for 'Age Group' and 'Purpose of Visit' as they compare with 'Prefer Scent'

d. how do I Create three additional pivot tables using Average of Total Spent (instead of Count of Customer) to understand the differences in spending by gender, age, and purpose of visit, as split by preference for the vanilla scent.

TABLE C6-1: Teen Shoppers at ForU21 by Gender, Age, Scent Preference, Purpose of Visit, Satisfcation with Prices, Satisfaction with Selection, Satisfaction with Service, and Total $ Spent
Customer	Gender	Age Group	Purpose of Visit	Prefer Scent	Prices	Selection	Service	Total Spent
1	M	13-14	PURCHASE	YES	3	4	3	25
2	M	15-16	FRIENDS	YES	4	4	3	16
3	F	13-14	PURCHASE	YES	3	4	3	17
4	M	17-18	FRIENDS	YES	4	5	4	58
5	F	19-20	IMPULSIVE	YES	5	4	5	36
6	F	13-14	PURCHASE	NO	4	3	3	23
7	M	19-20	PURCHASE	YES	4	4	4	46
8	F	13-14	FRIENDS	NO	1	4	4	10
9	F	15-16	FRIENDS	YES	5	4	2	65
10	F	15-16	IMPULSIVE	NO	4	5	3	58
11	M	13-14	IMPULSIVE	NO	2	4	3	17
12	F	17-18	PURCHASE	NO	3	4	3	20
13	M	13-14	FRIENDS	NO	1	3	5	7
14	M	19-20	IMPULSIVE	YES	4	5	1	41
15	F	17-18	FRIENDS	YES	4	5	2	26
16	M	17-18	PURCHASE	NO	2	5	4	12
17	M	15-16	PURCHASE	YES	3	3	3	22
18	F	17-18	FRIENDS	NO	2	3	3	4
19	F	19-20	IMPULSIVE	YES	5	4	5	39
20	F	13-14	PURCHASE	YES	2	5	1	8
21	M	15-16	IMPULSIVE	YES	4	4	4	18
22	F	17-18	IMPULSIVE	NO	2	4	5	30
23	M	13-14	FRIENDS	NO	2	3	3	4
24	M	17-18	IMPULSIVE	YES	4	4	3	35
25	F	13-14	PURCHASE	YES	2	3	5	8
26	F	17-18	IMPULSIVE	YES	4	5	1	46
27	F	13-14	FRIENDS	NO	2	3	5	9
28	M	15-16	FRIENDS	YES	3	3	3	22
29	M	15-16	FRIENDS	NO	3	3	1	10
30	F	19-20	FRIENDS	YES	4	5	3	34
31	F	15-16	IMPULSIVE	NO	5	2	3	40
32	M	13-14	PURCHASE	NO	2	3	4	10
33	M	19-20	IMPULSIVE	NO	2	3	2	23
34	F	19-20	PURCHASE	YES	5	5	3	49
35	F	13-14	FRIENDS	NO	5	3	2	16
36	F	15-16	FRIENDS	YES	3	3	3	35
37	M	19-20	IMPULSIVE	YES	4	5	3	27
38	F	15-16	PURCHASE	NO	3	5	2	38
39	M	19-20	PURCHASE	YES	5	3	3	39
40	F	17-18	IMPULSIVE	NO	3	3	2	25
41	M	17-18	FRIENDS	YES	4	3	2	11
42	F	13-14	FRIENDS	NO	3	5	3	28
43	F	13-14	PURCHASE	YES	3	1	3	12
44	F	17-18	IMPULSIVE	YES	4	5	1	33
45	M	15-16	PURCHASE	YES	2	4	5	25
46	M	19-20	PURCHASE	YES	2	4	4	16
47	F	17-18	IMPULSIVE	YES	3	5	1	42
48	F	15-16	FRIENDS	YES	3	2	1	21
49	M	13-14	IMPULSIVE	YES	3	3	3	15
50	F	15-16	PURCHASE	YES	2	5	2	22
KEY TO VARIABLES:
Customer	Arbitrary number given to identify each customer surveyed (did not take names due to privacy concerns)
Gender	Gender, male or female
Age Group	Age group in years at time of visit
Purpose	Purpose of the customer's visit to ForU21
		(Purchase = intended to come to make a purchase / Friends = came along with friends / Impulsive = didn't intend to come to store but came on impulse)
Prefer Scent	Whether or not the customer showed preference toward the vanilla scent in the store
Prices	Customer's evaluation of their level of satisfaction with the store's prices, on a 5-point Likert scale (1=not at all satisfied, 5=very satisfied)
Selection	Customer's evaluation of their level of satisfaction with the store's product selection, on a 5-point Likert scale (1=not at all satisfied, 5=very satisfied)
Service	Customer's evaluation of their level of satisfaction with the store's staff service quality, on a 5-point Likert scale (1=not at all satisfied, 5=very satisfied)
Total Spent	Total spent at ForU21 in dollars this visit