Apple computer tracks its online transactions at its iStore to learn about the p

Question

Apple computer tracks its online transactions at its iStore to learn 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 form resides in the data 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.

Review the top 15 rules, and summarize what they suggest.

Data can be found here: http://abacus.acf.csusb.edu/Kim/ADMN601/06_CH6%20WEBfiles/ click and download applecart to find the daata

Explanation / Answer

Calculate the confidence

confidence= support of {antecedent and consequent} / support of antecedent

Lift Ratio =  confidence support of consequent total number of transactions

Now Open the data set given

follow the steps as mentioned below.

Step 1. Select the cell in the range of the data

Step 2. Click the XLMiner Platform tab

Step 3. Click Associate from the Data Mining group

Step 4. Click Association Rules

Step 5. When the Association Rules dialog box appears, in the Data source area, confirm that the Worksheet:, Workbook:, and Data range: entries correspond to the appropriate data

Step 6. In the Data source area, select First Row Contains Headers

Step 7. In the Input Data Format area, select Data in binary matrix format

Step 8. In the Parameters area, enter 4 in the box next to Minimum support (# transactions) and enter 50 in the box next to Minimum confidence (%)

Step 9. Click OK

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.