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! plot roc curve excel
Column N: = =L3*M3 (drag down)
| A (Actual) | B (Predicted Prob) | |------------|--------------------| | 1 | 0.92 | | 0 | 0.31 | | 1 | 0.88 | | 0 | 0.45 | | 1 | 0.67 | | ... | ... | If you work in data science, machine learning,
Add a new column L: = difference between consecutive FPR values: =K3-K2 (drag down) with your own data or download our free
So next time your manager asks, “How good is our model?” – you don’t need to fire up Jupyter. Just open Excel and show them the curve.