Hi all, thanks for watching! I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here: kzbin.info/aero/PLMDcoG6cxhI0EaLoG9jG7fmf22YIUjD-o
@YvesAustin10 ай бұрын
Wow! Incredible use of x,y scatter plot. Transforming what would otherwise be the vertical axes as data points and using data labels is brilliant.
@amyjiao2936Ай бұрын
This is art level of using excel!!! Thank you us much!!
@Scandinasican23 жыл бұрын
This was SO helpful! I didn't have time to learn R for the paper I'm working on, and this is EXACTLY what I needed. Thank you!
@LajeunesseLab3 жыл бұрын
You are so welcome!
@sunsetglowlove3 жыл бұрын
This was the first time I've ever had to create a forest plot and this video was extremely helpful! THE BEST!
@LajeunesseLab3 жыл бұрын
Awesome! Thank you!
@oktiratna29852 жыл бұрын
Thank you for providing the video. It really helpful. In my experience, to do practice while watching video, it much easier to learn using two screens, one for practices, another for watching the video. Then, for different excel version, it may have different location to find the function, a little bit stressful in the beginning. Also, need a little bit manually adjustment for y axis (can not use 1, 2, 3, etc) and perform risk ratio value (manually move to the right).
@Moonstonn2 жыл бұрын
Once again sir, I doff my hat to you. This video has been a life saver! My only error was looking elsewhere before remembering to check your channel. You're right, this process is tedious but until I get R, or any other software, these Excel tutorials you upload are my lifeline to doing meta-analysis. Thank you for spending half an hour for my sake Dr. Marc 😅
@0000000Fritz2 жыл бұрын
Thank you so much for this video! Finally a good source for making a forest plot on Excel. It helped me a lot. Greetings from Germany!
@LajeunesseLab Жыл бұрын
You're very welcome!
@o457279 ай бұрын
didn't want to use R so this was massively helpful!!
@LajeunesseLab9 ай бұрын
haha, this is great!
@posamsaso3 жыл бұрын
Really helpful! I'm a basically R user, but the OR plot i made with packages was not satisfactory. Your video enables me to make a more 'customized' plot for me. thx a lot!🍺
@LajeunesseLab3 жыл бұрын
Glad I could help!
@Goole19473 жыл бұрын
Also you're a god you saved my dissertation
@LajeunesseLab3 жыл бұрын
Thank you so much!
@RhushiZiradkar Жыл бұрын
This video and the rest of the series have been fantastic and so helpful. Thank you! Your passion for this topic is clearly evident as well, which makes it that much better. Is there a way to make funnel plots for publication bias through Excel? Not sure if you made a video on this already, but I didn't see one. Thanks again for uploading these!
@amirraza84863 жыл бұрын
Super I appreciate your teaching and skill
@LajeunesseLab3 жыл бұрын
Thanks Amir!
@ednamarinadesouza44582 жыл бұрын
Thank tou very much, amazing explanation!
@vagabundo84503 жыл бұрын
Great tutorial, if you want to use excel
@audaxious2 жыл бұрын
Great video and super useful! Thank you so much!
@LajeunesseLab2 жыл бұрын
Glad you enjoyed it!
3 жыл бұрын
This was soo good. I like how excel can do a lot of things (if we know how to use it). Thanks for the video
@LajeunesseLab3 жыл бұрын
Glad you enjoyed it!
@wl9318 Жыл бұрын
May I ask where did you get the 7.39? Thank you so much
@ishaelken31202 жыл бұрын
This is a great video. Very helpful
@LajeunesseLab2 жыл бұрын
Glad it was helpful!
@lalnoumas25773 жыл бұрын
you helped me do well in my report. thanks
@LajeunesseLab3 жыл бұрын
Glad I could help!!
@anasalharbi80083 жыл бұрын
great demonestration. Thanks a lot for your time
@LajeunesseLab3 жыл бұрын
Glad it was helpful!
@Nawazash3 жыл бұрын
great description sir...very helpful
@LajeunesseLab3 жыл бұрын
Thanks!
@danielgallegos39633 жыл бұрын
Thank you so much! You saved me!!
@LajeunesseLab3 жыл бұрын
You're welcome!
@lalabengals Жыл бұрын
overall great vid but why is the error bar for Comstock & webster (6.53) going all the way to 7.39?
@vishnueashwar Жыл бұрын
Not all heroes wear capes
@suleimanidrisahmad94532 жыл бұрын
Thanks for this video. This is amazing. Is the forest plot specific to meta-analysis? Can we use it for observational studies?
@LajeunesseLab2 жыл бұрын
Yes you can use it, as long as the outcome has confidence intervals
@michellehweephengtan3101 Жыл бұрын
@@LajeunesseLab Thanks so much for this ! Can I create a forest plot just to view a range of numbers for quality of life values reported in different studies: example , for diabetes related complications ? Not meant to do a meta analyses but just narrative synthesis ?
@suprateekat53383 жыл бұрын
Thanks for the video, that is very useful. RevMan software is also a useful toolkit to use and straightforward to use.
@LajeunesseLab3 жыл бұрын
Great tip!
@top10trendingitems883 жыл бұрын
Thx for your precious efforts. Please try to share the excel that you used as an attachment so we can use it as a template.
@jeevanthapa68103 жыл бұрын
wonderful.. thank you a lot..
@LajeunesseLab3 жыл бұрын
Thanks for watching!
@preyanmehta9275Ай бұрын
in the original graph there are different box sizes for different weights of the studies, does anyone know how can we incorporate this into the graph?
@LA-qd9io3 жыл бұрын
Thanks for the great video - would be lost without it! I have one more questions: can negative effect sizes also be included in a meta-analysis? Bc. when i want to use the formula for the SE = ES/SQRT(ES*N) you cant take the SQRT of a negative effect...
@LajeunesseLab3 жыл бұрын
Yes you need to include negative effect sizes -- since sampling error alone can create study outcomes with positive, null, or negative effects. Calculating the SE of effect sizes is not conventional, SD and 95%CI are the standard presentation approach. I am not familiar with the equation you are using for meta-analysis.
@Selvax943 ай бұрын
Hi and thank you very much for the amazing work. QUESTION: why in hell my title crossbars don't show the negative part of the bar? I've tried everything, including "show both sides" obv... I feel like my excel is just bugged sometimes, like when I select a series of values or bars in the graph not all of them appear selected (light blue dots around them) but the actually modify if I change values 😅. I'm lost guys😞
@tracyquetzal94772 жыл бұрын
Hi I would like to know how to make a Forest plot of the log of the odds ratio and its 95% confidence interval for comparison of categorical predictor variables in logistic regression? I have multiple variables I need to compare. I would like to have 6 forest plots combined together. How can I do this in excel?
@roobadinthehouse2 жыл бұрын
Thank you so much !!!
@belkenfack11773 жыл бұрын
Thank you so much
@LajeunesseLab3 жыл бұрын
Glad it was useful!
@k9gff3 жыл бұрын
Any suggestions how you can change the size of square boxes (ie effect sizes), in the R plot you have shown the boxes are different sizes but in the final excel file they are all the same size.
@LajeunesseLab3 жыл бұрын
Excel is not friendly with boxes of different shapes or sizes, but it is possible -- you'll need to begin with a bubble plot rather than a scatter plot
@user-se6yx8zr5g2 жыл бұрын
Awesome tutorial and great teaching! Q: how would you address the weights issue? both the calculation (haven't seen you talk about that in any of the other videos) and in the plot?
@LajeunesseLab2 жыл бұрын
For the weights, excel is still not friendly to customize in this way and easily have different sizes. But excel gets updated all the time, so maybe in the near future this issue will be address :-)
@morgannickell74472 жыл бұрын
I am making a forest plot with 3 subgroups. How do I calculate the point estimates for each subgroup on excel? (i.e. how do I calculate the diamond's location for each subgroup?)
@LajeunesseLab2 жыл бұрын
This is a more challenging task, and perhaps too difficult to discuss here in the comments -- but maybe I can do another video to help with these special cases :-)
@Goole19473 жыл бұрын
Sir I'm trying to learn R but I have no idea how to make a forest plot on it. I can make l'abbe plot but that's it. Also can you use the odds ratio for this?
@LajeunesseLab3 жыл бұрын
yes, any effect size (e.g., odds ratio, hedges' d, correlations) can be used, this video focuses on log scale effects, but you can ignore that section for regular effect sizes
@Goole19473 жыл бұрын
Is it possible to make a forest plot video for R? Like with event rates and stuff extracting from excel? Just can't find any decent tutorial online.
@ChynaTropic193 жыл бұрын
What does the RE and FE Models mean and how can I compute them?
@LajeunesseLab3 жыл бұрын
These are estimated using meta-analysis techniques, I have a video on how to calculate these, if you wish to use excel: kzbin.info/www/bejne/n2eZfZlolsSDl5o
@kikidebby1149 Жыл бұрын
Hello, please I would like to ask you some questions. How can I contact you?
@naziyatarannum10372 жыл бұрын
How to calculate risk ratio in excel?
@cavessavia53783 жыл бұрын
How to make diamond shape, sir? I made everything except this part
@LajeunesseLab3 жыл бұрын
unfortunately mimicking the multi-sized diamonds is not possible unless you format the marker with your own built-in marker-type or size
@ChynaTropic193 жыл бұрын
How did you get the confidence intervals?
@LajeunesseLab3 жыл бұрын
Confidence Intervals are calculated from the standard deviation of each effect size, the the confidence of pooled means are estimated using meta-analysis