Scribd
Upload
79 views8 pages

Customer Purchase Data Analysis

The document contains sales data from 57 customers including customer information, items purchased, net sales, payment method, gender, marital status and age. There were 30 regular customers and 27 promotional customers who purchased items. The total net sales amount was $4308 and the average number of items purchased was 3.22.

Uploaded by

Preeti Singh
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
79 views8 pages

Customer Purchase Data Analysis

The document contains sales data from 57 customers including customer information, items purchased, net sales, payment method, gender, marital status and age. There were 30 regular customers and 27 promotional customers who purchased items. The total net sales amount was $4308 and the average number of items purchased was 3.22.

Uploaded by

Preeti Singh
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/ 8

Customer Type of Customer Items Net Sales Method of Payment Gender

1 Regular 1 39.5 Discover Male


96 Regular 1 39.5 MasterCard Female
3 Regular 1 22.5 Proprietary Card Female
95 Regular 3 66 American Express Female
5 Regular 2 54 MasterCard Female
6 Regular 1 44.5 MasterCard Female
93 Regular 5 159.75 Proprietary Card Female
8 Regular 1 22.5 Visa Female
88 Regular 4 107 Proprietary Card Female
10 Regular 1 44.5 Proprietary Card Female
11 Regular 1 29.5 Proprietary Card Female
87 Regular 6 144 MasterCard Female
85 Regular 2 37.5 Visa Female
80 Regular 2 89 Discover Female
15 Regular 1 49.5 Visa Male
77 Regular 2 39 Proprietary Card Female
73 Regular 1 69 Proprietary Card Female
18 Regular 3 54.5 Discover Female
55 Regular 2 49.5 MasterCard Female
54 Regular 2 74 Visa Female
53 Regular 1 58 Discover Female
47 Regular 1 25 MasterCard Female
43 Regular 2 123.5 Proprietary Card Female
24 Regular 2 74 Proprietary Card Female
40 Regular 2 52.5 Proprietary Card Female
37 Regular 2 102.5 Visa Female
27 Regular 1 44.5 Proprietary Card Female
36 Regular 1 29.5 MasterCard Male
34 Regular 1 40 Proprietary Card Female
32 Regular 1 75 Proprietary Card Female
Marital Status Age
Married 32
Married 44
Married 32
Married 46
Married 34
Married 44
Married 72
Married 40
Married 36
Married 36
Married 48
Single 48
Married 44
Married 54
Single 24
Married 42
Single 22
Married 40
Married 32
Single 20
Single 78
Married 46
Married 48
Married 42
Married 58
Single 42
Married 54
Single 36
Married 34
Married 52
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 Type ofCount of Customer
3 Regular 1 22.50 Proprietary Card Female Married 32 Promoti 70
4 Promotional 5 100.40 Proprietary Card Female Married 28 Regular 30
5 Regular 2 54.00 MasterCard Female Married 34 Total R###
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 Total
11 Regular 1 29.50 Proprietary Card Female Married 48
5000
12 Promotional 1 31.60 Proprietary Card Female Married 40
4500
13 Promotional 9 160.40 Visa Female Married 40
4000
14 Promotional 2 64.50 Visa Female Married 46
3500
15 Regular 1 49.50 Visa Male Single 24
3000 Sum of Age
16 Promotional 2 71.40 Proprietary Card Male Single 36
2500
17 Promotional 3 94.00 Proprietary Card Female Single 22
2000
18 Regular 3 54.50 Discover Female Married 40
1500
19 Promotional 2 38.50 MasterCard Female Married 32
1000
20 Promotional 6 44.80 Proprietary Card Female Married 56
500
21 Promotional 1 31.60 Proprietary Card Female Single 28
0
22 Promotional 4 70.82 Proprietary Card Female Married 38 4308
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 TypeAverage of Items
36 Regular 1 29.50 MasterCard Male Single 36 Total Prom 3.8
37 Regular 2 102.50 Visa Female Single 42 Regu1.87
38 Promotional 6 117.50 Proprietary Card Female Married 50 (empty)
39 Promotional 5 13.23 Proprietary Card Female Married 44 Total3.22
Promotional
40 Regular 2 52.50 Proprietary Card Female Married 58 Regular
41 Promotional 13 198.80 Proprietary Card Female Married 42 Total Result
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 Total
49 Promotional 1 14.82 Proprietary Card Female Married 32 4
50 Promotional 9 145.20 MasterCard Female Married 46 3.5
51 Promotional 6 176.62 Proprietary Card Female Married 38 3
52 Promotional 5 118.80 Proprietary Card Male Married 68 2.5
53 Regular 1 58.00 Discover Female Single 78 2 Average of
Items
54 Regular 2 74.00 Visa Female Single 20 1.5
55 Regular 2 49.50 MasterCard Female Married 32 1
56 Promotional 3 141.60 Proprietary Card Female Married 38 0.5
57 Promotional 6 123.10 Proprietary Card Female Married 54 0

lt
Re al
(e ar
tal ty)
su
n

l
gu
To mp
io

Re
ot
om
Pr
2 Average of
Items
1.5
1
0.5
0
58 Promotional 2 80.40 Proprietary Card Female Married 48

lt
Re al
(e ar
tal ty)
su
n

l
gu
To mp
io

Re
ot
59 Promotional 4 65.20 MasterCard Female Married 46 Age - all -

om
Pr
60 Promotional 4 113.00 Proprietary Card Female Single 50
61 Promotional 1 108.80 Proprietary Card Female Married 46 Sum of Age
62 Promotional 3 59.91 Proprietary Card Female Single 30 4308
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
Sum of Age
erage of Items

You might also like