Excel worksheets contains 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 minimum support of 10.
Answer the following questions listed below directly in your Excel file. 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.