Question: Part-II (15 marks) Association Rule ____________ (15 marks) Association rules, also known as market basket analysis or affinity analysis is a technique which correlates products

Part-II (15 marks)

Association Rule ____________ (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, lets examine the customers orders, listed in table 1, at a restaurant.

Order #	Ordered Item 1	Ordered Item 2	Ordered Item 3
1	Burger	Fries
2	Burger	Salads	Fries
3	Salads	Coffee
4	Burger	Fries	Salads
5	Salads	Coffee
6	Burger	Fries	Coffee
7	Burger	Fries
8	Fries	Coffee
9	Fries	Burger	Salads

Table-1

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	Confidence %	Lift Ratio

Table-2

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.

How is the Confidence % output is calculated. Explain the output.

How the Lift Ratio is calculated. Explain the output.

Part-II (15 marks) Association Rule ____________ (15 marks) Association rules, also known

Figure-1

Row ID Confidence % Antecedent (A) Consequent (C) 50 80.52 Brushes & Concealer Nail Polish & Bronzer 51 60.19 Nail Polish & Bronzer Brushes & Concealer 46 81.58 Nail Polish & Concealer & Bronzer Brushes 54 56.36 Brushes Nail Polish & Concealer & Bronzer 29 76.36 Brushes Nail Polish & Bronzer 27 81.55 Nail Polish & Bronzer Brushes 49 73.81 Brushes & Bronzer Nail Polish & Concealer 52 56.88 Nail Polish & Concealer Brushes & Bronzer 15 70.64 Nail Polish & Concealer Brushes 17 70.00 Brushes Nail Polish & Concealer 67.07 Blush & Nail Polish Brushes 7 50.00 Brushes Blush & Nail Polish Support for A Support for Support for A&C Lift Ratio 77 103 62 3.908712647 103 77 62 3.908712647 76 110 62 3.708133971 110 76 62 3.708133971 110 103 84 3.706972639 103 110 84 3.706972639 84 109 62 3.385757973 109 84 62 3.385757973 109 110 77 3.211009174 110 109 77 3.211009174 82 110 55 3.048780488 110 82 55 3.048780488 6 Row ID Confidence % Antecedent (A) Consequent (C) 50 80.52 Brushes & Concealer Nail Polish & Bronzer 51 60.19 Nail Polish & Bronzer Brushes & Concealer 46 81.58 Nail Polish & Concealer & Bronzer Brushes 54 56.36 Brushes Nail Polish & Concealer & Bronzer 29 76.36 Brushes Nail Polish & Bronzer 27 81.55 Nail Polish & Bronzer Brushes 49 73.81 Brushes & Bronzer Nail Polish & Concealer 52 56.88 Nail Polish & Concealer Brushes & Bronzer 15 70.64 Nail Polish & Concealer Brushes 17 70.00 Brushes Nail Polish & Concealer 67.07 Blush & Nail Polish Brushes 7 50.00 Brushes Blush & Nail Polish Support for A Support for Support for A&C Lift Ratio 77 103 62 3.908712647 103 77 62 3.908712647 76 110 62 3.708133971 110 76 62 3.708133971 110 103 84 3.706972639 103 110 84 3.706972639 84 109 62 3.385757973 109 84 62 3.385757973 109 110 77 3.211009174 110 109 77 3.211009174 82 110 55 3.048780488 110 82 55 3.048780488 6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Association Rule (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...

(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...

Cross-selling within a fully automated convenience store . Background . In the past, retailers saw their job as one of buying products and putting them out for sale to the public. If the products...

1) A/B tests are.. A more similar to field experiments than lab experiments B) more similar to lab experiments than field experiments C) never field experiments or lab experiments D) not truly...

Hi- Please take a look at the attached Word document for detailed requirements on an 8-page evaluation. Let me know what you think, and we can discuss price, plus a healthy tip. Task: (1) The...

I need help with the Final Project presentation. (The last part) I attached my previous presentations to it as well Milestones 1, 2, 3 and the interview research. Please help, and please cite all...

Instructions: 1. Mention the parties involved in the case, duly identified as plaintiffs or defendants, etc. 2. What is the main controversy that arises in the case. (The controversy It is always...

Use the formulae bellow to find ROCE for HOME DEPOT using there 10-k. ROCE = RNOA + LEVERAGE * (RNOA - NET BORROWING COST) 10-K bellow:- Table of Contents UNITED STATES SECURITIES AND EXCHANGE...

Starting in 2008, an increasing number of people found themselves facing mortgages that were worth more than the value of their homes. A fund manager who had invested in debt obligations involving...

CareerBuilder.com conducted a survey to learn about the proportion of employers who had ever sent an employee home because they were dressed inappropriately (June 17, 2008, www.careerbuilder.com)....

Describe the functions of a commercial bank such as ICBC or HSBC.

Former employers providing references for a job applicant are protected by a ( n ) privilege. Multiple Choice qualified absolute strict statutory

Why should all appraisal processes avoid addressing personality characteristics of employees?

Consider an employee who always performs satisfactorily but has little or no opportunity to improve, and can go no higher in the organization and does not aspire to do so. Why is it considered...

Some management experts have recommended that performance appraisal be abolished. Provide three reasons why performance appraisals should be retained in modern healthcare organizations.