Question

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.

Answer 1

Answer:

Hello attached below is the sample of the shopping cart data in binary matrix format resides in the file AppleCart

answer :

a)  Antecedent : Retina display, stand; Consequent : speakers

b) The support count of that item set which is convoluted in the rule having the largest life ratio = 204  from the output of the " list of Rules "

c)  62.77%

d)  The lift ratio = 2.27

e) The top 15 rules have features that are common and this makes apple to put interest on the assortments. as seen an iPad with a retina is always purchased with other accessories, Also an iPad with retina is always paired with memory upgrade as well.

Step-by-step explanation:

steps:

i) generate a list of association rules

ii) update the minimum support to 200 and the required minimum confidence to 50% ( on the dialog box )

a) using the output of the list of association rules  

The rule expression for the largest life ratio can be written as

Antecedent : Retina display, stand; Consequent : speakers

This means that if an iPad with retina display is acquired with stand then the speakers are also acquired  ( Rule with largest lift ratio )

b) Interpret the support count of the item set involved in the rule with the largest lift ratio

The support count of that item set which is convoluted in the rule having the largest life ratio = 204  from the output of the " list of Rules "

i.e. all items ( 3 ) purchased where purchased 204 times \

c) Interpret the confidence of the rule with the largest lift ratio.

confidence of the rule with the largest lift ratio can be interpreted as

= 204 / 325 = 62.77%  i.e. speakers where acquired 204 out of 325 times of acquiring the retina display and stand together

d)  Interpret the lift ratio of the rule with the largest lift ratio.

The lift ratio = 2.27

this means that a customer that has acquired a retina display, and a stand is  127% more prospective than other customers who purchase speakers

e) Review the top 15 rules,

The top 15 rules have features that are common and this makes apple to put interest on the assortments. as seen an iPad with a retina is always purchased with other accessories, Also an iPad with retina is always paired with memory upgrade as well.