Receiver Operating Characteristic (ROC) Curves with Excel Pivot Table Function

[@StephenRaftery3141]

This is very useful. I particularly like the way you use a Pivot Table to generate the Sensitivity and Specificity values

[@madhusudanhm6804]

Thank u sir... ur work helped me a lot in my thesis work...

[@abujamea67]

Thank you very much for this very informative and detailed video it was vey helpful

[@le5298]

Very very helpful! Thank you so much for all of the details!!

[@akharshokri4948]

Amazingly pedagogic! Thank you!

[@stokesbaker5907]

Thank you for your very kind comment.

[@zsazsa7697]

Thank you so much. Your video is very useful.

[@stokesbaker5907]

I am glad it was helpful. SSB

[@erikagalipo5460]

Thank you very much. This is a very well done video and extrimely useful. Good Job!

[@ΧριστίναΧαλούλου]

It was VERY helpful!!!! Thank you very much

[@stokesbaker5907]

I'm glad it was helpful.

[@Edgaraza]

Thanks very much, you are great to share it!!!! I was needing it!

[@stokesbaker5907]

I'm glad you found the video helpful.

[@fatma5035]

thank you for this tutorial, it helps me to help someone who needs this tutorial :D

[@stokesbaker5907]

I am glad it helped. SSB

[@rimjhimkanaujia9889]

thank you so much..

[@ankursprout]

Thankyou Mr. Baker!!

[@stokesbaker5907]

I'm glad the video was helpful.

[@sudipahalder5004]

Very helpful. Thanks a lot.

[@sameerap4624]

Could you please explain how did you calculate sensitivity and specificity values

[@nikomax772]

Very useful!

[@coolscientish1085]

You are amazing. Thank you

[@stokesbaker5907]

Thank you for the compliment.

[@mariavaldivia1948]

great explanation! thank you :)

[@oluwagbengafakanye5265]

great video

[@jusarquis]

Hi, this is so easy, thank you so much! I had the coordinates but didn't know how to plot the curve. One question, how can I insert the middle line in the graphic? Thank you soooooooooo much!!!

[@stokesbaker5907]

What do you mean by midline?

[@jusarquis]

@@stokesbaker5907 I meant the line of the null hypothesis, I found out how to do it, thank you!

[@tabovtt8824]

@@jusarquiscould you tell me how you inserted the middle line?

[@mataranimeharkare]

Can u share ur data set with me so i can follow ur example correctly.... However your video is great

[@drnehasharma8534]

very helpful!! Thanks

[@stokesbaker5907]

I am glad it helped. SSB

[@JoaoGuilherme-og6vg]

Great tutorial! Thank you. Is there a way to get the best accuracy cut off, not necessarily corresponding to one of the BMI values, but also in between them? For example, could the best accuracy point be 34.6, for example, and some automatic calculation bring this information?

[@stokesbaker5907]

I will look into your question and respond soon. SSB

[@coolscientish1085]

Thank you for your reply but I am still confused, in a case where you have a gold standard and the device you are testing, which one has results that are labelled as healthy/not healthy (like autopsy results), and which one has values (like BMI)

[@xima7140]

Hi Can you please tell us if two x axis values can be analyzed on the same roc

[@highnono]

Thank you very much! Do you know how to calculate the area bellow the ROC curve using Excel?

[@stokesbaker5907]

Old timer's trick is to use a see scale to estimate the area under the curve. Cut out a know are (e.g. 10 x 10 = 100 sq units). Then cut out the desired area under the curve. The first is used to convert surface area to grams. The mass of area under the curve divide by g/sq units = surface area under the curve.

[@diamaabulaban3471]

@@stokesbaker5907 can you classify more on how to calculate the area under the curve plz?

[@JamesLee449]

thank you :)

[@echoouyang6664]

Very helpful!Thanks!

[@قناةالعلم-ك9ب]

thank you

[@lucaciurares5606]

very useful

[@vinodkoyalkar3406]

from were we need to take the data

[@stokesbaker5907]

I do not understand your question. SSB

[@coolscientish1085]

HI IS AUTOPSY RESULTS THE CONTROLS OR ?

[@stokesbaker5907]

The autopsy results are that are used to determine sensitivity and specificity.

[@silviadangelo6725]

thank you so much