tutorial on how to do a meta-analysis in Excel | Spreadsheet Synthesis

Here I outline how to conduct a fixed-effect and random-effects meta-analysis on effect size data (study outcomes) using Microsoft Excel.



00:00:00 A tutorial on how to calculate the following in Microsoft Excel:
00:01:50 fixed-effect meta-analysis (weighted mean)
00:05:18 95% confidence intervals
00:09:35 homogeneity test
00:17:00 between-study variance
00:19:28 random-effects meta-analysis

#excel
#meta-analysis
#LajeunesseLab

cite this video (follow figshare link for dataset):

Lajeunesse, M.J. (2021): Fixed effect, homogeneity tests, and random-effects meta-analysis in Microsoft Excel. figshare. Online resource. DOI: 10.6084/m9.figshare.14138087


playlist of other videos using Excel for research synthesis:
   • Spreadsheet Synthesis with Excel