BUSINESS ANALYTICS / Stats

[08 Marks] Question No. 5: A grocery store introducing items from Saudi Arabia is interested in analyzing buying trends of these new "international" items, namely Y, M, C, and J. The files Grocery Store List and Grocery Store Stacked provide data on a collection of transactions in item-list format. Biscuit = B, Soda = S, Almari Cheese = C, Avocado = A, Olives = O, Black Olives = D, Almari Yogurt = Y, Crackers = E, Almari Juices = J, Almari Milk = M, Mutton = F, Coke = L, Apples = H, Chicken = I, Peppers = P, Beef = K, Turkey = T, Gelato = G, Steak = N. S. NO. GROCERY STORE LIST B Y O K T G 1 CO V G UI A W N C S B E M O Y E K M T D A L K P O T G Y H O N A T M L G P K D I M G H Y P I G C S E M P C J P K 10 E B 11 D H P A N T 12 B A M H a) Use a minimum support of 4 transactions (33.33% of the 12 total transactions) and a minimum confidence of 50% to generate a list of association rules. How many rules satisfy this criterion? b) Use a minimum support of 8 transactions (66.66% of the 12 total transactions) and a minimum confidence of 50% to generate a list of association rules. How many rules satisfy this criterion? c) 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? d) Using the list of rules from part (b), consider the rule with the largest lift ratio that also involves a Saudi item. Interpret what this rule is saying about the relationship between the antecedent item set and consequent item set. Rubrics: Understanding & Formulate = 2 Marks Steps = 2 Marks Problem Solving = 2 Marks Correct Output = 2 Marks