AN EXCEL PROGRAM FOR CALCULATING AND PLOTTING RECEIVER-OPERATOR CHARACTERISTIC (ROC) CURVES, HISTOGRAMS AND DESCRIPTIVE STATISTICS

Receiver-operator characteristic (ROC) curves have been used increasingly to assess the performance of clinical laboratory tests and to determine suitable positive/negative threshold values. The Microsoft Excel 4.0 program Plot.ROC was designed to provide formatted, publication quality output with minimal user involvement. It asks for a few parameters at the beginning and then runs autonomously, creating ROC charts, histograms and descriptive statistics for each test chosen, and a cumulative ROC chart to compare tests. Output can easily be formatted further using Excel's graphics and text formatting capabilities.