Problem #7. Pivot Tables and Charts

Use the data provided in Problem#6. Is the transaction value distribution similar for customers who use the discount code vs. not?

To answer this question:

a) Prepare a table to display the statistical distribution of the $ amount spent for customers how used the discount code (vs. not). Use Pivot Tables so that the transaction value is grouped by increments of $25, starting at $0, and ending at $800.

b) Display information obtained in part (a) using bar charts. The horizontal axis in your chart should be the transaction value and the vertical axis should be the number of customers.  You can present two bar charts (one for customers who used a discount code and one for those who did not) or you can display the information for these these categories of customers as a side-by-side bar chart.

Data#7