= =F2/(F2+I2)
= =COUNTIFS($A$2:$A$100,0,$B$2:$B$100,">="&E2)
Column M: = =(J2+J3)/2
Add a new column named Threshold . Start from the highest predicted probability down to the lowest, then add 0. plot roc curve excel
Good news:
| A (Actual) | B (Predicted Prob) | |------------|--------------------| | 1 | 0.92 | | 0 | 0.31 | | 1 | 0.88 | | 0 | 0.45 | | 1 | 0.67 | | ... | ... |
= =COUNTIFS($A$2:$A$100,1,$B$2:$B$100,"<"&E2) But what if you don’t have access to Python, R, or SPSS
If you work in data science, machine learning, or medical diagnostics, you’ve probably heard of the (Receiver Operating Characteristic curve). It’s a powerful tool to evaluate the performance of a binary classification model. But what if you don’t have access to Python, R, or SPSS?
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!
Column N: = =L3*M3 (drag down)
By [Your Name] | Data Analysis & Excel Tips
= =SUM(N2:N_last) AUC ≥ 0.8 is generally considered good; 0.9+ is excellent. Practical Example & Interpretation Let’s say your AUC = 0.87. This means there’s an 87% chance that the model will rank a randomly chosen positive instance higher than a randomly chosen negative one.