This blog uses SQL Server Data mining client plug-in to Excel The above are Estimation analysis .

You can browse the specific information about estimation analysis in the directory first ：

One 、 Estimation model

Estimation model Extract patterns from data , And use these models to predict the factors that will affect the results . The result must be in numerical （ Such as currency 、 sales 、 Date or time ） To express .

for example , If the target column contains the graduation rate of the school （ Expressed as a percentage ）, Then we can analyze the factors that may increase or decrease the graduation rate , Such as the number of students in each school 、 The ratio of students to teachers and the number of teachers .

It is estimated that the wizard will use Microsoft Decision tree algorithm . You can browse dependencies and patterns in an interactive viewer , And quickly create graphics that can represent more details of the discovered patterns .

The data used in this analysis ：300 Movie information （ If you need resources, please leave a message in the comment area ）

Two 、 Decision tree

Here I choose to use decision tree for estimation ：

The type of regression is general , Therefore, some parameters cannot be regressed ：

The dependency network is as follows
According to the following dynamic diagram, we can see ： The least important parameter is POINTS, The most important parameter is BO.

3、 ... and 、 neural network

Another algorithm ：


After creating the structure, choose to add the model to the structure ：





And then you use NBA The data acts on the neural network algorithm ：

Estimate the impact of the previous parameters on each game score ：

Four 、 Logical regression

Select logistic regression algorithm ：