ROC Curve in Excel (Receiving Operating Characteristic)

Use a ROC Curve to choose the most appropriate "cut-off" for a test.

QI Macros Add-in for Excel Contains a ROC Curve Template

Click on the QI Macros Menu and select, Chart Templates, ROC Curve.

roc curve on QI Macros menu

 

ROC Curve Template in Excel

  1. Input the Cut Points in column A.
  2. Input the number of normal and non-normal cases in columns B and C, respectively.
  3. The template will perform the calculations and draw the ROC Curve.
  4. The template will also calculate the area under the curve (C14) and rate the accuracy of the test (C17.)
    • > .9 = Excellent
    • > .8 = Good
    • > .7 = Fair
    • ≤ .7 = Poor

For a comprehensive description of ROC Curves see http://gim.unmc.edu/dxtests/ROC1.htm

To create a ROC Curve using QI Macros...
Try It Now!