STATISTICAL TECHNIQUES AND DATA ANALYSIS
CASE STUDY MAX MARKS : 35
Note:
(1) It is an individual assignment.
(2) You are encouraged to use the statistical software.
(3) Plagiarism will attract penalty.
(4) Write a
ief managerial report based on the analysis made.
PELICAN Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named PELICANSTORES. The proprietary card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are refe
ed to as promotional customers and customers who made a purchase but did not use a discount coupon are refe
ed as regular customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sale made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. ( NOTE: Items denotes the total number of items purchased and Net sales denotes the total amount ($) charged to the credit card.
Analyze and prepare a managerial report to help management develop a customer profile and evaluate the promotional campaign.
Data
Customer Method of Payment Items Discount Sales Gender Marital Status Age
1 Discover 1 0.00 39.50 Male Ma
ied 32
2 Proprietary Card 1 25.60 102.40 Female Ma
ied 36
3 Proprietary Card 1 0.00 22.50 Female Ma
ied 32
4 Proprietary Card 5 121.10 100.40 Female Ma
ied 28
5 Mastercard 2 0.00 54.00 Female Ma
ied 34
6 Mastercard 1 0.00 44.50 Female Ma
ied 44
7 Proprietary Card 2 19.50 78.00 Female Ma
ied 30
8 Visa 1 0.00 22.50 Female Ma
ied 40
9 Proprietary Card 2 22.48 56.52 Female Ma
ied 46
10 Proprietary Card 1 0.00 44.50 Female Ma
ied 36
11 Proprietary Card 1 0.00 29.50 Female Ma
ied 48
12 Proprietary Card 1 7.90 31.60 Female Ma
ied 40
13 Visa 9 103.60 160.40 Female Ma
ied 40
14 Visa 2 24.50 64.50 Female Ma
ied 46
15 Visa 1 0.00 49.50 Male Single 24
16 Proprietary Card 2 12.60 71.40 Male Single 36
17 Proprietary Card 3 53.00 94.00 Female Single 22
18 Discover 3 0.00 54.50 Female Ma
ied 40
19 Mastercard 2 19.00 38.50 Female Ma
ied 32
20 Proprietary Card 6 32.20 44.80 Female Ma
ied 56
21 Proprietary Card 1 7.90 31.60 Female Single 28
22 Proprietary Card 4 29.67 70.82 Female Ma
ied 38
23 American Express 7 66.50 266.00 Female Ma
ied 50
24 Proprietary Card 2 0.00 74.00 Female Ma
ied 42
25 Visa 2 14.50 39.50 Male Ma
ied 48
26 Proprietary Card 1 9.48 30.02 Female Ma
ied 60
27 Proprietary Card 1 0.00 44.50 Female Ma
ied 54
28 Proprietary Card 5 48.20 192.80 Female Single 42
29 Proprietary Card 3 37.30 71.20 Female Ma
ied 32
30 Proprietary Card 1 4.50 18.00 Female Ma
ied 70
31 Mastercard 2 15.80 63.20 Female Ma
ied 28
32 Proprietary Card 1 0.00 75.00 Female Ma
ied 52
33 Proprietary Card 3 15.80 63.20 Female Ma
ied 44
34 Proprietary Card 1 0.00 40.00 Female Ma
ied 34
35 Mastercard 5 10.00 105.50 Female Ma
ied 56
36 Mastercard 1 0.00 29.50 Male Single 36
37 Visa 2 0.00 102.50 Female Single 42
38 Proprietary Card 6 14.50 117.50 Female Ma
ied 50
39 Proprietary Card 5 25.02 13.23 Female Ma
ied 44
40 Proprietary Card 2 0.00 52.50 Female Ma
ied 58
41 Proprietary Card 13 62.70 198.80 Female Ma
ied 42
42 Visa 4 16.50 19.50 Female Ma
ied 46
43 Proprietary Card 2 0.00 123.50 Female Ma
ied 48
44 Proprietary Card 1 15.60 62.40 Female Ma
ied 54
45 Proprietary Card 2 35.20 23.80 Female Ma
ied 38
46 Proprietary Card 2 19.40 39.60 Female Ma
ied 60
47 Mastercard 1 0.00 25.00 Female Ma
ied 46
48 Proprietary Card 3 20.11 63.64 Female Ma
ied 30
49 Proprietary Card 1 4.68 14.82 Female Ma
ied 32
50 Mastercard 9 94.30 145.20 Female Ma
ied 46
51 Proprietary Card 6 58.88 176.62 Female Ma
ied 38
52 Proprietary Card 5 51.70 118.80 Male Ma
ied 68
53 Discover 1 0.00 58.00 Female Single 78
54 Visa 2 0.00 74.00 Female Single 20
55 Mastercard 2 0.00 49.50 Female Ma
ied 32
56 Proprietary Card 3 35.40 141.60 Female Ma
ied 38
57 Proprietary Card 6 56.40 123.10 Female Ma
ied 54
58 Proprietary Card 2 20.10 80.40 Female Ma
ied 48
59 Mastercard 4 28.30 65.20 Female Ma
ied 46
60 Proprietary Card 4 19.50 113.00 Female Single 50
61 Proprietary Card 1 19.20 108.80 Female Ma
ied 46
62 Proprietary Card 3 91.48 59.91 Female Single 30
63 Proprietary Card 5 37.40 53.60 Female Ma
ied 54
64 Proprietary Card 1 7.90 31.60 Female Single 42
65 Proprietary Card 2 9.50 49.50 Female Ma
ied 48
66 Proprietary Card 1 9.90 39.60 Female Ma
ied 62
67 Proprietary Card 2 29.50 59.50 Female Ma
ied 34
68 Proprietary Card 5 36.70 146.80 Female Ma
ied 28
69 Proprietary Card 2 11.80 47.20 Male Ma
ied 46
70 Proprietary Card 8 18.95 95.05 Female Ma
ied 54
71 Proprietary Card 5 57.18 155.32 Female Ma
ied 30
72 Mastercard 4 10.00 58.00 Female Ma
ied 32
73 Proprietary Card 1 0.00 69.00 Female Single 22
74 Proprietary Card 2 15.50 46.50 Female Ma
ied 32
75 Proprietary Card 2 14.28 45.22 Female Ma
ied 74
76 Proprietary Card 4 46.26 84.74 Female Ma
ied 62
77 Proprietary Card 2 0.00 39.00 Female Ma
ied 42
78 Proprietary Card 4 35.11 111.14 Female Ma
ied 28
79 Proprietary Card 3 31.20 86.80 Female Ma
ied 38
80 Discover 2 0.00 89.00 Female Ma
ied 54
81 Mastercard 2 19.50 78.00 Female Ma
ied 68
82 Proprietary Card 6 29.31 53.20 Female Single 30
83 Visa 4 14.50 58.50 Female Ma
ied 36
84 Proprietary Card 3 19.50 46.00 Female Ma
ied 44
85 Visa 2 0.00 37.50 Female Ma
ied 44
86 Proprietary Card 1 5.20 20.80 Female Ma
ied 62
87 Mastercard 6 0.00 144.00 Female Single 48
88 Proprietary Card 4 0.00 107.00 Female Ma
ied 36
89 Proprietary Card 1 7.90 31.60 Female Single 20
90 Proprietary Card 6 46.40 57.60 Female Ma
ied 42
91 Proprietary Card 4 158.30 95.20 Female Ma
ied 54
92 Proprietary Card 1 7.08 22.42 Female Ma
ied 54
93 Proprietary Card 5 0.00 159.75 Female Ma
ied 72
94 Proprietary Card 17 33.00 229.50 Female Ma
ied 30
95 American Express 3 0.00 66.00 Female Ma
ied 46
96 Mastercard 1 0.00 39.50 Female Ma
ied 44
97 Proprietary Card 9 82.75 253.00 Female Ma
ied 30
98 Proprietary Card 10 18.00 287.59 Female Ma
ied 52
99 Proprietary Card 2 31.40 47.60 Female Ma
ied 30
100 Proprietary Card 1 11.06 28.44 Female Ma
ied 44
Sheet2
Sheet3