Пікірлер
@ElaLaelasari-x2v
@ElaLaelasari-x2v 7 ай бұрын
Thank you for sharing a good tutorial
@kcg4633
@kcg4633 8 ай бұрын
Thank You
@chrisfox880
@chrisfox880 11 ай бұрын
Life saver, thank you!
@samkab677
@samkab677 Жыл бұрын
How to interpret results?
@marcoswelker132
@marcoswelker132 Жыл бұрын
Very nice. Well explained. Thank you for sharing ;)
@enriquevalentin5245
@enriquevalentin5245 Жыл бұрын
I'm so thankful!!!!! :))))
@traviswhitfill509
@traviswhitfill509 2 жыл бұрын
This was SO helpful. Thank you so much!
@imenemansouri4325
@imenemansouri4325 2 жыл бұрын
Thank you very much for this video super helpful. I would lover to follow you on twitter if you have one ;)
@theflamekid
@theflamekid 2 жыл бұрын
Hello, I have some trouble, I have 28 factors and while the bottem labels of the factors are in line with the graphs (the dot and error bar) the graphs are everytime a bit to higher when you go one variable up so the first labels are totally out of place. Edit: the bars are in place but the "dot and line" not in line with the bars
@giuliadiicorsica
@giuliadiicorsica Жыл бұрын
I think I had the same problem you did, and I realized I had to readjust the secondary vertical axis so that the maximum number was 1 above our highest count while the minimum was 0, and then the issue was fixed. Gave me a grey hair though.
@HuyNguyen-rv9ge
@HuyNguyen-rv9ge 3 жыл бұрын
Erica, can you let me know where I should click to get countdown? as you did so fast and can not see it.
@shuktatube5333
@shuktatube5333 3 жыл бұрын
An excellent explanation for me. Thank you!
@haihuang7529
@haihuang7529 3 жыл бұрын
thank you very much
@Ftrtts.
@Ftrtts. 3 жыл бұрын
Thank you so much!! I really didn't know how I was going to graph my odds ratio so this really helped!
@bjfiero47
@bjfiero47 3 жыл бұрын
Excellent tutorial. In the end, I would like to add that if your CI's are very wide using the format axis option (for the axis with numbers) and choose the option "logarithmic scale base 10" with axis bounds set to auto. Then format axis for the axis with factors at set label position to "low".
@VictorAntares
@VictorAntares 3 жыл бұрын
Thank you. My committee loved the plot. And I guess the reviewers did too.
@mamadouadamasow9477
@mamadouadamasow9477 3 жыл бұрын
Very good, thanks
@suprateekat5338
@suprateekat5338 3 жыл бұрын
Thank you so much for this video!! It is very clear with every step and so helpful, saved me so much time from having to search endlessly for other videos Unfortunately this does not work with 10 or more factors.
@chukwuemekaogbu8037
@chukwuemekaogbu8037 Жыл бұрын
Yes. It does not for 8 factors too. Do you know any video where i can watch how to do this?
@pragalathannaidoo7845
@pragalathannaidoo7845 3 жыл бұрын
Thank You. Explained well.
@majoramirez7767
@majoramirez7767 3 жыл бұрын
You are amazing!!! thanks!
@osupermono
@osupermono 3 жыл бұрын
Hi Erica, you don't know how many times I said "I love you"
@katiebeckerwa
@katiebeckerwa 3 жыл бұрын
THANK YOU THANK YOU THANK YOU!!!!
@painless263
@painless263 3 жыл бұрын
wow. this was very helpful and easy to follow. My forrest plot looks great. Thank you!
@yongwoon96
@yongwoon96 3 жыл бұрын
한국인 이신가여??
@abbyscurfield2035
@abbyscurfield2035 3 жыл бұрын
Hi Erica, thank you so much for this helpful video. I'm having an issue with my datapoint/label alignment, though. First of all, I'm seeing no tick marks at all on my Y axis, and second, when I go to change the "odds" data to scatter, it moves the datapoints further above the axis labels, and "positioning on tick marks" doesn't change it. Any advice for this issue?
@petraschultz384
@petraschultz384 3 жыл бұрын
This was super helpful. Anyone know how to show two sets of data in the same plot area? For instance outcomes for two different groups, for instance different doses of medications. I'm looking to show OR for complications associated with two dose levels of same medication.
@olusegunadewaleadeyemi2499
@olusegunadewaleadeyemi2499 3 жыл бұрын
Thank you Erica, you are a life saver
@fazeelzubair2787
@fazeelzubair2787 3 жыл бұрын
how to draw diamond estimate?
@esawibowo5711
@esawibowo5711 3 жыл бұрын
It turns out that there is a problem when using 12 variables ... I found a solution by adding 1 more empty column above it (in the explanation only 1 empty column above) ... hope it helps
@ricardomorato2875
@ricardomorato2875 3 жыл бұрын
Thank you! You have just helped me a lot! Made some forest plots for my master thesis. Thankssss.
@nunodenoronha
@nunodenoronha 3 жыл бұрын
Hey, Ricardo! Não estou a conseguir fazer. Dá-me erro coma fórmula mesmo mudando as células - (ROWS($A$4:$A$11)-ROW()+ROW($A$4:$A$11)) A ti não te deu erro?
@ricardomorato2875
@ricardomorato2875 3 жыл бұрын
@@nunodenoronha se estiver usando o Excel em português, substitua o ROW/ ROWS por LIN/LINS. Eu também não consegui nessa parte, até perceber que era o idioma
@nunodenoronha
@nunodenoronha 3 жыл бұрын
@@ricardomorato2875 Muito obrigado pela sua ajuda! Um abraço
@nunodenoronha
@nunodenoronha 3 жыл бұрын
@@ricardomorato2875 Só mais uma dúvida: Depois de você escrever LIN/LINS e alterar o número das células, a série de números que lhe apareceu estava correta? A minha série de números começa em 4 e acaba em 7, não em 1.
@ricardomorato2875
@ricardomorato2875 3 жыл бұрын
@@nunodenoronha se vc começou sua série de fatores na linha 4, é só alterar o segundo valor para o número da última linha que contém fator. Pelo que vc falou, na sua tabela seria de 4 a 7, enquanto no vídeo foi de 4 a 11
@youngmoneymahini
@youngmoneymahini 3 жыл бұрын
Joe Rogan
@diegoramonfaur7837
@diegoramonfaur7837 3 жыл бұрын
Thank you, this was extremely helpful. Can you individually change the color of individual circles? EVery time I try to chanche the color every circle changes color as well.
@maribres
@maribres 3 жыл бұрын
Thank you very much for this help! Wonderful video!
@toyvousamaki
@toyvousamaki 4 жыл бұрын
Very helpful thank you
@jenniferangel9803
@jenniferangel9803 4 жыл бұрын
Thank you so much Mam :)
@statisticstime4734
@statisticstime4734 4 жыл бұрын
Excellent!
@markeid11
@markeid11 4 жыл бұрын
when I try to add in the odds ratios, the values seem to add in an a different y axis- and I cannot get the values to match with the original bar countdown values. I am using excel 2016 on a Mac.. Any suggestions?
@daviskibo1
@daviskibo1 3 жыл бұрын
Im having the same problem
@robertridde6914
@robertridde6914 3 жыл бұрын
For OR polts , you need to select your OR values column for X-axis data series, and the Countdown column for Y-axis data series. I'm using excel 2016
@daviskibo1
@daviskibo1 3 жыл бұрын
@@robertridde6914 Thanks for the reply. That what i did, reslts: same problem
@flash2hridya
@flash2hridya 3 жыл бұрын
I have the same issue, odds ratio scatter dots are not aligning with the bars
@nycollassilva3558
@nycollassilva3558 Жыл бұрын
Gwml1jqgik
@anthonybavry2642
@anthonybavry2642 4 жыл бұрын
My countdown column counts up instead of down. Also, when I try to change the red bar to a scatter plot, my figure falls apart.
@andreib.8565
@andreib.8565 4 жыл бұрын
i have the same problem with changing the red bar to a scatter plot. Did you solve the problem?
@sherinhanem
@sherinhanem 7 ай бұрын
The same here
@tigerlitam9422
@tigerlitam9422 4 жыл бұрын
Dang. 3 and a half years later and still saving people like me at work haha. Thank you Erica
@boudebabaabdelghafour3000
@boudebabaabdelghafour3000 4 жыл бұрын
very helpful thank you so much <3
@kristianj.salasespinoza3582
@kristianj.salasespinoza3582 4 жыл бұрын
Thanks Erica, I was wondering how to show the p values in the graph.
@drlalatendumoharana
@drlalatendumoharana 4 жыл бұрын
Thank you ma'am for the video,, it was very helpful. ma'am I am unable to align the x axis lebels to their respective odds ratios. kindly help
@leahdodds9242
@leahdodds9242 4 жыл бұрын
The error bars are not adjusting accurately using excel 16. Is there a way to fix this? It seems like they don't adjust even after specifying the value
@gm-xx4fh
@gm-xx4fh 4 жыл бұрын
most comprehensive, clear and instructional vid I have ever come across on youtube...thx
@aakashrahman7652
@aakashrahman7652 4 жыл бұрын
Excellent work. Thanks
@mayraysann7480
@mayraysann7480 4 жыл бұрын
Just what I needed! Great tutorial. Only note I would add is depending on the version of Excel you have you may need to adjust your y-axis range if the scatterplot points don't align with your countdown/factor labels :)
@anjalyjohn5600
@anjalyjohn5600 4 жыл бұрын
Hi ! How do I do this ?
@pauldahlke5618
@pauldahlke5618 4 жыл бұрын
@@anjalyjohn5600 Before you delete the right hand axis (for the scatter plot) change its max bound to one higher than your amount of factors.
@meenamaharjan3882
@meenamaharjan3882 3 жыл бұрын
@@pauldahlke5618 Thanks to you! Finally it worked.
@ericengels2116
@ericengels2116 4 жыл бұрын
This video is very helpful. I just wish it was not so difficult to make these graphs in Excel. Really appreciate your time and effort in explaining this clearly.
@marias4137
@marias4137 4 жыл бұрын
Hi! The formula =(ROWS($A$4:$A$11)-ROW()+ROW($A$4:$A$11)) gives me #NAME error, could anybody help me? Thank you so much
@Leon1Das-MJPZ
@Leon1Das-MJPZ 4 жыл бұрын
I had the same problem. In the end the problem for me was that the language of Excel was in Dutch in my case. So if your excel program is in another language you should change the term ROWS into the language that your Excel is set up in.
@mariasanz8643
@mariasanz8643 4 жыл бұрын
@@Leon1Das-MJPZ Thank you so much for your help!
@Leon1Das-MJPZ
@Leon1Das-MJPZ 4 жыл бұрын
@@mariasanz8643 Did that fix it?
@mariasanz8643
@mariasanz8643 4 жыл бұрын
@@Leon1Das-MJPZ yes it did! thanks so much
@fezalikhan
@fezalikhan 4 жыл бұрын
One question professor, from where you got the initial values, I mean lower, upper, and Odds?
@Leon1Das-MJPZ
@Leon1Das-MJPZ 4 жыл бұрын
That would be data extracted from literature or from your own investigations.
@alexanderbichev6897
@alexanderbichev6897 4 жыл бұрын
Does not work under the Office'2013.
@brianac7273
@brianac7273 4 жыл бұрын
Anyone know how to get a bold vertical line on the odds ratio of 1 so that the reference is well seen?
@loriegabidel
@loriegabidel 4 жыл бұрын
The only way I know how to do it is to manually add a line using the shapes tool.