Relationship between the type of customer versus net sales


Assignment:

The objective of the project is for you to use descriptive statistics and present it in a data dashboard to help managment get a customer profile of the promotional campaign.

You will create a percent frequency distribution for the following variables:

  • Items
  • Net Sales
  • Method of Payment
  • Gender
  • Marital Status
  • Age

Create a bar or pie chart showing the number of purchases using a particular payment method

Create a crosstabulation showing the relationship between the type of customer versus net sales

A scatter diagram exploring the relationship between the net sales and customer age

Include additional charts and information to help the manager visualize the data if necessary.

To help the managers with their decision making, describe a few "take-aways" about the data including but not limited to:

1. Was the promotion successful?

2. What demographic had the highest participation in the promotion?

3. What payment method was used the most?

4. How were the net sales distributed across the population? Who had the most? Who had the least?

5. What sample of the population should the managers try to target to possibly improve sales?

6. Should the managers plan more promotions similar to this one? Why or why not?

Attachment:- Percent frequency distribution for variable.rar

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Relationship between the type of customer versus net sales
Reference No:- TGS03177449

Now Priced at $30 (50% Discount)

Recommended (97%)

Rated (4.9/5)