(15 marks) Association rules, also known as market basket analysis or affinity analysis is a technique...

 

 

 

Transcribed Image Text:

(15 marks) Association rules, also known as "market basket analysis" or "affinity analysis" is a technique which correlates products with each other. This technique helps to identify relations between purchases of different products. For the purpose of this exercise, let's examine the customers' orders, listed in table 1, at a restaurant. Association Rule Order # 2 3 45 8 9 Part-II-Question 1. Ordered Item 1 Burger Burger Salads Burger Salads Burger Burger Fries Fries Ordered Item 2 Fries Salads Coffee Fries Coffee Fries Fries Coffee Burger Table-1 What are the relevant items? I Ordered Item 3 Fries Salads Coffee Salads Part-II-Question 1. What are the relevant items? Part-II-Question 2. Generate the co-occurrence matrix. Part-II-Question 3. Calculate the support, confidence, and lift for the following three rules: R1: IF (Burger) THEN (Fries) R2: IF (Salad and Burger) THEN (Fries) R3: IF (Burger) THEN (Fries and Coffee) Order # Rule Occurrence (from Q3) Support Table-2 Confidence % Lift Ratio Part-II-Question 4. Consider the results of the market basket analysis shown in the Figure below. Examine the first row and answer the following questions. i How is the "Confidence % output is calculated. Explain the output. ii. How the "Lift Ratio" is calculated. Explain the output. Bow 10 Confidence S SERAATO 51 54 29 27 49 52 15 17 Antecedent (A) Consequent (C) Nail Polish & Bronzer Brushes & Concealer 80.52 Brushes & Concealer 60.19 Nail Polish & Bronzer 81.58 Nail Polish & Concealer & Bronzer Brushes 56.36 Brushes 76.36 Brushes 81 55 Nail Polish & Bronzer 75.81 Brushes & Bronzer 56.88 Nail Polish & Concealer 70.64 Nail Polish & Concealer 70.00 Brushes 67.07 Blush & Nail Polish 50.00 Brushes Nail Polish & Concealer & Bronzer Nail Polish & Bronzer Brushes Nail Polish & Concealer Brushes & Bronzer Brushes Nail Polish & Concealer Brushes Blush & Nail Polish Figure-1 Support for A Support for C Support for A & C 77 103 77 103 76 110 110 103 84 171109 109 110 82 110 110 76 103 110 109 84 110 109 110 82 Lift Ratio 62 3.908712647 62 3.908712647 62 3.708133971 62 3.708133971 34 3706972639 84 3.706972639 62 3.385757973 62 3.385757973 77 3.211009174 77 3211009174 55 3048780488 55 3.048780488 (15 marks) Association rules, also known as "market basket analysis" or "affinity analysis" is a technique which correlates products with each other. This technique helps to identify relations between purchases of different products. For the purpose of this exercise, let's examine the customers' orders, listed in table 1, at a restaurant. Association Rule Order # 2 3 45 8 9 Part-II-Question 1. Ordered Item 1 Burger Burger Salads Burger Salads Burger Burger Fries Fries Ordered Item 2 Fries Salads Coffee Fries Coffee Fries Fries Coffee Burger Table-1 What are the relevant items? I Ordered Item 3 Fries Salads Coffee Salads Part-II-Question 1. What are the relevant items? Part-II-Question 2. Generate the co-occurrence matrix. Part-II-Question 3. Calculate the support, confidence, and lift for the following three rules: R1: IF (Burger) THEN (Fries) R2: IF (Salad and Burger) THEN (Fries) R3: IF (Burger) THEN (Fries and Coffee) Order # Rule Occurrence (from Q3) Support Table-2 Confidence % Lift Ratio Part-II-Question 4. Consider the results of the market basket analysis shown in the Figure below. Examine the first row and answer the following questions. i How is the "Confidence % output is calculated. Explain the output. ii. How the "Lift Ratio" is calculated. Explain the output. Bow 10 Confidence S SERAATO 51 54 29 27 49 52 15 17 Antecedent (A) Consequent (C) Nail Polish & Bronzer Brushes & Concealer 80.52 Brushes & Concealer 60.19 Nail Polish & Bronzer 81.58 Nail Polish & Concealer & Bronzer Brushes 56.36 Brushes 76.36 Brushes 81 55 Nail Polish & Bronzer 75.81 Brushes & Bronzer 56.88 Nail Polish & Concealer 70.64 Nail Polish & Concealer 70.00 Brushes 67.07 Blush & Nail Polish 50.00 Brushes Nail Polish & Concealer & Bronzer Nail Polish & Bronzer Brushes Nail Polish & Concealer Brushes & Bronzer Brushes Nail Polish & Concealer Brushes Blush & Nail Polish Figure-1 Support for A Support for C Support for A & C 77 103 77 103 76 110 110 103 84 171109 109 110 82 110 110 76 103 110 109 84 110 109 110 82 Lift Ratio 62 3.908712647 62 3.908712647 62 3.708133971 62 3.708133971 34 3706972639 84 3.706972639 62 3.385757973 62 3.385757973 77 3.211009174 77 3211009174 55 3048780488 55 3.048780488

Answer rating: 100% (QA)

What are the relevant ite... View the full answer