Find percent frequency distribution for the key variables

Reference no: EM131515767

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

Reference no: EM131515767

Questions Cloud

Do you feel that trumps budget and tax plan favors the rich : Do you feel that Trump's budget and tax plan favors the rich, the middle class, or the poor? Explain with specific examples.

Identify an incentive conflict in your firm : Identify an incentive conflict in your firm, or one you have read about, that reduced firm value. How that contributed to the conflict.

Which of the given is most likely to be a variable cost : Which of the following is most likely to be a variable cost? At the given price, the most profitable level of output occurs at quantity.

Analyze the elasticity of demand and supply : Assignment: The Key Concepts in Economics- Analyze the elasticity of demand and supply and its importance, and the effect of taxes or other public policies.

Find percent frequency distribution for the key variables : Find percent frequency distribution for the key variables. A scatter diagram to explore the relationship between net sales and customer age.

Pose a significant question from your choosen article : 1) Summarize chosen your chosen article; 2) Critical Analysis: critically analyze it; 3) Critical Question: pose a significant question from your article.

How does your plan address timing and budget constraints : How you would involve the stakeholders in the development of the intervention evaluation plan? How does your plan address timing, and budget constraints?

Analyze impact theory of consumer choice has on higher wages : Analyze impact the theory of consumer choice has on Higher wages and The role asymmetric information has in many economic transactions.

Conduct a test for the validity of the capm : ECON634: Econometrics and Business Statistics - Conduct a test for the validity of the CAPM relative to the three-factor model. What do you find?

User Account

All Pages