Scribd
Upload
75 views26 pages

PelicanStores QM

The document contains sales data for 100 customers including type of customer (regular or promotional), items purchased, net sales, payment method, gender, marital status and age. Most customers were female (93%), married (84%) and made purchases as promotional customers (74%). Net sales ranged from $13.23 to $287.59.

Uploaded by

Phuntru Phi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
75 views26 pages

PelicanStores QM

The document contains sales data for 100 customers including type of customer (regular or promotional), items purchased, net sales, payment method, gender, marital status and age. Most customers were female (93%), married (84%) and made purchases as promotional customers (74%). Net sales ranged from $13.23 to $287.59.

Uploaded by

Phuntru Phi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 26

Custome Type of Method of Marital

r Customer Items Net Sales Payment Gender 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 ExpressFemale 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 ExpressFemale 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
male 7
female 93

married 84
single 16
Type of
Customer Net Sales
Regular 39.50
Promotional 102.40 Count of Net Sales Net Sales
Regular 22.50 Type of Customer 13.23-38.23
Promotional 100.40 Promotional 13
Regular 54.00 Regular 6
Regular 44.50 Total Result 19
Promotional 78.00
Regular 22.50
Promotional 56.52 40
Regular 44.50
35
Regular 29.50
Promotional 31.60 30
Promotional 160.40
25
Promotional 64.50
Regular 49.50 20
Promotional 71.40
15
Promotional 94.00
Regular 54.50 10
Promotional 38.50
5
Promotional 44.80
Promotional 31.60 0
Promotional Regu
Promotional 70.82
Promotional 266.00
Regular 74.00
Promotional 39.50
Promotional 30.02
Regular 44.50
Promotional 192.80
Promotional 71.20
Promotional 18.00
Promotional 63.20
Regular 75.00
Promotional 63.20
Regular 40.00
Promotional 105.50
Regular 29.50
Regular 102.50
Promotional 117.50
Promotional 13.23
Regular 52.50
Promotional 198.80
Promotional 19.50
Regular 123.50
Promotional 62.40
Promotional 23.80
Promotional 39.60
Regular 25.00
Promotional 63.64
Promotional 14.82
Promotional 145.20
Promotional 176.62
Promotional 118.80
Regular 58.00
Regular 74.00
Regular 49.50
Promotional 141.60
Promotional 123.10
Promotional 80.40
Promotional 65.20
Promotional 113.00
Promotional 108.80
Promotional 59.91
Promotional 53.60
Promotional 31.60
Promotional 49.50
Promotional 39.60
Promotional 59.50
Promotional 146.80
Promotional 47.20
Promotional 95.05
Promotional 155.32
Promotional 58.00
Regular 69.00
Promotional 46.50
Promotional 45.22
Promotional 84.74
Regular 39.00
Promotional 111.14
Promotional 86.80
Regular 89.00
Promotional 78.00
Promotional 53.20
Promotional 58.50
Promotional 46.00
Regular 37.50
Promotional 20.80
Regular 144.00
Regular 107.00
Promotional 31.60
Promotional 57.60
Promotional 95.20
Promotional 22.42
Regular 159.75
Promotional 229.50
Regular 66.00
Regular 39.50
Promotional 253.00
Promotional 287.59
Promotional 47.60
Promotional 28.44
38.23-63.23 63.23-88.23 88.23-113.23 113.23-138.23 138.23-163.23 163.23-188.23 188.23-213.23
22 11 9 3 5 1 2
13 5 3 1 2
35 16 12 4 7 1 2

40

35
Net Sales 13.23-38.23
30 38.23-63.23
63.23-88.23
25 88.23-113.23
113.23-138.23
20 138.23-163.23
163.23-188.23
15 188.23-213.23
213.23-238.23
10 238.23-263.23
263.23-288.23
5

0
Promotional Regular Total Result
213.23-238.23 238.23-263.23 263.23-288.23 Total Result
1 1 2 70
30
1 1 2 100
Type of
Custome
r Net Sales
Regular 39.50
Promotiona 102.40
Regular 22.50
Promotiona 100.40
Regular 54.00
Regular 44.50
Promotiona 78.00
Regular 22.50
Promotiona 56.52
Regular 44.50
Regular 29.50
Promotiona 31.60
Promotiona 160.40
Promotiona 64.50
Regular 49.50
Promotiona 71.40
Promotiona 94.00
Regular 54.50
Promotiona 38.50
Promotiona 44.80
Promotiona 31.60
Promotiona 70.82
Promotiona 266.00
Regular 74.00
Promotiona 39.50
Promotiona 30.02
Regular 44.50
Promotiona 192.80
Promotiona 71.20
Promotiona 18.00
Promotiona 63.20
Regular 75.00
Promotiona 63.20
Regular 40.00
Promotiona 105.50
Regular 29.50
Regular 102.50
Promotiona 117.50
Promotiona 13.23
Regular 52.50
Promotiona 198.80
Promotiona 19.50
Regular 123.50
Promotiona 62.40
Promotiona 23.80
Promotiona 39.60
Regular 25.00
Promotiona 63.64
Promotiona 14.82
Promotiona 145.20
Promotiona 176.62
Promotiona 118.80
Regular 58.00
Regular 74.00
Regular 49.50
Promotiona 141.60
Promotiona 123.10
Promotiona 80.40
Promotiona 65.20
Promotiona 113.00
Promotiona 108.80
Promotiona 59.91
Promotiona 53.60
Promotiona 31.60
Promotiona 49.50
Promotiona 39.60
Promotiona 59.50
Promotiona 146.80
Promotiona 47.20
Promotiona 95.05
Promotiona 155.32
Promotiona 58.00
Regular 69.00
Promotiona 46.50
Promotiona 45.22
Promotiona 84.74
Regular 39.00
Promotiona 111.14
Promotiona 86.80
Regular 89.00
Promotiona 78.00
Promotiona 53.20
Promotiona 58.50
Promotiona 46.00
Regular 37.50 Net Sales
350.00

