= =COUNTIFS($A$2:$A$100,0,$B$2:$B$100,"<"&E2)
To plot a ROC curve in Excel, you cannot simply use predicted labels (0 or 1). You need the (or confidence scores) generated by your model. plot roc curve excel
This is the most critical step that often gets overlooked. 0 for negative).
Then to get AUC.
Binary data (1 for positive, 0 for negative). plot roc curve excel