Using Excel for Data Mining (2)---- analyze key impact factors
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 following is an example of an analysis of the data using the Analyze key factors feature:
Based on the statistical information of existing users, the income analysis, and other factors on the impact of income. For example, a user with a better job should have a higher income and vice versa. Occupations can be factors that have a greater impact on income.
When the run is complete,Excel generates the following report.
In the relative Impact Value column, the longer the slider length, the greater the impact factor. For example, the first row of data, stating that a person's occupation is engaged in manual labour, his income is more inclined to less than 39050
Using Excel for Data Mining (2)----Analyze key impact factors