IMPORTANT: If you get a limit violation error, your analysis is incorrect. Look at your data carefully and think what should be included in your Data Range. Reopen the Excel file and start over.
Please adjust Data Range in the pop-up window, even if you selected the range correctly in Excel.
Please complete the problems using Excel, answer the questions asked in Word, then submit both files.
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 (AR analysis) on the following data using a minimum confidence percentage of 75% 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 EXCEL workbook which shows your association rule analysis worksheets and you can type your answers to the questions in the some worksheet. In other words, your AR analysis worksheets and your answers should be in the same EXCEL file. Upload one EXCEL file to Canvas.
