Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the

Question:

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 are referred to as promotional customers and customers who made a purchase but did not use a discount 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.

Type of Customer Items Net Method of Gender Marital Age Customer Sales Payment Status Male 1. Regular 39.50 Discover Mar

Regular 1. 44.50 MasterCard Female Married 44 Promotional 2 78.00 Proprietary Card Female Married 30 Regular 22.50 Visa

Coupon
A coupon or coupon payment is the annual interest rate paid on a bond, expressed as a percentage of the face value and paid from issue date until maturity. Coupons are usually referred to in terms of the coupon rate (the sum of coupons paid in a...