Problem #5. Pivot Tables and Charts
Use the data provided in Problem#4. Of all the customers who made a purchase within the past 3 months, what percentage used an EStore Card? Is this percentage different for the customers who did not make purchase in the past 3 months?
To answer these questions:
a) Prepare a two-way table for method of payment and time since last purchase. Use Pivot Tables to prepare your table.
b) Visualize the information obtained in part (a) using bar charts.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.