*USE AN EXCEL SHEET* 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 coupo

*USE AN EXCEL SHEET*

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 in-store credit card transactions at pelican stores during one day while the promotion was running. the proprietary card method of payment refers to charges made on a national clothing charge card. customers who have made a purchase using a discount coupon are referred to promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because that promotional coupons were not sent to regular pelican stores customers, management considers the sales made to people presenting the promotional customers will continue to shop at its stores.

Pelican would like to use this same data to learn more about its customer base. As a clarification in a couple of variables: items: the total number of items purchased, Net sales: the total amount ($) charged to credit card.

You 2ill use descriptive statics to help management develop a customer profile and to elevate the promotional charge.

Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 3 Regular 1 22.50 Proprietary Card Female Married 32 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 1 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 8 Regular 1 22.50 Visa Female Married 40 9 Promotional 2 56.52 Proprietary Card Female Married 46 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 Express Female 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

A. For EACH variable in the data set, develop a percent frequency distribution table starting on row 14. Based on the tables you build, write down some observations in 3-6 sentences in the box below.

B. For the data provided, build three or four KEY numerical measures for the Net Sales. In 2-5 sentences, comment on what you can conclude from observing these measures in the box below.

C. Develop the average and standard deviation (and optionally, any other numerical measure that you think is useful) for net sales corresponding to different categorical descriptions of customers. What are some interesting observations.

D. Develop a cross-tabulation for type of customer versus net sales. Discuss any observations in the box below in 2-5 sentences.