A grocery store introducing items from Italy is interested in analyzing buying t

Question

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?

Explanation / Answer

a)

There are 581 rules that satisfy this criterion

b)

There are only 10 rules that satisfy this criterion. By increasing the minimum support required for their analysis, the grocery store with have fewer association rules to analyze, but they will also have limited information about the items that are bought frequently that is often varied from customer to customer. This means that their data analysis won’t represent the majority of the customers that buy groceries at their store, it will only represent a few

c)

The rule with the highest lift ratio that includes an Italian item is rule 3. It states “If hummus, then peroni,” which means the likely chance of a customer buying peroni is higher if that customer also purchases hummus. The antecedent for rule 3 is hummus and the consequent is peroni

d)

The support count for the item set for the union of hummus and peroni is 252 which means that it is at the above the minimum support count that we entered to create our set of association rules. Therefore, this association rule is significant in our data analysis.

according to chegg policy we have to solve 4 subparts

this link may help you

http://www.chegg.com/homework-help/questions-and-answers/grocery-store-introducing-items-italy-interested-analyzing-buying-trends-new-international-q15513671

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.