Roc Curve Excel

To create the curve, your spreadsheet should contain at least two primary columns:

| Actual | Prob | Cum TP | Cum FP | Sensitivity (TPR) | FPR | | :--- | :--- | :--- | :--- | :--- | :--- | | 1 | 0.99 | 1 | 0 | 0.02 | 0.00 | | 1 | 0.95 | 2 | 0 | 0.04 | 0.00 | | 0 | 0.90 | 2 | 1 | 0.04 | 0.03 | | 1 | 0.88 | 3 | 1 | 0.06 | 0.03 | | ... | ... | ... | ... | ... | ... | roc curve excel

Assume: