Exam (elaborations) Consumer Data Analytics Business Analytics Sandhya, ISBN: 9789351341598 - Excel Solution

Transaction Customer Date Amount (in INR)
5651 1 2/Oct/20 2,516
17811 1 4/Apr/20 6,290
26627 1 16/Jan/20 4,292
31501 1 23/Aug/20 3,996
36487 1 25/Dec/17 3,774
40369 1 3/Sep/18 5,254
42085 1 17/Mar/19 2,294
67736 1 19/Mar/18 5,624
68207 1 20/Jun/17 4,070
74843 1 2/Aug/19 4,884
77248 1 1/Mar/17 3,774
87840 1 18/Nov/18 7,400
89150 1 6/May/17 6,734
89735 1 5/Jun/18 4,958
93075 1 10/Mar/18 3,478
5823 2 24/May/18 4,588
9192 2 27/Jun/18 6,660
10510 2 12/Apr/17 3,848
10953 2 18/Apr/19 6,068
16092 2 7/Jan/19 4,440
19454 2 10/Jul/17 6,512
20839 2 17/Apr/20 2,590
21141 2 13/Feb/20 6,808
29556 2 26/Sep/19 3,552
40039 2 28/Oct/20 5,402
48006 2 16/Dec/17 5,994
54462 2 26/Aug/18 5,180
56064 2 23/Nov/18 6,808
58039 2 28/Oct/20 6,882
61169 2 24/Mar/19 6,734
63552 2 2/Oct/20 2,886
68649 2 25/Jul/18 3,404
90481 2 13/Feb/17 6,586
96233 2 4/Mar/19 5,624
97925 2 6/Jan/20 2,294
2851 3 1/Nov/20 5,476
3147 3 17/Sep/19 7,400
6737 3 31/Aug/19 2,812
7942 3 6/Jun/17 5,698
23569 3 1/Apr/17 5,328
26901 3 23/Oct/19 6,660
35556 3 19/Sep/20 6,660
36991 3 16/Apr/18 6,808
51297 3 5/Oct/18 3,478
56087 3 4/May/17 5,254

,57099 3 11/May/17 6,586
64948 3 19/May/20 3,034
69147 3 13/Feb/19 4,662
70088 3 20/May/20 3,922
72971 3 30/May/19 5,846
76125 3 13/Oct/19 6,586
83153 3 31/Aug/20 2,368
85992 3 7/Jun/17 6,808
96624 3 30/Jan/18 3,552
9208 4 10/Jan/18 3,922
9918 4 6/Apr/18 2,664
20248 4 28/Jan/19 6,290
22197 4 6/Dec/18 4,514
22782 4 5/Jul/19 4,810
23241 4 13/Mar/19 5,920
39767 4 28/Sep/19 4,810
42008 4 26/Dec/19 6,882
43307 4 7/Jun/19 5,032
46992 4 21/May/17 7,178
48779 4 7/Oct/18 6,586
49266 4 26/Jun/19 5,476
58175 4 29/May/17 4,958
61264 4 28/Apr/17 6,068
61571 4 20/Jan/18 6,142
61583 4 30/Oct/17 3,330
70864 4 24/Sep/17 4,366
74146 4 30/Nov/19 3,330
78016 4 4/Jul/18 7,326
78779 4 4/Mar/20 6,660
85686 4 14/Nov/17 4,662
87203 4 22/Nov/20 3,700
2811 5 1/Jun/17 4,292
11728 5 7/Dec/19 6,734
12361 5 13/May/20 6,290
26860 5 25/Feb/20 4,070
32521 5 23/Sep/18 3,996
38495 5 6/May/17 2,664
45248 5 22/Dec/17 5,550
58244 5 8/Apr/17 2,886
64546 5 16/Feb/20 2,590
68225 5 26/Oct/19 3,108
87360 5 12/May/18 2,960
88742 5 13/Mar/17 6,068
97761 5 2/Nov/17 7,400
3289 6 9/Apr/19 3,256
6056 6 11/Jan/20 3,774

