Case Problem #1: Pelican Stores (40 points)

Pelican Stores, a division of National Clothing, is a chain of womens 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 Week 14 Homework file. Some comments regarding the file.

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 did not are referred to as regular customers.

Because the promotional coupons were not sent to regular customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make.

Percent frequency distributions were introduced in Week 12. You can use Excel to create percent frequency distributions using Pivot Tables. The data are given in the first tab (Data). Perform the following.

A. Create percent frequency distribution for each of the key variables, including (a) number of items; (b) net sales in bins/groups (0-25, 25-50, . > 200); (c) method of payment; (d) gender; (e) marital status; and (f) age in bins/groups (20-29, 30-39, . 70-80).

- A1: Answer using Frequency Dist Tab Under

B. Create column chart showing the number of customer purchases attributable to the method of payment (method of payment as x-axis and frequency % as y-axis).

- B1: Answer using Frequency Dist Tab Under

C. Identify at least two observations from the frequency distribution data.

- C1: Answer using Frequency Dist Tab Under

Data:

Frequency Dist Tab

A1 fx Number of Items