Problem #6. Pivot Tables and Charts

Consider the online retailer data used in Problem#4. The data has been expanded to include the transaction value ($ sales value) and the age of each customer. See the accompanying data.

On the average, did the customers who use a discount code spend more or less than the customers who did not use a discount code?

To answer this question:

a) Prepare a table to display the average $ amount spent per customer in each category (i.e. those that use discount code vs. not). Use Pivot Tables.

b) Display the information obtained in part (a) as a bar chart.

Data#6