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

[@abujamea67]

Thank you very much for this very informative and detailed video it was vey 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

[@sameerap4624]

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

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

[@StephenRaftery3141]

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

[@silviadangelo6725]

thank you so much

[@JamesLee449]

thank you :)

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

thank you

[@vinodkoyalkar3406]

from were we need to take the data

[@stokesbaker5907]

I do not understand your question. SSB

[@mataranimeharkare]

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

[@rimjhimkanaujia9889]

thank you so much..

[@madhusudanhm6804]

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

[@erikagalipo5460]

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

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

[@oluwagbengafakanye5265]

great video

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

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

[@sudipahalder5004]

Very helpful. Thanks a lot.

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

[@zsazsa7697]

Thank you so much. Your video is very useful.

[@stokesbaker5907]

I am glad it was helpful. SSB

[@coolscientish1085]

You are amazing. Thank you

[@stokesbaker5907]

Thank you for the compliment.

[@ankursprout]

Thankyou Mr. Baker!!

[@stokesbaker5907]

I'm glad the video was helpful.

[@drnehasharma8534]

very helpful!! Thanks

[@stokesbaker5907]

I am glad it helped. SSB

[@mariavaldivia1948]

great explanation! thank you :)

[@coolscientish1085]

HI IS AUTOPSY RESULTS THE CONTROLS OR ?

[@stokesbaker5907]

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

[@echoouyang6664]

Very helpful!Thanks!

[@lucaciurares5606]

very useful