Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 3

A grocery store introducing items from Italy is interested in analyzing buying trends of new international items: prosciutto, pepperoni, risotto, and gelato.
a. Using a minimum support of 100 transactions and a minimum confidence of 50 percent, use XLMiner to generate a list of association rules. How many rules satisfy this criterion
b. Using a minimum support of 250 transactions and a minimum confidence of 50 percent, use XLMiner to generate a list of association rules. How many rules satisfy this criterion Why may the grocery store want to increase the minimum support required for their analysis What is the risk of increasing the minimum support required
c. Using the list of rules from part b, consider the rule with the largest lift ratio that involves an Italian item. Interpret what this rule is saying about the relationship between the antecedent item set and consequent item set.
d. Interpret the support count of the item set involved in the rule with the largest lift ratio that involves an Italian item.
e. Interpret the confidence of the rule with the largest lift ratio that involves an Italian item.
f. Interpret the lift ratio of the rule with the largest lift ratio that involves an Italian item.
g. What insight can the grocery store obtain about its purchasers of the Italian fare