Type of Method of Marital

Customer Items Net Sales Gender

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

Q-2:The distribution of Net Sales is Left Skewed.

Q-3: As can be seen from the scatter plot below, there are 3 outlier points

Net Sales
350.00

300.00

250.00

200.00

150.00

100.00

50.00

0.00
0 20 40 60 80

Q-4 The distribution for age seems like a bell curve distribution.
Please use slicer to switch between customer types.

Promotional Cust Data

Min 20
Mean 43.26
Median 43
Max
Q1 32
Q2 43
Q3 51.5

Q-5 Please use slicer to switch between cutomer types

Net sales across Categories
 Min 13.23
Mean 43.08
Median 42
Max 78
Q1 32
Q2 42
Q3 50

Q-6

Age vs Net Sales

90

80

70

60

50

40

30

20

10

0
0.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00
there are 3 outlier points above 225rs Net Sales.

80 100 120

rve distribution.

r to switch between cutomer types

Net sales Promotional Cust Net sales Regular Cust
 Min 13.23 Min
Mean 84.29 Mean
Median 63.42 Median
Max 287.59 Max
Q1 44.91 Q1
Q2 63.42 Q2
Q3 107.98 Q3

Correlation between age and Net Sales across categories:

-0.01
This indicates a very weak negative correlation between age and

250.00 300.00 350.00

 This chart isn’t available

Editing this shape or sav

permanently break the ch

s Regular Cust
 22.50
61.99
51.00
159.75
39.50
51.00
74.00

across categories:

relation between age and Net sales

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