300.00
Net Sales
Promotiona 20.80 350.00
Regular 144.00
300.00
Regular 107.00
Promotiona 31.60 250.00
Promotiona 57.60
200.00
Promotiona 95.20
Promotiona 22.42 150.00
Regular 159.75 100.00
Promotiona 229.50 f(x) = 0.349704350435043 x + 59.9404303030303
Regular 66.00 50.00

Regular 39.50 0.00


Promotiona 253.00 0 20 40 60 80

Promotiona 287.59
Promotiona 47.60
Promotiona 28.44
Net Sales
Net Sales

43 x + 59.9404303030303

40 60 80 100 120
Net Sales
39.50 Net Sales Count of Net Sales
102.40 13.23-23.23 8
22.50 23.23-33.23 10
100.40 33.23-43.23 9
54.00 43.23-53.23 14
44.50 53.23-63.23 13
78.00 63.23-73.23 8
22.50 73.23-83.23 6
56.52 83.23-93.23 3
44.50 93.23-103.23 6
29.50 103.23-113.23 5
31.60 113.23-123.23 3
160.40 123.23-133.23 1
64.50 133.23-143.23 1
49.50 143.23-153.23 3
71.40 153.23-163.23 3
94.00 173.23-183.23 1
54.50 183.23-193.23 1
38.50 193.23-203.23 1
44.80 223.23-233.23 1
31.60 243.23-253.23 1
70.82 263.23-273.23 1
266.00 283.23-293.23 1
74.00 Total Result 100
39.50
30.02
44.50
192.80
71.20
18.00
63.20
75.00
63.20
40.00
105.50
29.50
102.50
117.50
13.23
52.50
198.80
19.50
123.50
62.40
23.80
39.60
25.00
63.64
14.82
145.20
176.62
118.80
58.00
74.00
49.50
141.60
123.10
80.40
65.20
113.00
108.80
59.91
53.60
31.60
49.50
39.60
59.50
146.80
47.20
95.05
155.32
58.00
69.00
46.50
45.22
84.74
39.00
111.14
86.80
89.00
78.00
53.20
58.50
46.00
37.50
20.80
144.00
107.00
31.60
57.60
95.20
22.42
159.75
229.50
66.00
39.50
253.00
287.59
47.60
28.44
Total
120

100

80

60
Count of Net Sales
40

20

0
3 3 3 3 3 3 3 3 3 3 3 t
3 .2 3.2 3.2 3.2 3.2 3.2 3.2 3.2 3.2 3.2 3.2 sul
2 -4 6 8 10 1 2 4 6 9 3 7 e
3- 3 3- 3- - - - 1 - 1 -1 -2 -2 l R
3.2 3.2 3.2 3.2 .23 .23 .23 .23 .23 .23 .23 ota
1 3 5 7 93 13 33 53 83 23 63 T
1 1 1 1 2 2
Method of
Payment PAYMENT Frequency
Discover Discover 4
Proprietary Card Proprietary Card 70
Proprietary Card MasterCard 14
Proprietary Card Visa 10
MasterCard American Express 2
MasterCard
Proprietary Card
Visa Chart Title
Proprietary Card 80
Proprietary Card 70
Proprietary Card 60
Proprietary Card 50
Visa Axis Title 40
Visa 30
Visa 20
Proprietary Card 10
Proprietary Card 0
Discover Proprietary MasterCard Visa American
Discover Card Express
MasterCard
Axis Title
Proprietary Card
Proprietary Card
Proprietary Card
American Express
Proprietary Card
Visa
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
MasterCard
MasterCard
Visa
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Visa
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
Discover
Visa
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Discover
MasterCard
Proprietary Card
Visa
Proprietary Card
Visa
Proprietary Card
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
American Express
MasterCard
Proprietary Card
Proprietary Card
Proprietary Card
Proprietary Card
Visa American
Express
Age
32
36 Age Count of Age
32 20-29 10
28 30-39 30
34 40-49 33
44 50-59 16
30 60-69 7
40 70-79 4
46 Total Result 100
36
48
40
40
46
24
36
22
40
32
56
28
38
50
42
48
60
54
42
32
70
28
52
44
34
56
36
42
50
44
58
42
46
48
54
38
60
46
30
32
46
38
68
78
20
32
38
54
48
46
50
46
30
54
42
48
62
34
28
46
54
30
32
22
32
74
62
42
28
38
54
68
30
36
44
44
62
48
36
20
42
54
54
72
30
46
44
30
52
30
44
Age Count of Age
20-29 10
30-39 30
40-49 33
50-59 16
60-69 7
70-79 4
Total Result 100

You might also like