0% found this document useful (0 votes)
28 views10 pages

Pelican Stores - Dataset

The document contains a detailed analysis of customer transactions, including types of customers, items purchased, net sales, payment methods, gender, and marital status. It provides statistical summaries such as counts, means, and distributions for various demographics and sales metrics. Additionally, it includes histograms and other visual representations of the data.

Uploaded by

ziddibcha18
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
0% found this document useful (0 votes)
28 views10 pages

Pelican Stores - Dataset

The document contains a detailed analysis of customer transactions, including types of customers, items purchased, net sales, payment methods, gender, and marital status. It provides statistical summaries such as counts, means, and distributions for various demographics and sales metrics. Additionally, it includes histograms and other visual representations of the data.

Uploaded by

ziddibcha18
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/ 10

Type of Customer Items Net Sales Method of Payment Gender Marital Status

Regular 1 39.5 Discover Male Married


Promotional 1 102.4 Proprietary Card Female Married
Regular 1 22.5 Proprietary Card Female Married
Promotional 5 100.4 Proprietary Card Female Married
Regular 2 54 MasterCard Female Married
Regular 1 44.5 MasterCard Female Married
Promotional 2 78 Proprietary Card Female Married
Regular 1 22.5 Visa Female Married
Promotional 2 56.52 Proprietary Card Female Married
Regular 1 44.5 Proprietary Card Female Married
Regular 1 29.5 Proprietary Card Female Married
Promotional 1 31.6 Proprietary Card Female Married
Promotional 9 160.4 Visa Female Married
Promotional 2 64.5 Visa Female Married
Regular 1 49.5 Visa Male Single
Promotional 2 71.4 Proprietary Card Male Single
Promotional 3 94 Proprietary Card Female Single
Regular 3 54.5 Discover Female Married
Promotional 2 38.5 MasterCard Female Married
Promotional 6 44.8 Proprietary Card Female Married
Promotional 1 31.6 Proprietary Card Female Single
Promotional 4 70.82 Proprietary Card Female Married
Promotional 7 266 American Express Female Married
Regular 2 74 Proprietary Card Female Married
Promotional 2 39.5 Visa Male Married
Promotional 1 30.02 Proprietary Card Female Married
Regular 1 44.5 Proprietary Card Female Married
Promotional 5 192.8 Proprietary Card Female Single
Promotional 3 71.2 Proprietary Card Female Married
Promotional 1 18 Proprietary Card Female Married
Promotional 2 63.2 MasterCard Female Married
Regular 1 75 Proprietary Card Female Married
Promotional 3 63.2 Proprietary Card Female Married
Regular 1 40 Proprietary Card Female Married
Promotional 5 105.5 MasterCard Female Married
Regular 1 29.5 MasterCard Male Single
Regular 2 102.5 Visa Female Single
Promotional 6 117.5 Proprietary Card Female Married
Promotional 5 13.23 Proprietary Card Female Married
Regular 2 52.5 Proprietary Card Female Married
Promotional 13 198.8 Proprietary Card Female Married
Promotional 4 19.5 Visa Female Married
Regular 2 123.5 Proprietary Card Female Married
Promotional 1 62.4 Proprietary Card Female Married
Promotional 2 23.8 Proprietary Card Female Married
Promotional 2 39.6 Proprietary Card Female Married
Regular 1 25 MasterCard Female Married
Promotional 3 63.64 Proprietary Card Female Married
Promotional 1 14.82 Proprietary Card Female Married
Promotional 9 145.2 MasterCard Female Married
Promotional 6 176.62 Proprietary Card Female Married
Promotional 5 118.8 Proprietary Card Male Married
Regular 1 58 Discover Female Single
Regular 2 74 Visa Female Single
Regular 2 49.5 MasterCard Female Married
Promotional 3 141.6 Proprietary Card Female Married
Promotional 6 123.1 Proprietary Card Female Married
Promotional 2 80.4 Proprietary Card Female Married
Promotional 4 65.2 MasterCard Female Married
Promotional 4 113 Proprietary Card Female Single
Promotional 1 108.8 Proprietary Card Female Married
Promotional 3 59.91 Proprietary Card Female Single
Promotional 5 53.6 Proprietary Card Female Married
Promotional 1 31.6 Proprietary Card Female Single
Promotional 2 49.5 Proprietary Card Female Married
Promotional 1 39.6 Proprietary Card Female Married
Promotional 2 59.5 Proprietary Card Female Married
Promotional 5 146.8 Proprietary Card Female Married
Promotional 2 47.2 Proprietary Card Male Married
Promotional 8 95.05 Proprietary Card Female Married
Promotional 5 155.32 Proprietary Card Female Married
Promotional 4 58 MasterCard Female Married
Regular 1 69 Proprietary Card Female Single
Promotional 2 46.5 Proprietary Card Female Married
Promotional 2 45.22 Proprietary Card Female Married
Promotional 4 84.74 Proprietary Card Female Married
Regular 2 39 Proprietary Card Female Married
Promotional 4 111.14 Proprietary Card Female Married
Promotional 3 86.8 Proprietary Card Female Married
Regular 2 89 Discover Female Married
Promotional 2 78 MasterCard Female Married
Promotional 6 53.2 Proprietary Card Female Single
Promotional 4 58.5 Visa Female Married
Promotional 3 46 Proprietary Card Female Married
Regular 2 37.5 Visa Female Married
Promotional 1 20.8 Proprietary Card Female Married
Regular 6 144 MasterCard Female Single
Regular 4 107 Proprietary Card Female Married
Promotional 1 31.6 Proprietary Card Female Single
Promotional 6 57.6 Proprietary Card Female Married
Promotional 4 95.2 Proprietary Card Female Married
Promotional 1 22.42 Proprietary Card Female Married
Regular 5 159.75 Proprietary Card Female Married
Promotional 17 229.5 Proprietary Card Female Married
Regular 3 66 American Express Female Married
Regular 1 39.5 MasterCard Female Married
Promotional 9 253 Proprietary Card Female Married
Promotional 10 287.59 Proprietary Card Female Married
Promotional 2 47.6 Proprietary Card Female Married
Promotional 1 28.44 Proprietary Card Female Married
Age Type of Customer Count of Type of Customer
32 Promotional 70
36 Regular 30
32 Total Result 100
28
34 Method of Payment Count of Method of Payment
44 American Express 2
30 Discover 4
40 MasterCard 14
46 Proprietary Card 70
36 Visa 10
48 Total Result 100
40
40 Gender Count of Gender
46 Female 93
24 Male 7
36 Total Result 100
22
40 Marital Status Count of Marital Status
32 Married 84
56 Single 16
28 Total Result 100
38
50 Items vs. Net Sales 0.755059390729548
42 Age vs. Items -0.0166154184022648
48 Age vs. Net Sales -0.010635891709416
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 Bins Bins Frequency
20 20 2
Mean 43.08 40 40 42
Standard Error 1.2389046971 60 60 47
Median 42 80 80 9
Mode 46 More 0
Standard Deviation 12.389046971
Sample Variance 153.48848485
Kurtosis 0.0663662424
Histogram
Skewness 0.5249530361 50
Range 58 45
Minimum 20 40
Maximum 78 35
Sum 4308
30

