Case Study: The Dude
The Dude, a division of Lebowski industries, is a chain of big and tall men's apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other Lebowski stores. Data collected for a sample of 100 Lebowski credit card transactions at The Dude during a single day while the promotion was running are contained in the file name "DUDE".
The DudeCard method of payment refers to charges made using a proprietary card (like a Macy's or Nordstrom card). Customers who made a purchase using a discount coupon sent in the mail to them are referred to as "coupon" customers. All others are called "no coupon" customers.
Because the promotional coupons were not sent to regular Dude customers, management considers sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, The Dude also hopes that the promotional customers will continue to shop at its stores.
In addition, the following variables might need some clarification.
• "Items" refers to the total number of items purchased, i.e. the total number of SKUs scanned.
• "Net Sales" refers to the total dollar amount charged to the credit card.
Management at The Dude would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.
They have asked you, the hotshot Business Analyst, to develop a managerial report. This report should contain the following information at a minimum.
1. An executive summary of your findings. This should be no more than 1 page double-spaced. The executive summary should answer the top three most important questions. And it is YOUR responsibility to tell management why those are the most important and why. Hint: Two of the most important variables will be Gender and Marital Status. But they are not the ONLY ones.
2. Percent frequency distribution for the key variables.
3. A column chart or pie chart showing the number of customer purchases attributable to each method of payment.
4. A cross-tabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences you see.
5. A scatter diagram to explore the relationship between net sales and customer age.
The final product will have a 1 page executive summary along with accompanying graphs/charts as appendices. Then, you can refer to the appendices when making a point about your data.
Hint: you may want to use the Pivot Table function in Excel to do this assignment. If you do, the data will fall into place for you.
Attachment:- Dude_revised.rar