No video

Creating publication-quality forest plots in Excel | Spreadsheet Synthesis

  Рет қаралды 36,188

LajeunesseLab

LajeunesseLab

Күн бұрын

Пікірлер: 72
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
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
@YvesAustin
@YvesAustin 10 ай бұрын
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
@amyjiao2936 Ай бұрын
This is art level of using excel!!! Thank you us much!!
@Scandinasican2
@Scandinasican2 3 жыл бұрын
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!
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
You are so welcome!
@sunsetglowlove
@sunsetglowlove 3 жыл бұрын
This was the first time I've ever had to create a forest plot and this video was extremely helpful! THE BEST!
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Awesome! Thank you!
@oktiratna2985
@oktiratna2985 2 жыл бұрын
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).
@Moonstonn
@Moonstonn 2 жыл бұрын
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 😅
@0000000Fritz
@0000000Fritz 2 жыл бұрын
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
@LajeunesseLab Жыл бұрын
You're very welcome!
@o45727
@o45727 9 ай бұрын
didn't want to use R so this was massively helpful!!
@LajeunesseLab
@LajeunesseLab 9 ай бұрын
haha, this is great!
@posamsaso
@posamsaso 3 жыл бұрын
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!🍺
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Glad I could help!
@Goole1947
@Goole1947 3 жыл бұрын
Also you're a god you saved my dissertation
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Thank you so much!
@RhushiZiradkar
@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!
@amirraza8486
@amirraza8486 3 жыл бұрын
Super I appreciate your teaching and skill
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Thanks Amir!
@ednamarinadesouza4458
@ednamarinadesouza4458 2 жыл бұрын
Thank tou very much, amazing explanation!
@vagabundo8450
@vagabundo8450 3 жыл бұрын
Great tutorial, if you want to use excel
@audaxious
@audaxious 2 жыл бұрын
Great video and super useful! Thank you so much!
@LajeunesseLab
@LajeunesseLab 2 жыл бұрын
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
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Glad you enjoyed it!
@wl9318
@wl9318 Жыл бұрын
May I ask where did you get the 7.39? Thank you so much
@ishaelken3120
@ishaelken3120 2 жыл бұрын
This is a great video. Very helpful
@LajeunesseLab
@LajeunesseLab 2 жыл бұрын
Glad it was helpful!
@lalnoumas2577
@lalnoumas2577 3 жыл бұрын
you helped me do well in my report. thanks
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Glad I could help!!
@anasalharbi8008
@anasalharbi8008 3 жыл бұрын
great demonestration. Thanks a lot for your time
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Glad it was helpful!
@Nawazash
@Nawazash 3 жыл бұрын
great description sir...very helpful
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Thanks!
@danielgallegos3963
@danielgallegos3963 3 жыл бұрын
Thank you so much! You saved me!!
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
You're welcome!
@lalabengals
@lalabengals Жыл бұрын
overall great vid but why is the error bar for Comstock & webster (6.53) going all the way to 7.39?
@vishnueashwar
@vishnueashwar Жыл бұрын
Not all heroes wear capes
@suleimanidrisahmad9453
@suleimanidrisahmad9453 2 жыл бұрын
Thanks for this video. This is amazing. Is the forest plot specific to meta-analysis? Can we use it for observational studies?
@LajeunesseLab
@LajeunesseLab 2 жыл бұрын
Yes you can use it, as long as the outcome has confidence intervals
@michellehweephengtan3101
@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 ?
@suprateekat5338
@suprateekat5338 3 жыл бұрын
Thanks for the video, that is very useful. RevMan software is also a useful toolkit to use and straightforward to use.
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Great tip!
@top10trendingitems88
@top10trendingitems88 3 жыл бұрын
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.
@jeevanthapa6810
@jeevanthapa6810 3 жыл бұрын
wonderful.. thank you a lot..
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Thanks for watching!
@preyanmehta9275
@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-qd9io
@LA-qd9io 3 жыл бұрын
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...
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
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.
@Selvax94
@Selvax94 3 ай бұрын
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😞
@tracyquetzal9477
@tracyquetzal9477 2 жыл бұрын
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?
@roobadinthehouse
@roobadinthehouse 2 жыл бұрын
Thank you so much !!!
@belkenfack1177
@belkenfack1177 3 жыл бұрын
Thank you so much
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Glad it was useful!
@k9gff
@k9gff 3 жыл бұрын
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.
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
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-se6yx8zr5g
@user-se6yx8zr5g 2 жыл бұрын
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?
@LajeunesseLab
@LajeunesseLab 2 жыл бұрын
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 :-)
@morgannickell7447
@morgannickell7447 2 жыл бұрын
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?)
@LajeunesseLab
@LajeunesseLab 2 жыл бұрын
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 :-)
@Goole1947
@Goole1947 3 жыл бұрын
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?
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
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
@Goole1947
@Goole1947 3 жыл бұрын
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.
@ChynaTropic19
@ChynaTropic19 3 жыл бұрын
What does the RE and FE Models mean and how can I compute them?
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
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
@kikidebby1149 Жыл бұрын
Hello, please I would like to ask you some questions. How can I contact you?
@naziyatarannum1037
@naziyatarannum1037 2 жыл бұрын
How to calculate risk ratio in excel?
@cavessavia5378
@cavessavia5378 3 жыл бұрын
How to make diamond shape, sir? I made everything except this part
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
unfortunately mimicking the multi-sized diamonds is not possible unless you format the marker with your own built-in marker-type or size
@ChynaTropic19
@ChynaTropic19 3 жыл бұрын
How did you get the confidence intervals?
@LajeunesseLab
@LajeunesseLab 3 жыл бұрын
Confidence Intervals are calculated from the standard deviation of each effect size, the the confidence of pooled means are estimated using meta-analysis
How to read a Forest Plot in a meta analysis
17:24
Dr Ashish Kumar
Рет қаралды 24 М.
SPONGEBOB POWER-UPS IN BRAWL STARS!!!
08:35
Brawl Stars
Рет қаралды 23 МЛН
ISSEI & yellow girl 💛
00:33
ISSEI / いっせい
Рет қаралды 25 МЛН
这三姐弟太会藏了!#小丑#天使#路飞#家庭#搞笑
00:24
家庭搞笑日记
Рет қаралды 101 МЛН
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 54 МЛН
Forest Plot Interpretation - Clearly Explained
10:09
Steven Bradburn
Рет қаралды 157 М.
meta-regression in Excel tutorial | Spreadsheet Synthesis
51:12
LajeunesseLab
Рет қаралды 3,4 М.
How to make forest plots in Microsoft Excel (meta analysis chart)
13:45
How to perform a meta-analysis in R
27:58
Daniel Quintana
Рет қаралды 42 М.
Interpreting a forest plot of a meta-analysis
3:41
Clinical Information Sciences
Рет қаралды 136 М.
ChatGPT for Data Analytics: Full Course
3:35:30
Luke Barousse
Рет қаралды 256 М.
How to extract data from images using the juicr package for R
10:41
Effect size calculation in meta analysis
12:02
SERVSIG
Рет қаралды 14 М.
SPONGEBOB POWER-UPS IN BRAWL STARS!!!
08:35
Brawl Stars
Рет қаралды 23 МЛН