Frequency
Count 100
25
20
15
10
5
0
20 40 60 80
Bins

Net Sales Bins Bins Frequency


35 35 18
Mean 77.6005 70 70 41 45
Standard Error 5.566493843 105 105 18 40
Median 59.705 140 140 9
35
Mode 31.6 175 175 7
Standard Deviation 55.66493843 210 210 3 30
Sample Variance 3098.5853705 245 245 1
25
Frequency

Kurtosis 3.1499550285 280 280 2


Skewness 1.7149960933 315 315 1 20
Range 274.36 More 0
15
Minimum 13.23
Maximum 287.59 10
Sum 7760.05 5
Count 100
0
35 70

Items Bins Bin Frequency


3 3 66
Mean 3.22 6 6 26
Standard Error 0.2736140465 9 9 5
Median 2 12 12 1
Mode 1 15 15 1
Standard Deviation 2.7361404654 18 18 1
Sample Variance 7.4864646465 More 0 Histogram
Kurtosis 6.9924660586
70
Skewness 2.2370233356
Range 16
60
Minimum 1
Maximum 17
50
Sum 322
Count 100
Frequency 40

30

20

10

0
3 6 9 12 15
Bin
Histogram

Frequency

60 80 More
Bins

Histogram
45

40

35

30

25
Frequency

Frequency
20

15

10

0
35 70 105 140 175 210 245 280 315 More
Bins
togram

Column S

12 15 18 More
n

You might also like