Youa are at: Diagnostics - methods - MS-Excel-tools for ROC-Analysis

MS-Excel-Tools for ROC analysis (ACOMED statistics)

ACOMED statistik is providing statistical services - mainly in the field of diagnostic studies, evaluation of diagnostic tests, ROC analyses and so on. Although commercial statistical software is used in my company usually, it is advantegeous to use MS Excel-tools in some cases, for instance if free layout of the figures is required. Free demo versions with restricted numbers of cases are available (single ROC curve, comparison of two ROC curves).

Providing statistical services is the core subject of ACOMED statistik's business. However, 2 MS Excel tools related to ROC curves have been developed. Beside the advantages in free layout of figures, the ACOMED - tools are more comfortable in terms of group selection and combination, because in commercial software a transformation to the groups 0 and 1 has often to be performed before starting the analyses.

You can purchase the tools in ACOMED's webshop paying only the cost price (35 EUR: single ROC-curve .. 60 EUR: package of 2 tools).

 

Features of ROC-Tool 1:

• calculation of a ROC curve

• comfortable choice of groups

• free layout of ROC-curve-graphics (as usual in MS excel)

• NEW: optional labelling of cut-offs in the figure

• ROC curve with confidence interval (free choice of %CI)

• calculation of AUC, SE, CI according to Hanley (1982)

• calculation of sensitivities at given specificities and vice versa

• A demo version (full version, 30 days) is free available.
  You can order it via E-Mail.

Features of ROC-Tool 2:

• calculation 2 ROC curves inkl. AUC, SE, 95%-CI

• free layout of graphics (as usual in MS excel)

• comparision of 2 ROC curves using nonparametric approach acc. to DeLong (1988)

• A demo version (full version, 30 days) is free available.
  You can order it via E-Mail.