How to draw lift chart based on WEKA

1
How to draw lift chartbased on WEKA

• Xiaoxiao Shi

2
Step 1

• Load the dataset into weka, split the test set,
  output the result with prediction

3
Step 2

• Click Start and save the result

Save the result as .txt file
Right click
4
Step 2

• The result file is supposed to look like this

predictions
5
Step 3

• Open Excel, in the tool bar, click
  Data-Import External Data-Import Data

6
Step 4

• Follow Step 3 to import the result file, you can
  get these interfaces

Click Next
Pull down the navigator, until you can see the
prediction
Split the data like this
7
Step 4

• Click Next-Finish, the data should look like
  this
  

Probability
True Label
8
Step 5

• Use excel to do a sorting on the prediction,
  sorted by the probability, in descending order

After sorting
9
Step 6

• Use excel to calculate the number of true
  positivesIF(/truelabelgood,num1,num)
  
• Use excel to calculate the proportion of the
  sample size, and draw the picture.If you still
  have questions, please see the sample excel file
  for more information on how to calculate the
  above things.