,11866 6 5/Oct/17 4,144
15877 6 5/Feb/19 5,402
17335 6 6/Feb/17 6,882
22444 6 8/Mar/20 6,586
25393 6 23/Oct/19 3,774
26261 6 30/Sep/19 4,810
32146 6 21/Nov/19 6,068
56859 6 3/Apr/19 6,586
58448 6 18/Mar/20 4,514
59480 6 25/May/17 4,736
66794 6 19/Feb/17 3,034
73060 6 5/Nov/17 7,030
81374 6 23/Jan/19 4,588
99324 6 17/Oct/17 2,220
99395 6 10/Dec/18 3,996
4241 7 20/Dec/17 4,292
16104 7 4/Feb/17 2,812
21395 7 2/Jun/17 5,624
22675 7 1/Jul/20 6,512
27795 7 27/Aug/20 3,626
29614 7 28/Jun/19 5,328
40286 7 12/Nov/19 6,882
49855 7 1/Dec/20 4,070
50653 7 21/Nov/19 2,664
58502 7 7/Jan/20 3,034
59652 7 7/Nov/19 3,848
62806 7 26/Nov/19 3,552
66291 7 18/Nov/18 4,588
66624 7 22/Jun/20 7,104
87365 7 4/Mar/20 5,328
8372 8 12/Jul/18 6,068
19311 8 17/Nov/19 5,254
27330 8 15/Nov/19 6,512
30959 8 25/Mar/19 6,956
45459 8 1/Aug/20 2,294
52446 8 5/Jun/18 7,178
56798 8 6/Jan/20 4,514
62740 8 1/Jun/20 6,290
73599 8 9/Nov/18 3,256
75038 8 5/Jul/18 6,068
79509 8 19/Jul/19 6,364
79831 8 22/Nov/20 3,996
86264 8 11/Jun/20 6,142
87179 8 20/Jan/18 2,220
98105 8 16/Nov/17 7,030
5076 9 9/Nov/20 4,218

, 10563 9 11/Jan/19 7,030
13374 9 7/Jan/19 3,552
13963 9 30/May/17 5,994
16766 9 13/Jun/19 5,402
17370 9 18/Jun/17 4,440
23350 9 14/Mar/19 2,960
24445 9 7/May/18 4,736
28911 9 23/Nov/20 3,552
29051 9 3/Apr/17 7,400
31541 9 22/Sep/20 3,034
31568 9 5/Oct/20 3,034
37591 9 14/Jan/18 3,330
38746 9 10/Apr/19 5,920
42074 9 12/Jan/18 6,734
44307 9 31/Aug/19 3,256
55576 9 9/Mar/17 7,104
63498 9 25/Oct/17 5,772
68098 9 13/Aug/20 5,180
72413 9 12/Feb/17 3,552
77180 9 14/Apr/18 3,626
85832 9 28/Oct/20 5,846
93535 9 29/Aug/19 6,882
95280 9 28/Sep/20 2,664
3593 10 26/Jan/18 3,256
15374 10 7/Nov/19 2,812
15807 10 23/Jun/18 4,514
26933 10 29/Nov/18 4,588
34880 10 19/Sep/17 2,220
41008 10 11/Nov/18 3,330
43595 10 11/Sep/18 2,886
45718 10 4/Sep/18 4,144
47980 10 9/Dec/19 2,442
50907 10 24/Aug/17 2,590
58934 10 16/Feb/17 7,178
60899 10 8/Dec/18 2,590
61513 10 13/Dec/19 2,664
70805 10 24/Sep/19 3,774
72904 10 12/May/17 3,256
74668 10 22/Oct/20 2,368
75289 10 9/Mar/17 6,808
78726 10 12/Aug/18 5,550
80978 10 21/Jun/20 5,032
82704 10 8/Dec/18 6,142
83378 10 16/Mar/18 2,442
85702 10 23/Jan/18 7,326
86683 10 23/Nov/17 3,330