Problem #4. Pivot Tables and Charts
An online retailer recently ran a marketing experiment, called the “24-hour Flash Sale.” Data on all transactions made during a 24-hour period was collected. A total of 20,000 transactions were made on the day of the sale. A customer had to use a special discount code during checkout to take advantage of the Flash Sale. The special discount codes were emailed to a randomly selected group of customers. Transactions on the day of the experiment varied by the method of payment, whether the customer was emailed a discount code, whether the customer used the discount code, and the time elapsed since the customer made their last purchase prior to the Flash Sale. You are provided with the data for a random sample of transactions; see the accompanying data.
Considering all the customers who used a discount code, did the majority use the EStore Card to make a payment? How about all the customers who did not use a discount code?
To answer these questions:
a) Prepare a two-way table to display the percentage frequencies with respect to method of payment and use of discount code. Use Pivot Tables to prepare your table.
b) Visualize the information obtained in part (a) using charts. You can create bar charts to display the information.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.