Data Mining Assignment PDF

Data Mining
Student Id and Name
[Pick the date]

Question 1
XLMiner Output
(i) The interpretation of the required rules is highlighted below.
Rule 1 – A conditional probability of 1 is observed for a customer purchasing nail polish
provided that brush has already been purchased.
Rule 2 - A conditional probability of 0.6322 is observed for a customer purchasing brush
provided that nail polish has already been purchased (Liebowitz, 2015).
1

Rule 3 - A conditional probability of 0.5919 is observed for a customer purchasing bronzer
provided that nail polish has already been purchased
(ii) The redundancy of the rule is adjudged on the basis of ancestor rule and the relevant
support level for the same. This may be demonstrated for the given data through the use of
rule 2. The ancestor relationship is rule 1 whose support measured through lift ratio is the
same for rule 2. Hence, the inclusion of rule 1 potentially renders rule 1 as redundant (Zaki,
2000).
The given rules need to be accessed keeping in mind the underlying support and confidence
which are both imperative. Typically higher support implies greater importance but it is expected
that the confidence level is also high. Rules having both factors high tend to offer immense
utility. Besides, the consideration of minimum confidence level and support is done keeping the
end objective in mind (Liebowitz, 2015).
(iii) The relevant output when the minimum confidence level is changed from 50% to 75% is
shown below.
2