AttachedSTATISTICAL TECHNIQUES AND DATA ANALYSIS CASE STUDY MAX MARKS : 35 Note: (1) It is an...

Question

AttachedSTATISTICAL 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 brief 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 referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred 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	Married	32 	2	Proprietary Card	1	25.60	102.40	Female	Married	36 	3	Proprietary Card	1	0.00	22.50	Female	Married	32 	4	Proprietary Card	5	121.10	100.40	Female	Married	28 	5	Mastercard	2	0.00	54.00	Female	Married	34 	6	Mastercard	1	0.00	44.50	Female	Married	44 	7	Proprietary Card	2	19.50	78.00	Female	Married	30 	8	Visa	1	0.00	22.50	Female	Married	40 	9	Proprietary Card	2	22.48	56.52	Female	Married	46 	10	Proprietary Card	1	0.00	44.50	Female	Married	36 	11	Proprietary Card	1	0.00	29.50	Female	Married	48 	12	Proprietary Card	1	7.90	31.60	Female	Married	40 	13	Visa	9	103.60	160.40	Female	Married	40 	14	Visa	2	24.50	64.50	Female	Married	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	Married	40 	19	Mastercard	2	19.00	38.50	Female	Married	32 	20	Proprietary Card	6	32.20	44.80	Female	Married	56 	21	Proprietary Card	1	7.90	31.60	Female	Single	28 	22	Proprietary Card	4	29.67	70.82	Female	Married	38 	23	American Express	7	66.50	266.00	Female	Married	50 	24	Proprietary Card	2	0.00	74.00	Female	Married	42 	25	Visa	2	14.50	39.50	Male	Married	48 	26	Proprietary Card	1	9.48	30.02	Female	Married	60 	27	Proprietary Card	1	0.00	44.50	Female	Married	54 	28	Proprietary Card	5	48.20	192.80	Female	Single	42 	29	Proprietary Card	3	37.30	71.20	Female	Married	32 	30	Proprietary Card	1	4.50	18.00	Female	Married	70 	31	Mastercard	2	15.80	63.20	Female	Married	28 	32	Proprietary Card	1	0.00	75.00	Female	Married	52 	33	Proprietary Card	3	15.80	63.20	Female	Married	44 	34	Proprietary Card	1	0.00	40.00	Female	Married	34 	35	Mastercard	5	10.00	105.50	Female	Married	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	Married	50 	39	Proprietary Card	5	25.02	13.23	Female	Married	44 	40	Proprietary Card	2	0.00	52.50	Female	Married	58 	41	Proprietary Card	13	62.70	198.80	Female	Married	42 	42	Visa	4	16.50	19.50	Female	Married	46 	43	Proprietary Card	2	0.00	123.50	Female	Married	48 	44	Proprietary Card	1	15.60	62.40	Female	Married	54 	45	Proprietary Card	2	35.20	23.80	Female	Married	38 	46	Proprietary Card	2	19.40	39.60	Female	Married	60 	47	Mastercard	1	0.00	25.00	Female	Married	46 	48	Proprietary Card	3	20.11	63.64	Female	Married	30 	49	Proprietary Card	1	4.68	14.82	Female	Married	32 	50	Mastercard	9	94.30	145.20	Female	Married	46 	51	Proprietary Card	6	58.88	176.62	Female	Married	38 	52	Proprietary Card	5	51.70	118.80	Male	Married	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	Married	32 	56	Proprietary Card	3	35.40	141.60	Female	Married	38 	57	Proprietary Card	6	56.40	123.10	Female	Married	54 	58	Proprietary Card	2	20.10	80.40	Female	Married	48 	59	Mastercard	4	28.30	65.20	Female	Married	46 	60	Proprietary Card	4	19.50	113.00	Female	Single	50 	61	Proprietary Card	1	19.20	108.80	Female	Married	46 	62	Proprietary Card	3	91.48	59.91	Female	Single	30 	63	Proprietary Card	5	37.40	53.60	Female	Married	54 	64	Proprietary Card	1	7.90	31.60	Female	Single	42 	65	Proprietary Card	2	9.50	49.50	Female	Married	48 	66	Proprietary Card	1	9.90	39.60	Female	Married	62 	67	Proprietary Card	2	29.50	59.50	Female	Married	34 	68	Proprietary Card	5	36.70	146.80	Female	Married	28 	69	Proprietary Card	2	11.80	47.20	Male	Married	46 	70	Proprietary Card	8	18.95	95.05	Female	Married	54 	71	Proprietary Card	5	57.18	155.32	Female	Married	30 	72	Mastercard	4	10.00	58.00	Female	Married	32 	73	Proprietary Card	1	0.00	69.00	Female	Single	22 	74	Proprietary Card	2	15.50	46.50	Female	Married	32 	75	Proprietary Card	2	14.28	45.22	Female	Married	74 	76	Proprietary Card	4	46.26	84.74	Female	Married	62 	77	Proprietary Card	2	0.00	39.00	Female	Married	42 	78	Proprietary Card	4	35.11	111.14	Female	Married	28 	79	Proprietary Card	3	31.20	86.80	Female	Married	38 	80	Discover	2	0.00	89.00	Female	Married	54 	81	Mastercard	2	19.50	78.00	Female	Married	68 	82	Proprietary Card	6	29.31	53.20	Female	Single	30 	83	Visa	4	14.50	58.50	Female	Married	36 	84	Proprietary Card	3	19.50	46.00	Female	Married	44 	85	Visa	2	0.00	37.50	Female	Married	44 	86	Proprietary Card	1	5.20	20.80	Female	Married	62 	87	Mastercard	6	0.00	144.00	Female	Single	48 	88	Proprietary Card	4	0.00	107.00	Female	Married	36 	89	Proprietary Card	1	7.90	31.60	Female	Single	20 	90	Proprietary Card	6	46.40	57.60	Female	Married	42 	91	Proprietary Card	4	158.30	95.20	Female	Married	54 	92	Proprietary Card	1	7.08	22.42	Female	Married	54 	93	Proprietary Card	5	0.00	159.75	Female	Married	72 	94	Proprietary Card	17	33.00	229.50	Female	Married	30 	95	American Express	3	0.00	66.00	Female	Married	46 	96	Mastercard	1	0.00	39.50	Female	Married	44 	97	Proprietary Card	9	82.75	253.00	Female	Married	30 	98	Proprietary Card	10	18.00	287.59	Female	Married	52 	99	Proprietary Card	2	31.40	47.60	Female	Married	30 	100	Proprietary Card	1	11.06	28.44	Female	Married	44 Sheet2 	 Sheet3

