Using Excel for Data Mining (2)----Analyze key impact factors

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