1. A clustered bar chart to examine the method of payment by customer type (regular or promotional). Comment on any differences you observe between the methods of payments used by the different types of customers? (show me the steps for the question and how to level a comment in excel)CustomerType of CustomerItemsNet SalesMethod of PaymentGenderMarital StatusAge1Regular139.50DiscoverMaleMarried322Promotional1102.40Proprietary CardFemaleMarried363Regular122.50Proprietary CardFemaleMarried324Promotional5100.40Proprietary CardFemaleMarried285Regular254.00MasterCardFemaleMarried346Regular144.50MasterCardFemaleMarried447Promotional278.00Proprietary CardFemaleMarried308Regular122.50VisaFemaleMarried409Promotional256.52Proprietary CardFemaleMarried4610Regular144.50Proprietary CardFemaleMarried3611Regular129.50Proprietary CardFemaleMarried4812Promotional131.60Proprietary CardFemaleMarried4013Promotional9160.40VisaFemaleMarried4014Promotional264.50VisaFemaleMarried4615Regular149.50VisaMaleSingle2416Promotional271.40Proprietary CardMaleSingle3617Promotional394.00Proprietary CardFemaleSingle2218Regular354.50DiscoverFemaleMarried4019Promotional238.50MasterCardFemaleMarried3220Promotional644.80Proprietary CardFemaleMarried5621Promotional131.60Proprietary CardFemaleSingle2822Promotional470.82Proprietary CardFemaleMarried3823Promotional7266.00American ExpressFemaleMarried5024Regular274.00Proprietary CardFemaleMarried4225Promotional239.50VisaMaleMarried4826Promotional130.02Proprietary CardFemaleMarried6027Regular144.50Proprietary CardFemaleMarried5428Promotional5192.80Proprietary CardFemaleSingle4229Promotional371.20Proprietary CardFemaleMarried3230Promotional118.00Proprietary CardFemaleMarried7031Promotional263.20MasterCardFemaleMarried2832Regular175.00Proprietary CardFemaleMarried5233Promotional363.20Proprietary CardFemaleMarried4434Regular140.00Proprietary CardFemaleMarried3435Promotional5105.50MasterCardFemaleMarried5636Regular129.50MasterCardMaleSingle3637Regular2102.50VisaFemaleSingle4238Promotional6117.50Proprietary CardFemaleMarried5039Promotional513.23Proprietary CardFemaleMarried4440Regular252.50Proprietary CardFemaleMarried5841Promotional13198.80Proprietary CardFemaleMarried4242Promotional419.50VisaFemaleMarried4643Regular2123.50Proprietary CardFemaleMarried4844Promotional162.40Proprietary CardFemaleMarried5445Promotional223.80Proprietary CardFemaleMarried3846Promotional239.60Proprietary CardFemaleMarried6047Regular125.00MasterCardFemaleMarried4648Promotional363.64Proprietary CardFemaleMarried3049Promotional114.82Proprietary CardFemaleMarried3250Promotional9145.20MasterCardFemaleMarried4651Promotional6176.62Proprietary CardFemaleMarried3852Promotional5118.80Proprietary CardMaleMarried6853Regular158.00DiscoverFemaleSingle7854Regular274.00VisaFemaleSingle2055Regular249.50MasterCardFemaleMarried3256Promotional3141.60Proprietary CardFemaleMarried3857Promotional6123.10Proprietary CardFemaleMarried5458Promotional280.40Proprietary CardFemaleMarried4859Promotional465.20MasterCardFemaleMarried4660Promotional4113.00Proprietary CardFemaleSingle5061Promotional1108.80Proprietary CardFemaleMarried4662Promotional359.91Proprietary CardFemaleSingle3063Promotional553.60Proprietary CardFemaleMarried5464Promotional131.60Proprietary CardFemaleSingle4265Promotional249.50Proprietary CardFemaleMarried4866Promotional139.60Proprietary CardFemaleMarried6267Promotional259.50Proprietary CardFemaleMarried3468Promotional5146.80Proprietary CardFemaleMarried2869Promotional247.20Proprietary CardMaleMarried4670Promotional895.05Proprietary CardFemaleMarried5471Promotional5155.32Proprietary CardFemaleMarried3072Promotional458.00MasterCardFemaleMarried3273Regular169.00Proprietary CardFemaleSingle2274Promotional246.50Proprietary CardFemaleMarried3275Promotional245.22Proprietary CardFemaleMarried7476Promotional484.74Proprietary CardFemaleMarried6277Regular239.00Proprietary CardFemaleMarried4278Promotional4111.14Proprietary CardFemaleMarried2879Promotional386.80Proprietary CardFemaleMarried3880Regular289.00DiscoverFemaleMarried5481Promotional278.00MasterCardFemaleMarried6882Promotional653.20Proprietary CardFemaleSingle3083Promotional458.50VisaFemaleMarried3684Promotional346.00Proprietary CardFemaleMarried4485Regular237.50VisaFemaleMarried4486Promotional120.80Proprietary CardFemaleMarried6287Regular6144.00MasterCardFemaleSingle4888Regular4107.00Proprietary CardFemaleMarried3689Promotional131.60Proprietary CardFemaleSingle2090Promotional657.60Proprietary CardFemaleMarried4291Promotional495.20Proprietary CardFemaleMarried5492Promotional122.42Proprietary CardFemaleMarried5493Regular5159.75Proprietary CardFemaleMarried7294Promotional17229.50Proprietary CardFemaleMarried3095Regular366.00American ExpressFemaleMarried4696Regular139.50MasterCardFemaleMarried4497Promotional9253.00Proprietary CardFemaleMarried3098Promotional10287.59Proprietary CardFemaleMarried5299Promotional247.60Proprietary CardFemaleMarried30100Promotional128.44Proprietary CardFemaleMarried44

