A Retailer Is Interested in Analyzing the Shopping Trend of Men

Essay

A retailer is interested in analyzing the shopping trend of men concerning the items: Shirts, pants, Jeans, t-shirts, Shoes, and Belts. A sample of 50 male customers is selected and the data are given below.
​ $$\begin{array}{| l | l | l | l | l | l | } \hline \text { t-shirt}\\\hline \text {formal shirt}&\text {formal pants}&\text {belt}\\\hline \text {formal pants}&\text { t-shirt}\\\hline\text {formal pants}&\text { formal shoes}&\text {belt}\\\hline\text {formal shirt}&\text {formal pants}&\text {jeans}&\text {t-shirt}&\text { formal shoes}&\text {belt}\\\hline\text {formal pants}&\text {formal shirt}&\text {t-shirt}&\text { formal shoes}\\\hline\text { formal shoes}&\text {formal shirt}&\text {formal pants}\\\hline \text { formal shoes}&\text {jeans}&\text {t-shirt}\\\hline\text {formal pants}&\text {t-shirt}&\text {jeans}&\text {formal shirt}&\text {belt}&\text { formal shoes}\\\hline\text {belt}&\text {jeans}\\\hline\text {formal shirt}&\text {t-shirt}&\text { formal shoes}&\text {belt}\\\hline\text {belt}&\text {formal pants}&\text {formal shirt}&\text { formal shoes}\\\hline\text { formal shoes}&\text {belt}\\\hline\text { formal shoes}&\text {formal pants}&\text {t-shirt}&\text {formal shirt}\\\hline\text {t-shirt}&\text {jeans}\\\hline\text {formal shirt}&\text {formal pants}&\text { formal shoes}&\text {jeans}\\\hline\text {jeans}&\text {belt}\\\hline\text { formal shoes}&\text {formal pants}&\text {formal shirt}&\text {t-shirt}&\text {jeans}&\text {belt}\\\hline\text {formal shirt}&\text {formal pants}&\text {t-shirt}&\text { formal shoes}&\text {belt}\\\hline\text { formal shoes}&\text {formal pants}&\text {formal shirt}&\text {belt}\\\hline\text {belt}&\text {t-shirt}&\text {jeans}&\text { formal shoes}\\\hline\text {t-shirt}&\text {formal pants}&\text {formal shirt}&\text { formal shoes}\\\hline\text {formal pants}&\text {formal shirt}&\text { formal shoes}\\\hline\text {formal pants}\\\hline\text {formal shirt}&\text { formal shoes}&\text {jeans}&\text {formal pants}\\\hline\text {belt}&\text {formal pants}&\text { formal shoes}\\\hline\text {formal shirt}&\text {t-shirt}\\\hline\text {formal pants}&\text { formal shoes}\\\hline\text { formal shoes}&\text {formal pants}&\text {jeans}&\text {formal shirt}\\\hline\text {jeans}&\text {formal pants}&\text { formal shoes}\\\hline\text {formal pants}&\text { formal shoes}&\text {belt}&\text {formal shirt}\\\hline\text { formal shoes}&\text {formal pants}&\text {formal shirt}\\\hline\text {formal pants}&\text {t-shirt}\\\hline\text { formal shoes}&\text {formal pants}&\text {belt}&\text {t-shirt}&\text {formal shirt}&\text {jeans}\\\hline\text {belt}&\text { formal shoes}&\text {formal shirt}&\text {formal pants}\\\hline\text {jeans}&\text {t-shirt}&\text {formal pants}\\\hline\text {formal shirt}&\text {formal pants}&\text {jeans}&\text {t-shirt}&\text { formal shoes}\\\hline\text {formal pants}&\text {formal shirt}&\text { formal shoes}\\\hline\text {t-shirt}&\text {jeans}&\text {formal shirt}\\\hline\text { formal shoes}&\text {formal pants}&\text {belt}\\\hline\text {belt}&\text { formal shoes}&\text {formal pants}&\text {formal shirt}\\\hline\text {formal pants}&\text {formal shirt}&\text { formal shoes}&\text {t-shirt}&\text {belt}\\\hline\text { formal shoes}&\text {t-shirt}\\\hline\text {jeans}&\text { formal shoes}&\text {belt}&\text {formal shirt}\\\hline\text {formal pants}&\text { formal shoes}&\text {t-shirt}&\text {formal shirt}\\\hline\text {belt}&\text {formal pants}&\text {jeans}\\\hline\text {formal shirt}&\text {jeans}&\text {t-shirt}&\text {belt}\\\hline\hline\end{array}$$

a. Using a minimum support of 20 transactions and a minimum confidence of 50 percent, use XLMiner to generate a
list of association rules. How many rules satisfy this criterion?
b. Using the list of rules from part a, consider the rule with the largest lift ratio. Interpret what this rule is saying
about the relationship between the antecedent item set and consequent item set.
c. Interpret the support count of the item set composed of the all the items involved in the rule with the largest
lift ratio.
d. Interpret the confidence of the rule with the largest lift ratio.
e. Interpret the lift ratio of the rule with the largest lift ratio.