Mukesh · Accepted Answer

Sheet1
	
		Data
	Method of Payment	Sum of Discount	Sum of Sales	Sum of Items
	American Express	66.5	332	10
	Discover	0	241	7
	Mastercard	196.9	939.6	42
	Proprietary Card	1808.18	5619.05	234
	Visa	173.6	628.4	29
	Grand Total	2245.18	7760.05	322
Sheet4
	
	Count of Marital Status
	Marital Status	Total
	Married	84
	Single	16
Sheet4
	Married
	Single
Count of Marital Status Total
Count of Marital Status
84
16
Payment_sales_discount
	
		Data
	Method of Payment	Sum of Sales	Sum of Discount
	Proprietary Card	5619.05	1808.18
	Mastercard	939.6	196.9
	Visa	628.4	173.6
	American Express	332	66.5
	Discover	241	0
	Grand Total	7760.05	2245.18
Payment_sales_discount
	Proprietary Card	Proprietary Card
	Mastercard	Mastercard
	Visa	Visa
	American Express	American Express
	Discover	Discover
	Grand Total	Grand Total
Data Sum of Sales
Data Sum of Discount
5619.05
1808.18
939.6
196.9
628.4
173.6
332
66.5
241
0
7760.05
2245.18
Mode of payment
	
	Count of Method of Payment
	Method of Payment	Total
	American Express	2
	Discover	4
	Mastercard	14
	Proprietary Card	70
	Visa	10
Mode of payment
	American Express
	Discover
	Mastercard
	Proprietary Card
	Visa
Count of Method of Payment Total
Count of Method of Payment
2
4
14
70
10
Sheet5
	
		Data
	Costumer Type	Sum of Sales	Average of Sales
	New Costomers	5900.3	84.29
	Old Costomers	1859.75	61.9916666667
	Grand Total	7760.05	77.6005
Sheet6
	
				Data
	Method of Payment	Gender	Marital Status	Sum of Discount	Sum of Sales
	American Express	Female	Married	66.5	332
		Female Total		66.5	332
	American Express Total			66.5	332
	Discover	Female	Married	0	143.5
			Single	0	58
		Female Total		0	201.5
		Male	Married	0	39.5
		Male Total		0	39.5
	Discover Total			0	241
	Mastercard	Female	Married	196.9	766.1
			Single	0	144
		Female Total		196.9	910.1
		Male	Single	0	29.5
		Male Total		0	29.5
	Mastercard Total			196.9	939.6
	Proprietary Card	Female	Married	1466.89	4704.94
			Single	265.19	676.71
		Female Total		1732.08	5381.65
		Male	Married	63.5	166
			Single	12.6	71.4
		Male Total		76.1	237.4
	Proprietary Card Total			1808.18	5619.05
	Visa	Female	Married	159.1	362.9
			Single	0	176.5
		Female Total		159.1	539.4
		Male	Married	14.5	39.5
			Single	0	49.5
		Male Total		14.5	89
	Visa Total			173.6	628.4
	Grand Total			2245.18	7760.05
Sheet7
	
	Count of Marital Status
	Marital Status	Total
	Married	84
	Single	16
Sheet7
	Married
	Single
Count of Marital Status Total
Count of Marital Status
84
16
Data
	Customer	Method of Payment	Items	Discount	Sales	Gender	Marital Status	Age	Costumer Type
	1	Discover	1	0.00	39.50	Male	Married	32	1
	2	Proprietary Card	1	25.60	102.40	Female	Married	36	0		0.46388801
	3	Proprietary Card	1	0.00	22.50	Female	Married	32	1
	4	Proprietary Card	5	121.10	100.40	Female	Married	28	0
	5	Mastercard	2	0.00	54.00	Female	Married	34	1
	6	Mastercard	1	0.00	44.50	Female	Married	44	1
	7	Proprietary Card	2	19.50	78.00	Female	Married	30	0
	8	Visa	1	0.00	22.50	Female	Married	40	1
	9	Proprietary Card	2	22.48	56.52	Female	Married	46	0
	10	Proprietary Card	1	0.00	44.50	Female	Married	36	1
	11	Proprietary Card	1	0.00	29.50	Female	Married	48	1
	12	Proprietary Card	1	7.90	31.60	Female	Married	40	0
	13	Visa	9	103.60	160.

STATISTICAL TECHNIQUES AND DATA ANALYSISCASE STUDYMAX MARKS : 35Note:(1) It is an individual assignment.(2) You are encouraged to use the statistical software.(3) Plagiarism will...

Answer To: STATISTICAL TECHNIQUES AND DATA ANALYSISCASE STUDYMAX MARKS : 35Note:(1) It is an...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment