Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(15 marks) Association rules, also known as market basket analysis or affinity analysis is a technique which correlates products with each other. This technique

 

 


 

(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

Step by Step Solution

3.41 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

What are the relevant ite... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Kemp, Jeffrey Waybright

2nd edition

978-0132771801, 9780132771580, 132771802, 132771586, 978-0133052152

More Books

Students also viewed these Accounting questions