Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the USA. The chain recently ran a promotion 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 were collected in the file named PelicanStoresdata.xls found in this current module.
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 to as regular customers. (Management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make and would hopefully encourage those customers to return). (Adapted from 2013, "Essentials of Modern Business Statistics. With Microsoft Excel" from Engage Publishing)
1) Analyze the Net sales variable (only using that variable). Include all your descriptive statistics calculated/created. Describe in a few sentences your conclusions based your choices of descriptive statistics.
2) Analyze Net sales versus the Payment method. Along with your results, describe in a few sentences your conclusions based your choice of descriptive statistic.
3) Analyze the success of Promotion using just the variable: Type of Customer. Along with your results, describe in a few sentences your conclusions based off the results/choice of analysis. Was the promotion successful? Why or Why not?
4) Analyze the relationship between age and net sales. Use the appropriate method (it is a specific type of graph) to determine whether there is a linear association/correlation between age variable and net sales variable.

Transcribed Image Text:

Type of Customer Items Net Method of Gender Marital Age Customer Sales Payment Status Male 1. Regular 39.50 Discover Married 32 Promotional 1 102.40 Proprietary Female Married 36 Card 22.50 Regular Proprietary Female Married 32 Card Promotional 5 100.40 Proprietary Card Female Married 28 Regular 54.00 MasterCard Female 2. Married 34 2. 4. Regular 1. 44.50 MasterCard Female Married 44 Promotional 2 78.00 Proprietary Card Female Married 30 Regular 22.50 Visa Female Married 40 Promotional 2 56.52 Proprietary Female Married 46 Card 10 Regular 44.50 Proprietary Female Married 36 Card 11 Regular 29.50 Proprietary Female Married 48 Card