Name: 1. A clustered bar chart to examine the method of payment by customer
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: 1. A clustered bar chart to examine the method of payment by customer type (regular or promotional). Comment on any differences you observe between the methods of payments used by the different types of customers? (show me the steps for the question

Question

Accepted Answer

Create a cross tabulation of type of customer versus method of payment:
The data represents the…

Customer	Type of Customer	Items	Net Sales	Method of Payment	Gender	Marital Status	Age
1	Regular	1	39.50	Discover	Male	Married	32
2	Promotional	1	102.40	Proprietary Card	Female	Married	36
3	Regular	1	22.50	Proprietary Card	Female	Married	32
4	Promotional	5	100.40	Proprietary Card	Female	Married	28
5	Regular	2	54.00	MasterCard	Female	Married	34
6	Regular	1	44.50	MasterCard	Female	Married	44
7	Promotional	2	78.00	Proprietary Card	Female	Married	30
8	Regular	1	22.50	Visa	Female	Married	40
9	Promotional	2	56.52	Proprietary Card	Female	Married	46
10	Regular	1	44.50	Proprietary Card	Female	Married	36
11	Regular	1	29.50	Proprietary Card	Female	Married	48
12	Promotional	1	31.60	Proprietary Card	Female	Married	40
13	Promotional	9	160.40	Visa	Female	Married	40
14	Promotional	2	64.50	Visa	Female	Married	46
15	Regular	1	49.50	Visa	Male	Single	24
16	Promotional	2	71.40	Proprietary Card	Male	Single	36
17	Promotional	3	94.00	Proprietary Card	Female	Single	22
18	Regular	3	54.50	Discover	Female	Married	40
19	Promotional	2	38.50	MasterCard	Female	Married	32
20	Promotional	6	44.80	Proprietary Card	Female	Married	56
21	Promotional	1	31.60	Proprietary Card	Female	Single	28
22	Promotional	4	70.82	Proprietary Card	Female	Married	38
23	Promotional	7	266.00	American Express	Female	Married	50
24	Regular	2	74.00	Proprietary Card	Female	Married	42
25	Promotional	2	39.50	Visa	Male	Married	48
26	Promotional	1	30.02	Proprietary Card	Female	Married	60
27	Regular	1	44.50	Proprietary Card	Female	Married	54
28	Promotional	5	192.80	Proprietary Card	Female	Single	42
29	Promotional	3	71.20	Proprietary Card	Female	Married	32
30	Promotional	1	18.00	Proprietary Card	Female	Married	70
31	Promotional	2	63.20	MasterCard	Female	Married	28
32	Regular	1	75.00	Proprietary Card	Female	Married	52
33	Promotional	3	63.20	Proprietary Card	Female	Married	44
34	Regular	1	40.00	Proprietary Card	Female	Married	34
35	Promotional	5	105.50	MasterCard	Female	Married	56
36	Regular	1	29.50	MasterCard	Male	Single	36
37	Regular	2	102.50	Visa	Female	Single	42
38	Promotional	6	117.50	Proprietary Card	Female	Married	50
39	Promotional	5	13.23	Proprietary Card	Female	Married	44
40	Regular	2	52.50	Proprietary Card	Female	Married	58
41	Promotional	13	198.80	Proprietary Card	Female	Married	42
42	Promotional	4	19.50	Visa	Female	Married	46
43	Regular	2	123.50	Proprietary Card	Female	Married	48
44	Promotional	1	62.40	Proprietary Card	Female	Married	54
45	Promotional	2	23.80	Proprietary Card	Female	Married	38
46	Promotional	2	39.60	Proprietary Card	Female	Married	60
47	Regular	1	25.00	MasterCard	Female	Married	46
48	Promotional	3	63.64	Proprietary Card	Female	Married	30
49	Promotional	1	14.82	Proprietary Card	Female	Married	32
50	Promotional	9	145.20	MasterCard	Female	Married	46
51	Promotional	6	176.62	Proprietary Card	Female	Married	38
52	Promotional	5	118.80	Proprietary Card	Male	Married	68
53	Regular	1	58.00	Discover	Female	Single	78
54	Regular	2	74.00	Visa	Female	Single	20
55	Regular	2	49.50	MasterCard	Female	Married	32
56	Promotional	3	141.60	Proprietary Card	Female	Married	38
57	Promotional	6	123.10	Proprietary Card	Female	Married	54
58	Promotional	2	80.40	Proprietary Card	Female	Married	48
59	Promotional	4	65.20	MasterCard	Female	Married	46
60	Promotional	4	113.00	Proprietary Card	Female	Single	50
61	Promotional	1	108.80	Proprietary Card	Female	Married	46
62	Promotional	3	59.91	Proprietary Card	Female	Single	30
63	Promotional	5	53.60	Proprietary Card	Female	Married	54
64	Promotional	1	31.60	Proprietary Card	Female	Single	42
65	Promotional	2	49.50	Proprietary Card	Female	Married	48
66	Promotional	1	39.60	Proprietary Card	Female	Married	62
67	Promotional	2	59.50	Proprietary Card	Female	Married	34
68	Promotional	5	146.80	Proprietary Card	Female	Married	28
69	Promotional	2	47.20	Proprietary Card	Male	Married	46
70	Promotional	8	95.05	Proprietary Card	Female	Married	54
71	Promotional	5	155.32	Proprietary Card	Female	Married	30
72	Promotional	4	58.00	MasterCard	Female	Married	32
73	Regular	1	69.00	Proprietary Card	Female	Single	22
74	Promotional	2	46.50	Proprietary Card	Female	Married	32
75	Promotional	2	45.22	Proprietary Card	Female	Married	74
76	Promotional	4	84.74	Proprietary Card	Female	Married	62
77	Regular	2	39.00	Proprietary Card	Female	Married	42
78	Promotional	4	111.14	Proprietary Card	Female	Married	28
79	Promotional	3	86.80	Proprietary Card	Female	Married	38
80	Regular	2	89.00	Discover	Female	Married	54
81	Promotional	2	78.00	MasterCard	Female	Married	68
82	Promotional	6	53.20	Proprietary Card	Female	Single	30
83	Promotional	4	58.50	Visa	Female	Married	36
84	Promotional	3	46.00	Proprietary Card	Female	Married	44
85	Regular	2	37.50	Visa	Female	Married	44
86	Promotional	1	20.80	Proprietary Card	Female	Married	62
87	Regular	6	144.00	MasterCard	Female	Single	48
88	Regular	4	107.00	Proprietary Card	Female	Married	36
89	Promotional	1	31.60	Proprietary Card	Female	Single	20
90	Promotional	6	57.60	Proprietary Card	Female	Married	42
91	Promotional	4	95.20	Proprietary Card	Female	Married	54
92	Promotional	1	22.42	Proprietary Card	Female	Married	54
93	Regular	5	159.75	Proprietary Card	Female	Married	72
94	Promotional	17	229.50	Proprietary Card	Female	Married	30
95	Regular	3	66.00	American Express	Female	Married	46
96	Regular	1	39.50	MasterCard	Female	Married	44
97	Promotional	9	253.00	Proprietary Card	Female	Married	30
98	Promotional	10	287.59	Proprietary Card	Female	Married	52
99	Promotional	2	47.60	Proprietary Card	Female	Married	30
100	Promotional	1	28.44	Proprietary Card	Female	Married	44