Data mining using excel (2) ---- analyze key influencing factors and excel Data Mining

Data mining using excel (2) ---- analyze key influencing factors and excel Data Mining

 

Use excel for data mining (2) ---- analyze key influencing factors

 

After configuring the environment, you can use excel for data mining.

For environment configuration problems, see:

Http://blog.csdn.net/xinxing__8185/article/details/46445435

Example DMAddins_SampleData.xlsx

File: http://download.csdn.net/detail/xinxing__8185/8780481

 

 

In the data table, select the table analysis tools sample table, which displays user information statistics, including marital status, gender, income, children, education level, occupation, and house ownership, number of vehicles, area of residence, age, and whether bicycles have been purchased.

 

 

 

Hover the mouse over the data in the table, and an additional tab is displayed.

 

 

 

Next, we will use the key factor analysis function to analyze the data as an example:

Analyze the income based on the statistical information of existing users and the impact of other factors on the income. For example, a user with a good career should have a higher income, and vice versa. Occupation can be a factor that has a greater impact on income.

 

 

 

 

After running, excel generates the following report.

 

 

In the relative influence value column, the longer the slider length, the greater the influence factor. For example, the first line of data shows that a person's career is engaged in physical labor, and his income tends to be lower than 39050.