Excel worksheets contain a set of receipt data for a bakery where each row represents a different customer’s purchase. For each row, a 1 indicates they purchased that product and a 0 means they did not. In total, there are 50 different products the bakery sells, and the owner is interested in determining any association rules in the purchase patterns of their customers.
Complete an Association Rule analysis on the following data using a minimum confidence percentage of 70% and a minimum support of 10.
Answer the following questions:
- How many rules did Association Rule analysis found?
- Pick any one of the resultant rules developed by your analysis and explain each of the columns in the output using that rule as an example.
- Select the 5 rules you would recommend to the bakery owner and explain your reasoning.
Please upload the completed workbook which shows your association rule analysis and answers to the questions.