The file named Marketbasketdata.xlsx contains sales of various items. For each row, a 1 in columns B
Question:
The file named Marketbasketdata.xlsx contains sales of various items. For each row, a 1 in columns B through K indicates a purchased item, whereas a 0 marks an item that was not purchased. In the Day Week column, a 1 means the transaction was on a Monday, a 2 means the transaction was on a Tuesday, and so on. For each item listed in K9:K14, calculate the percentage of transactions in which the item was purchased. Also, calculate the fraction of transactions taking place on each day.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: