Hi all, thanks for watching! I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here: ua-cam.com/play/PLMDcoG6cxhI0EaLoG9jG7fmf22YIUjD-o.html
I was looking all over the internet for meta-analysis. After your hands-on video, it became easier to see what it is all about. Excellent... and thank you very much.
Thank you very much for this video. Whenever you said 'I'm talking through this too much", I'd respond, "no sir, you're talking just the right amount." This a godsend. I'll get some of the software you suggested but I won't forget this lesson any time soon
Thank you very much. This is awesome. I followed your steps and I got the same results. Could you please, add your data set for this video so people practice?
Thank you! Very useful. How do we get those d and variance from literatures? For example, I got the OR=1.25 (group treatment vs control), then what is the d and variance here?
Thank you so much for this video! Small question, (I2 - I squared) can be calculated from Q and report like heterogenity of variance? Thank you in advance.
I found your video extremely helpful. I have a better understanding on the formulas now. However, I wondering how much the formulas change if I am working with binary variables? Please let me know if I would need to do anything different. Thank you.
the formulae are applicable to all effect sizes, but things certainly get more complicated if you include predictors, see here for example: ua-cam.com/video/nLOPWhO45dk/v-deo.html
Great tutorial! are the original effect sizes and variances (columns B and C) the original data from the papers? or what you would call "Cohen's D" and "Cohen's SD"?
Here is the data: figshare.com/articles/online_resource/Fixed_effect_homogeneity_tests_and_random-effects_meta-analysis_in_Microsoft_Excel/14138087 It's a bit complicated on what they are named, in the 1985 Hedges & Olkin book they are referred to simply as d and variance of d, which some disciplines now call Hedges' g and variance of Hedges' g. They are related to Cohen's d, but have an additional small sample bias correction factor. Hope this helps!
@@LajeunesseLab Thanks for the quick response! To be more concrete- say I take data from papers that reported the outcome as means, and for each study the scale which was used was a bit different, than I should convert them to Cohen's d or Hedges' g using the means and the variance to reach the point where the tutorial starts, right? (or are columns B and C in the tutorial just the data from the paper and columns D and E the ones doing that initial standardization of the effect sizes?)
@@דרורבןאפרים You are correct, to get the effect sizes used in the tutorial, you would need to extract the means, variances, and sample sizes of a treatment and control group to calculate a d or g for that study. I provide examples of data extraction here: ua-cam.com/video/YUcSfV0BglY/v-deo.html and examples of converting these raw data into effect sizes here: ua-cam.com/video/qp2pUZZX2CU/v-deo.html Hope this helps!!
Dear, thank you very much for the video! It has been very useful for me. I am trying to perform the analysis with a dichotomous estimator and calculating the aggregate relative risk. However, the lower end of the confidence interval is negative and I have not been able to get a result that is between 0 and 1. How can I fix this? Thanks again!
Thanks so much indeed. Have you uploaded these Excel work-files anywhere as templates? It would help to get hold of all those equations especially for health care workers like me who can't deal with math.
I am just a beginner to do meta- analysis.Firstly, Study means citation 1,2,3 ; d means standarized mean and var D is what? I don't know how to get var D? Can you explain this?
Hi, I am struggling to run a metanalysis. It is my first time. I have continuous data with mean, sample size, and standard deviation for each study (without means for control and exposure groups.) Any ideas on the appropriate R argument suitable for this type of data?
When you extract the study outcomes from studies, they are often based on summary statistics like means, standard deviations, and sample sizes. With these, you can calculate effect sizes and their variances.
Yes, thank you for all of your help through the uses of the videos. I have constructed and submitted my charts already, thank you. It looked amazing. Thank you.
Not really, in the series I mostly use R for meta-analysis, but I have colleagues who are on computers with limited software, and so I created these Excel tutorials for them since R is a headache for their systems
Hello, I have seen your videos on meta-analysis. I am having certain queries. Can you please provide me your email id, so that I can have words with you. Thanks in advance.
Hi all, thanks for watching!
I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here:
ua-cam.com/play/PLMDcoG6cxhI0EaLoG9jG7fmf22YIUjD-o.html
You're making research very easier SIR! Thanks
Can I get your I'd .please I am working on it and Now I am stuck
I was looking all over the internet for meta-analysis. After your hands-on video, it became easier to see what it is all about. Excellent... and thank you very much.
Glad I could help!
Thank you very much for this video. Whenever you said 'I'm talking through this too much", I'd respond, "no sir, you're talking just the right amount." This a godsend. I'll get some of the software you suggested but I won't forget this lesson any time soon
haha thanks, everything is recorded live and I'm always concerned that I'm taking too long -- good to know someone is listening!
Sir, thank you for this video. This is a life saver.
Glad it helped!
Thank you very much. This is awesome. I followed your steps and I got the same results. Could you please, add your data set for this video so people practice?
Thank you! Very useful. How do we get those d and variance from literatures? For example, I got the OR=1.25 (group treatment vs control), then what is the d and variance here?
Thank you so much for this video!
Small question, (I2 - I squared) can be calculated from Q and report like heterogenity of variance?
Thank you in advance.
Yes, this Q can be used to calculate I²:
I² = 100% x (Q - df)/Q.
I found your video extremely helpful. I have a better understanding on the formulas now. However, I wondering how much the formulas change if I am working with binary variables? Please let me know if I would need to do anything different. Thank you.
the formulae are applicable to all effect sizes, but things certainly get more complicated if you include predictors, see here for example: ua-cam.com/video/nLOPWhO45dk/v-deo.html
Thanks for such an easy explanation 😊👍
My pleasure 😊
Great tutorial! are the original effect sizes and variances (columns B and C) the original data from the papers? or what you would call "Cohen's D" and "Cohen's SD"?
Here is the data: figshare.com/articles/online_resource/Fixed_effect_homogeneity_tests_and_random-effects_meta-analysis_in_Microsoft_Excel/14138087
It's a bit complicated on what they are named, in the 1985 Hedges & Olkin book they are referred to simply as d and variance of d, which some disciplines now call Hedges' g and variance of Hedges' g. They are related to Cohen's d, but have an additional small sample bias correction factor.
Hope this helps!
@@LajeunesseLab Thanks for the quick response!
To be more concrete- say I take data from papers that reported the outcome as means, and for each study the scale which was used was a bit different, than I should convert them to Cohen's d or Hedges' g using the means and the variance to reach the point where the tutorial starts, right? (or are columns B and C in the tutorial just the data from the paper and columns D and E the ones doing that initial standardization of the effect sizes?)
@@דרורבןאפרים You are correct, to get the effect sizes used in the tutorial, you would need to extract the means, variances, and sample sizes of a treatment and control group to calculate a d or g for that study.
I provide examples of data extraction here: ua-cam.com/video/YUcSfV0BglY/v-deo.html
and examples of converting these raw data into effect sizes here: ua-cam.com/video/qp2pUZZX2CU/v-deo.html
Hope this helps!!
Hi, thanks for sharing.
D in the video = Cohen's d , right?
How to calculate the VAR_D?
thank you.
Perfect, thanks it is more helpful!
That is good , as have been doing My reach seminar, Thank you dear.
This was so useful thank you so so much
Dear, thank you very much for the video! It has been very useful for me.
I am trying to perform the analysis with a dichotomous estimator and calculating the aggregate relative risk. However, the lower end of the confidence interval is negative and I have not been able to get a result that is between 0 and 1. How can I fix this?
Thanks again!
Amazing, thank you so much
Thanks so much indeed. Have you uploaded these Excel work-files anywhere as templates? It would help to get hold of all those equations especially for health care workers like me who can't deal with math.
I have not uploaded any excel files as templates -- this is a good idea and I'll see what I can do
Again, another very well done video. What software do you use to make this presentation (the animated slides)?
I use OBS software to record live
I am just a beginner to do meta- analysis.Firstly, Study means citation 1,2,3 ; d means standarized mean and var D is what? I don't know how to get var D? Can you explain this?
Thank you for this great tutorial! Why don't use k (number of studies) in confidence interval?
Hai LajeunesseLab, What about the sign (-/+) in 'd' value? Does it affect totalling the D/Var?
yes the sign is important -- it a key part of the averaging and weighting
Thank You
Hi, I am struggling to run a metanalysis. It is my first time. I have continuous data with mean, sample size, and standard deviation for each study (without means for control and exposure groups.) Any ideas on the appropriate R argument suitable for this type of data?
Can you please interpret the results? It is found insignificant but what about the direction?
Love from India
🤣☕☕ meta analysis Olympics haha. Thx Doc
haha, I go for gold with the matrix algebra here:
ua-cam.com/video/nLOPWhO45dk/v-deo.html
@@LajeunesseLab watching👌🏽🔥 the video on meta analysis patents was neat. Stuff lay folks don't think about much. It's interesting...
How did you get all of those variances for your effect sizes?
When you extract the study outcomes from studies, they are often based on summary statistics like means, standard deviations, and sample sizes. With these, you can calculate effect sizes and their variances.
Yes, thank you for all of your help through the uses of the videos. I have constructed and submitted my charts already, thank you. It looked amazing. Thank you.
Also, would you happen to know another name that could be used as a title/header besides the title “conclusions” in a meta-analysis?
how the variance are calculated form ODDS 95% CI
this excel tutorial is the continuation of your meta analysis series?
Not really, in the series I mostly use R for meta-analysis, but I have colleagues who are on computers with limited software, and so I created these Excel tutorials for them since R is a headache for their systems
you are awesome
Thank you!
Hello, I have seen your videos on meta-analysis. I am having certain queries. Can you please provide me your email id, so that I can have words with you. Thanks in advance.
Perfect, thanks it is more helpful!
Glad it was helpful!
Thank you so much for this