Results 1 to 5 of 5

ROC plot

This is a discussion on ROC plot within the Excel Questions forums, part of the Question Forums category; Hey ya, I am trying to plot a ROC curve in EXCEL. I havent succeeded in doing so. I tried ...

  1. #1
    kr
    kr is offline
    New Member
    Join Date
    Sep 2007
    Location
    Scotland
    Posts
    3

    Default ROC plot

    Hey ya,

    I am trying to plot a ROC curve in EXCEL. I havent succeeded in doing so. I tried using a scattered chart to do so, it is the closest I have managed to get to look like a ROC plot. Is there any other way to plot a ROC curve in EXCEL.

    Thanks

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,198

    Default

    Sorry, what is a ROC plot? It's not a term I have come across.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  3. #3
    kr
    kr is offline
    New Member
    Join Date
    Sep 2007
    Location
    Scotland
    Posts
    3

    Default

    Hi Denis,

    A Receiver Operating characteristic (ROC) plot is a graphical plot of sensitivity vs specificity and is widely used in medicine related fields.
    Refernce : http://en.wikipedia.org/wiki/ROC_plot

    kr

  4. #4
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,198

    Default

    Hi kr, I haven't used ROC plots before but I'd guess that a scatter plot is your best bet as a starting point, because you get a numeric X-axis.

    Obviously you need to build an appropriate model so that you get the correct output. I ran a quick Google search and came up with this link: maybe it will be useful to you

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  5. #5
    kr
    kr is offline
    New Member
    Join Date
    Sep 2007
    Location
    Scotland
    Posts
    3

    Default

    Hi Denis,

    Thanks for the link. I came across the link while I was searching through google.

    I sorted the problem using a scatter plot. Thanks again.

    kr

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com