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

[@zsazsa7697]

Thank you so much. Your video is very useful.

[@stokesbaker5907]

I am glad it was helpful. SSB

[@Edgaraza]

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

[@stokesbaker5907]

I'm glad you found the video helpful.

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

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

[@stokesbaker5907]

I'm glad it was helpful.

[@le5298]

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

[@fatma5035]

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

[@stokesbaker5907]

I am glad it helped. SSB

[@erikagalipo5460]

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

[@akharshokri4948]

Amazingly pedagogic! Thank you!

[@stokesbaker5907]

Thank you for your very kind comment.

[@ankursprout]

Thankyou Mr. Baker!!

[@stokesbaker5907]

I'm glad the video was helpful.

[@mariavaldivia1948]

great explanation! thank you :)

[@coolscientish1085]

You are amazing. Thank you

[@stokesbaker5907]

Thank you for the compliment.

[@Meeran4624]

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

[@xima7140]

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

[@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)

[@sudipahalder5004]

Very helpful. Thanks a lot.

[@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?

[@drnehasharma8534]

very helpful!! Thanks

[@stokesbaker5907]

I am glad it helped. SSB

[@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?

[@nikomax772]

Very useful!

[@oluwagbengafakanye5265]

great video

[@mataranimeharkare]

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

[@echoouyang6664]

Very helpful!Thanks!

[@JamesLee449]

thank you :)

[@silviadangelo6725]

thank you so much

[@coolscientish1085]

HI IS AUTOPSY RESULTS THE CONTROLS OR ?

[@stokesbaker5907]

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

[@vinodkoyalkar3406]

from were we need to take the data

[@stokesbaker5907]

I do not understand your question. SSB

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

thank you

[@lucaciurares5606]

very useful

[@rimjhimkanaujia9889]

thank you so much..