I am working on an assignment where we are given a bunch
of data points representing medical tests taken to
determine whether a person has a given disease. We have
200 test results (measuring some number from 1-50 which,
at a certain cutoff value, indicates the disease is
likely present): 100 for people who actually have the
disease, and 100 for those who don't. Our mission is to
plot the data in such a way as to evaluate the
sensitivity and specificity of the test (accuracy, best
cutoff point, etc.).

What is the best way to plot this using Excel?

G