ROC Analysis Educational Worksheet

This is a simple Excel spreadsheet to demonstrate the metrics of detection performance (sensitivity, specificity, etc) and show how these metrics contribute to receiver operating characteristic curves. Spreasheet contains two worksheets: "ASSIGNMENT"(for educational problems below) and "DynamicTestData" (for generating custom data and testing more scenarios):
On worksheet, "ASSIGNMENT", Complete the following problems: Problems: 1) Calculate Sensitivity, Specificity, Accuracy for Single Test Threshold of 38 (Calculations can be performed inside excel; Complete the yellow cells with appropriate formulas) 2) If you wanted to be sure to detect all disease, what is the highest threshold you could use according to this data? 3) What is the threshold that leads to almost identical sensitivity and specificity? Why? 4) Calculate the Area Under the ROC and SNR below. (Hint: Can perform numerical integration; averaging of TPF to get AROC) |

Author: Adam Alessio, https://www.egr.msu.edu/~aalessio/

Last Revised: 30-Sept-2019