Good news:
= =COUNTIFS($A$2:$A$100,1,$B$2:$B$100,">="&E2) plot roc curve excel
| A (Actual) | B (Predicted Prob) | |------------|--------------------| | 1 | 0.92 | | 0 | 0.31 | | 1 | 0.88 | | 0 | 0.45 | | 1 | 0.67 | | ... | ... | Good news: = =COUNTIFS($A$2:$A$100
Assume Sensitivity (TPR) values in col J and FPR values in col K. plot roc curve excel
with your own data or download our free template below (link to template). And if you found this helpful, share it with a colleague who still thinks Excel can’t do machine learning evaluation! Have questions or an Excel trick to add? Drop a comment below!
You should now have a table like:
Column M: = =(J2+J3)/2