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:

Question Posted: