Average - Net Sales Method of Payment

Gender Marital Status American Discover MasterCard Propri

Female 166.00 67.17 70.01 80.32
Married 166.00 71.75 63.84 81.12
Single 58.00 144.00 75.19
Male 39.50 29.50 79.13
Married 39.50 83.00
Single 29.50 71.40
Total Result 166.00 60.25 67.11 80.27
180.00166.00
166.00 166.00
160.00 144.00
140.00
Marital Status
120.00
Method of Payment
100.00 American Express
80.3281.1275.1979.1383.00 80.27
70.0171.75
80.00 67.17 63.84
71.4067.11 Discover
58.00 60.25
60.00 MasterCard
39.5039.50
40.00 29.50 29.50 Proprietary Card
20.00
0.00
Female Male Total Result
Visa Total Result
67.43 79.19
60.48 78.87
88.25 81.17
44.50 56.49
39.50 61.25
49.50 50.13
62.84 77.60
 Method of Marital
Customer Type of 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 Min Age
3 Regular 1 22.50 Proprietary Card Female Married 32 Max Age
4 Promotional 5 100.40 Proprietary Card Female Married 28
5 Regular 2 54.00 MasterCard Female Married 34 Min Net sales
6 Regular 1 44.50 MasterCard Female Married 44 Max Net sales
7 Promotional 2 78.00 Proprietary Card Female Married 30 Average
8 Regular 1 22.50 Visa Female Married 40 Median
9 Promotional 2 56.52 Proprietary Card Female Married 46 Mode
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
 20
78

13.23
287.59
43.08
42
46
Age This chart isn't available in your version of Excel.
32
36 Editing this shape or saving this workbook into a different file format will permanently
break the chart.
32
28
34
44
30
40
46
36
48
40
40
46
24
36 Average 43.08
22 Median 42
40 Mode 46
32 Standard Deviation 12.39
56 Variance 153.488485
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
 This chart isn't available in your version of Excel.

manently Editing this shape or saving this workbook into a different file format will
permanently break the chart.
Age Count - Age
20-34 29
Total
35-49 44
29
50-64 21
65-79 6
20-34
Total Result 100
35-49
50-64
100 44 65-79
Total Result

21
6

Total
120

100

80
Count - Age
60

40

20

0
20-34 35-49 50-64 65-79 Total Result
 20-34
35-49
50-64
65-79
Total Result

Count - Age

sult
How many female users hold american express cards?
Cross Table
Count - Method of Payment Method of Payment
Gender American Express Discover MasterCard Proprietary Card Visa
Female 2 3 13 67 8
Male 1 1 3 2
Total Result 2 4 14 70 10
80

70

60

50 Method of Payment
American Express
40 Discover
MasterCard
30 Proprietary Card
Visa
20

10

0
Female Male Total Result
 Total Result
93
7
100

Method of Payment
American Express
Discover
MasterCard
Proprietary Card
Visa
Age Net Sales
32 39.50 Bivariate analysis
36 102.40 -0.010636
32 22.50
28 100.40 Net Sales
34 54.00 350.00
44 44.50 300.00
30 78.00 250.00
40 22.50

Net Sales
200.00
46 56.52
36 44.50 150.00

48 29.50 100.00
40 31.60 50.00
40 160.40
0.00
46 64.50 10 20 30 40 50 60 70
24 49.50 Age
36 71.40
22 94.00
40 54.50
32 38.50
56 44.80
28 31.60
38 70.82
50 266.00
42 74.00
48 39.50
60 30.02
54 44.50
42 192.80
32 71.20
70 18.00
28 63.20
52 75.00
44 63.20
34 40.00
56 105.50
36 29.50
42 102.50
50 117.50
44 13.23
58 52.50
42 198.80
46 19.50
48 123.50
54 62.40
38 23.80
60 39.60
46 25.00
30 63.64
32 14.82
46 145.20
38 176.62
68 118.80
78 58.00
20 74.00
32 49.50
38 141.60
54 123.10
48 80.40
46 65.20
50 113.00
46 108.80
30 59.91
54 53.60
42 31.60
48 49.50
62 39.60
34 59.50
28 146.80
46 47.20
54 95.05
30 155.32
32 58.00
22 69.00
32 46.50
74 45.22
62 84.74
42 39.00
28 111.14
38 86.80
54 89.00
68 78.00
30 53.20
36 58.50
44 46.00
44 37.50
62 20.80
48 144.00
36 107.00
20 31.60
42 57.60
54 95.20
54 22.42
72 159.75
30 229.50
46 66.00
44 39.50
30 253.00
52 287.59
30 47.60
44 28.44
 Net Sales

0 40 50 60 70 80 90
Age
Marital Status Average - Net Sales
Average of Net sales
Married 78.03
78.5
Single 75.35 78
78.0290476190476
77.6005
Total Result 77.60 77.5

Average Net Sales

77
76.5
76
75.5 75.350625
75
74.5
74
Married Single Total Result

Marital Status
es

77.6005

Total Result
Gender Sum - Items Sum of items purchased
Female 308
Male 14
Total Result 322

Total Result; Female; 308 Female

322 Male
Total Result

Male; 14
308 Female
Male
Total Result
Gender Average - Net Sales
Female 79.19 Average Net sales
Male 56.49
90
Total Result 77.60 79.1897849462366 77.6005
80
70
56.4857142857143

Average Net Sales

60
50
40
30
20
10
0
F em al e Mal e To t al R esu l t

Gender
 77.6005

To t al R esu l t
Method of PaymentCount - Items
American Express 2
Discover 4
MasterCard 14
Proprietary Card 70
Visa 10
Total Result 100

TYPES OF CARDS
N o. of ca rd users

USED 100
70
241410
0

Types of cards
Type of Customer Count - Type of Customer
Promotional 70
Regular 30
Total Result 100
No. of custom ers

Types of Customers
100
070
30
Types of customers
Method of Payment Sum - Net Sales
American Express 332.00 Net sales
Discover 241.00
MasterCard 939.60 Total Result
Proprietary Card 5619.05
Visa 628.40
Visa 628.4
Total Result 7760.05

Method of payment
Proprietary Card 5619.05

MasterCard 939.6

Discover 241

American Express 332

0 1000 2000 3000 4000 5000 6000 7

Sum of Net sales

 Net sales

7760.05

5619.05

0 3000 4000 5000 6000 7000 8000 9000

Sum of Net sales

 Case study: Pelican Stores_Set 1
Topics addressed:
Variables, measures of scale, graphs/data visualization

Questions:
1.       List out variables in the dataset
2.       Identify the measurement of scale for each variable
3.       Identify any one summary measure for each of these variables
4.       Which graph would be appropriate if you are to represent these variables graphically?

Case study: Pelican Stores_Set 2

Topics addressed:
Measures of central tendency, Measures of dispersion

Questions:
Calculate the following with regard to the quantity/items purchased
1. Average quantity purchased by customers
2. Mean, median& mode of quantity purchased
3. Minimum quantity purchased
4. Maximum quantity purchased
5. Range of quantity purchased
6. Standard deviation of quantity purchased
7. Variance
8. Ram, the store manager assumes that 50% of the purchases is below 10. Is this correct?
9. Ram, the store manager assumes that 25% of the purchases is below 10. Is this correct?
10. Rio finds that 25th percentile is 1. What does it mean?
11. Is the distribution skewed?
12. Identify the five point summary for the quantity purchased. Also interpret the same.