Scribd
Upload
495 views14 pages

Pelican Stores Data

The document contains sales data from 100 customers with information on their type of customer (70% promotional, 30% regular), items purchased, sales amount, payment method and customer demographics. The majority of customers used a proprietary card (70%) and were female (93%). Most common ages were 46, 54, 30 and 32, and marital status was mostly married (84%).

Uploaded by

Nandini Nagabhushan
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
495 views14 pages

Pelican Stores Data

The document contains sales data from 100 customers with information on their type of customer (70% promotional, 30% regular), items purchased, sales amount, payment method and customer demographics. The majority of customers used a proprietary card (70%) and were female (93%). Most common ages were 46, 54, 30 and 32, and marital status was mostly married (84%).

Uploaded by

Nandini Nagabhushan
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/ 14

Custome

r Type of Customer Items Sales Method of Payment Gender


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

Marital Status Frequency Frequency %


Married 84 0.84
Single 16 0.16
Frequency % Age Frequency Frequency %
29.00% 46 9 0.09
27.00% 54 8 0.08
10.00% 30 8 0.08
10.00% 32 8 0.08
9.00% 44 7 0.07
7.00% 42 7 0.07
1.00% 36 6 0.06
1.00% 48 6 0.06
3.00% 38 5 0.05
1.00% 28 5 0.05
1.00% 40 4 0.04
1.00% 62 3 0.03
34 3 0.03
50 3 0.03
60 2 0.02
52 2 0.02
68 2 0.02
22 2 0.02
20 2 0.02
56 2 0.02
58 1 0.01
78 1 0.01
74 1 0.01
24 1 0.01
70 1 0.01
72 1 0.01
Method of Payment Frequency Frequency %
American Express 2 2.00% Frequency
Discover 4 4.00% 2
Mastercard 14 14.00% 10 4
Proprietary Card 70 70.00%
Visa 10 10.00% 14

70

American Express Discover Mastercard


Proprietary Card Visa
Frequency Frequency
2 80
10 4
70
14
60

50

Frequency
40

30

20
14

10
4
2
70 0
American Express Discover Mastercard Prop

American Express Discover Mastercard Method of payment


Proprietary Card Visa
Frequency

70

14
10
4
2

n Express Discover Mastercard Proprietary Card Visa

Method of payment
Type of Customer Sales
Promotional 5900.3
Regular 1859.75
Age Net Sales
20 105.6 Net Sale
22 163 1000
24 49.5 940.17
28 453.14 900
30 940.17
32 340.52 800
34 153.5
696.3
36 413.3 700
38 499.64 597.92
40 269 600
42 696.3
Net sales
499.64 49
44 272.37 500 453.14 466.4

46 597.92 413.3
400
48 466.4 340.52
50 496.5
300 269 272.37
52 362.59
54 585.27
200 163 153.5
56 150.3
105.6
58 52.5 100
49.5
60 69.62
62 145.14 0
10 20 30 40 5
68 196.8
70 18 Ag
72 159.75
74 45.22
78 58
Net Sales

696.3

597.92 585.27

499.64 496.5
466.4
413.3
362.59

269 272.37

196.8
5 150.3 145.14 159.75

69.62 58
52.5 45.22
18

40 50 60 70 80 90

Age

You might also like