After you configure your environment, you can use Excel for data mining.
Environment configuration issues can be found in:
http://blog.csdn.net/xinxing__8185/article/details/46445435
Sample dmaddins_sampledata.xlsx
Files:http://download.csdn.net/detail/xinxing__8185/8780481
In the Data table, select Table Analysis Tools Sample , which is the user's information statistics, including marital status, gender, income, children, education level, occupation, whether there is a house, number of cars, living area, age, whether purchased bicycles, etc.
Click on the data in the table and the tab will be one more
The shopping basket analysis tool simplifies the cross-selling analysis process. You can apply the tool to a table that contains transactions. The tool identifies the group of items that should appear at the same time and identifies the rules that can be used in the recommendation. If the table contains a value column that is associated with each item in each transaction, the tool can also calculate the promotion for each group and for each rule. Elevation is a measure that represents the increase in the value of the corresponding item or group in the context of the pattern that the tool identifies.
Select Table Associate
Click Shopping basket Analysis
Will generate two reports
One is a shopping basket bundle selling goods
One is the shopping basket recommendation
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Data mining using Excel (8)----Shopping basket analysis