Consider the case where Apple computer tracks online transactions at its iStore and is interested in learning about the purchase patterns of its customers in order to provide recommendations as a customer browses its Web site. A sample of the shopping cart data in binary matrix format resides in the file AppleCart. Each row indicates which iPad features and accessories a customer selected.
Using a minimum support of 10 percent of the total number of transactions and a minimum confidence of 50 percent, use XLMiner to generate a list of association rules.
a. Interpret what the rule with the largest lift ratio is saying about the relationship between the antecedent item set and consequent item set.
b. Interpret the support count of the item set involved in the rule with the largest lift ratio.
c. Interpret the confidence of the rule with the largest lift ratio.
d. Interpret the lift ratio of the rule with the largest lift ratio.
e. Review the top 15 rules, and summarize what they suggest.

  • CreatedNovember 21, 2015
  • Files Included
Post your question