Sum of Net Sales

Method of Payment Total

American Express 332
Discover 241
MasterCard 939.6
Proprietary Card 5619.05
Visa 628.4
Grand Total 7760.05
Average of Net Sales Type of Customer
Gender Marital Status Promotional Regular Grand Total
Female Married 86.48 58.81 78.87
Single 75.96 89.50 81.17
Female Total 85.20 64.49 79.19
Male Married 68.50 39.50 61.25
Single 71.40 39.50 50.13
Male Total 69.23 39.50 56.49
Grand Total 84.29 61.99 77.60
Average of Net Sales Marital Status
Married Single Grand Total
Total 78.029047619 75.350625 77.6005
Comment: The average of Netsales for male and female customers are quite
Count of Method of PaymentMarital Status
Type of Customer Married Single Grand Total
Promotional 61 9 70
Regular 23 7 30
Grand Total 84 16 100

This is cross table To evaluate the relationship, we compare the percentage of users of coupons (Pronotion
of users of coupons (Pronotional) within married
 Type of
Customer Customer Items Net Sales Method of Payment
1 Regular 1 39.50 Discover
2 Promotional 1 102.40 Proprietary Card
3 Regular 1 22.50 Proprietary Card
4 Promotional 5 100.40 Proprietary Card
5 Regular 2 54.00 MasterCard
6 Regular 1 44.50 MasterCard
7 Promotional 2 78.00 Proprietary Card
8 Regular 1 22.50 Visa
9 Promotional 2 56.52 Proprietary Card
10 Regular 1 44.50 Proprietary Card
11 Regular 1 29.50 Proprietary Card
12 Promotional 1 31.60 Proprietary Card
13 Promotional 9 160.40 Visa
14 Promotional 2 64.50 Visa
15 Regular 1 49.50 Visa
16 Promotional 2 71.40 Proprietary Card
17 Promotional 3 94.00 Proprietary Card
18 Regular 3 54.50 Discover
19 Promotional 2 38.50 MasterCard
20 Promotional 6 44.80 Proprietary Card
21 Promotional 1 31.60 Proprietary Card
22 Promotional 4 70.82 Proprietary Card
23 Promotional 7 266.00 American Express
24 Regular 2 74.00 Proprietary Card
25 Promotional 2 39.50 Visa
26 Promotional 1 30.02 Proprietary Card
27 Regular 1 44.50 Proprietary Card
28 Promotional 5 192.80 Proprietary Card
29 Promotional 3 71.20 Proprietary Card
30 Promotional 1 18.00 Proprietary Card
31 Promotional 2 63.20 MasterCard
32 Regular 1 75.00 Proprietary Card
33 Promotional 3 63.20 Proprietary Card
34 Regular 1 40.00 Proprietary Card
35 Promotional 5 105.50 MasterCard
36 Regular 1 29.50 MasterCard
37 Regular 2 102.50 Visa
38 Promotional 6 117.50 Proprietary Card
39 Promotional 5 13.23 Proprietary Card
40 Regular 2 52.50 Proprietary Card
41 Promotional 13 198.80 Proprietary Card
42 Promotional 4 19.50 Visa
43 Regular 2 123.50 Proprietary Card
44 Promotional 1 62.40 Proprietary Card
45 Promotional 2 23.80 Proprietary Card
46 Promotional 2 39.60 Proprietary Card
47 Regular 1 25.00 MasterCard
48 Promotional 3 63.64 Proprietary Card
49 Promotional 1 14.82 Proprietary Card
50 Promotional 9 145.20 MasterCard
51 Promotional 6 176.62 Proprietary Card
52 Promotional 5 118.80 Proprietary Card
53 Regular 1 58.00 Discover
54 Regular 2 74.00 Visa
55 Regular 2 49.50 MasterCard
56 Promotional 3 141.60 Proprietary Card
57 Promotional 6 123.10 Proprietary Card
58 Promotional 2 80.40 Proprietary Card
59 Promotional 4 65.20 MasterCard
60 Promotional 4 113.00 Proprietary Card
61 Promotional 1 108.80 Proprietary Card
62 Promotional 3 59.91 Proprietary Card
63 Promotional 5 53.60 Proprietary Card
64 Promotional 1 31.60 Proprietary Card
65 Promotional 2 49.50 Proprietary Card
66 Promotional 1 39.60 Proprietary Card
67 Promotional 2 59.50 Proprietary Card
68 Promotional 5 146.80 Proprietary Card
69 Promotional 2 47.20 Proprietary Card
70 Promotional 8 95.05 Proprietary Card
71 Promotional 5 155.32 Proprietary Card
72 Promotional 4 58.00 MasterCard
73 Regular 1 69.00 Proprietary Card
74 Promotional 2 46.50 Proprietary Card
75 Promotional 2 45.22 Proprietary Card
76 Promotional 4 84.74 Proprietary Card
77 Regular 2 39.00 Proprietary Card
78 Promotional 4 111.14 Proprietary Card
 79 Promotional 3 86.80 Proprietary Card
80 Regular 2 89.00 Discover
81 Promotional 2 78.00 MasterCard
82 Promotional 6 53.20 Proprietary Card
83 Promotional 4 58.50 Visa
84 Promotional 3 46.00 Proprietary Card
85 Regular 2 37.50 Visa
86 Promotional 1 20.80 Proprietary Card
87 Regular 6 144.00 MasterCard
88 Regular 4 107.00 Proprietary Card
89 Promotional 1 31.60 Proprietary Card
90 Promotional 6 57.60 Proprietary Card
91 Promotional 4 95.20 Proprietary Card
92 Promotional 1 22.42 Proprietary Card
93 Regular 5 159.75 Proprietary Card
94 Promotional 17 229.50 Proprietary Card
95 Regular 3 66.00 American Express
96 Regular 1 39.50 MasterCard
97 Promotional 9 253.00 Proprietary Card
98 Promotional 10 287.59 Proprietary Card
99 Promotional 2 47.60 Proprietary Card
100 Promotional 1 28.44 Proprietary Card
 Marital
Gender Status Age
Male Married 32
Female Married 36
Female Married 32
Female Married 28
Female Married 34 Frequency table for qualitative vảiab
Female Married 44 The vảiable: Type of Customer
Female Married 30 Name Frequency
Female Married 40 Regular 30
Female Married 46 Promotional 70
Female Married 36
Female Married 48 comment: There are 30 customers who did not use vouche
Female Married 40
Female Married 40 For qualitative data, we use bar chart or pie chart
Female Married 46
Male Single 24 Example: Preduce frequency table for Method of payment
Male Single 36
Female Single 22 Card name Frequency Percent
Female Married 40 Proprietary Card 70 0.7
Female Married 32 MasterCard 14 0.14
Female Married 56 Visa 10 0.1
Female Single 28 Discover 4 0.04
Female Married 38 American Express 2 0.02
Female Married 50 SUM 100 1
Female Married 42
Male Married 48
Female Married 60
Female Married 54
Female Single 42 Frequency
Female Married 32
Female Married 70
Female Married 28
Promotional
Female Married 52
Female Married 44
Female Married 34
Female Married 56
Male Single 36
Female Single 42 Regular 30

Female Married 50
Frequency
0 10 20 30 40 50 60 70
 Regular 30

Female Married 44 Frequency

Female Married 58 0 10 20 30 40 50 60 70
Female Married 42
Female Married 46
Female Married 48
Female Married 54
Female Married 38
Female Married 60
Female Married 46
Female Married 30
Female Married 32
Female Married 46
Female Married 38
Male Married 68
Female Single 78
Female Single 20
Female Married 32
Female Married 38
Female Married 54
Female Married 48
Female Married 46
Female Single 50
Female Married 46
Female Single 30
Female Married 54
Female Single 42
Female Married 48
Female Married 62
Female Married 34
Female Married 28
Male Married 46
Female Married 54
Female Married 30
Female Married 32
Female Single 22
Female Married 32
Female Married 74
Female Married 62
Female Married 42
Female Married 28
Female Married 38
Female Married 54
Female Married 68
Female Single 30
Female Married 36
Female Married 44
Female Married 44
Female Married 62
Female Single 48
Female Married 36
Female Single 20
Female Married 42
Female Married 54
Female Married 54
Female Married 72
Female Married 30
Female Married 46
Female Married 44
Female Married 30
Female Married 52
Female Married 30
Female Married 44
 table for qualitative vảiable
e: Type of Customer
Frequency

s who did not use voucher where as 70 customers who use vouchers

hart or pie chart

e for Method of payment

cumulative
70.00
84.00
94.00
98.00
100.00

equency

70

Frequency
40 50 60 70 80
Frequency
40 50 60 70 80