Plot Roc Curve Excel Apr 2026

= =COUNTIFS($A$2:$A$100,0,$B$2:$B$100,"<"&E2)

= =COUNTIFS($A$2:$A$100,1,$B$2:$B$100,">="&E2)

by predicted probability (highest to lowest). 👉 Select both columns → Data tab → Sort → by Predicted Prob → Descending . Step 2: Choose Threshold Values We will test different classification thresholds (cutoffs). For each threshold, we calculate True Positives, False Positives, etc. 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!

= =COUNTIFS($A$2:$A$100,0,$B$2:$B$100,">="&E2) For each threshold, we calculate True Positives, False

Column N: = =L3*M3 (drag down)

Add a new column named Threshold . Start from the highest predicted probability down to the lowest, then add 0. Have questions or an Excel trick to add

Column M: = =(J2+J3)/2

Add a new column L: = difference between consecutive FPR values: =K3-K2 (drag down)