Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis
Tóm tắt
Meta-analyses are necessary to synthesize data obtained from primary research, and in many situations reviews of observational studies are the only available alternative. General purpose statistical packages can meta-analyze data, but usually require external macros or coding. Commercial specialist software is available, but may be expensive and focused in a particular type of primary data. Most available softwares have limitations in dealing with descriptive data, and the graphical display of summary statistics such as incidence and prevalence is unsatisfactory. Analyses can be conducted using Microsoft Excel, but there was no previous guide available. We constructed a step-by-step guide to perform a meta-analysis in a Microsoft Excel spreadsheet, using either fixed-effect or random-effects models. We have also developed a second spreadsheet capable of producing customized forest plots. It is possible to conduct a meta-analysis using only Microsoft Excel. More important, to our knowledge this is the first description of a method for producing a statistically adequate but graphically appealing forest plot summarizing descriptive data, using widely available software.
Tài liệu tham khảo
Stroup DF, Berlin JA, Morton SC, et al.: Meta-analysis of observational studies in epidemiology: a proposal for reporting. Meta-analysis Of Observational Studies in Epidemiology (MOOSE) group. JAMA. 2000, 283: 2008-12. 10.1001/jama.283.15.2008.
Copenhagen: The Nordic Cochrane Centre, The Cochrane Collaboration, 2011. Review Manager (RevMan) [Computer program]. Version 5.1. [http://ims.cochrane.org/revman]
Rosenberg M: MetaWin: Statistical Software for Meta-Analysis Version 2. 2000, Sunderland, Massachusetts: Sinauer Associates, [http://www.metawinsoft.com]
Borenstein M, Hedges L, Higgins J, Rothstein H: Comprehensive Meta-analysis Version 2. 2005, Biostat, Englewood NJ, [http://www.meta-analysis.com]
Bax L, Yu L-M, Ikeda N, et al.: Development and validation of MIX: comprehensive free software for meta-analysis of causal research data. BMC Med Res Methodol. 2006, 6: 50-10.1186/1471-2288-6-50.
Eddy DM: FAST*PRO: Software for meta-analysis by the confidence profile method. 1992, Academic Press
Wallace BC, Schmid CH, Lau J, et al.: Meta-Analyst: software for meta-analysis of binary, continuous and diagnostic data. BMC Med Res Methodol. 2009, 9: 80-10.1186/1471-2288-9-80.
Borenstein M, Hedges LV, Higgins JPT, et al.: Introduction to Meta-Analysis. 2009, Wiley, 1
Lipsey MW, Wilson D: Practical Meta-Analysis. 2000, Sage Publications, Inc, 1
Egger M, Smith GD, Altman D: Systematic Reviews in Health Care: Meta-Analysis in Context. 2001, BMJ Books, 2
Schriger DL, Altman DG, Vetter JA, et al.: Forest plots in reports of systematic reviews: a cross-sectional study reviewing current practice. Int J Epidemiol. 2010, 39: 421-9. 10.1093/ije/dyp370.
Higgins JPT, Thompson SG, Deeks JJ, et al.: Measuring inconsistency in meta-analyses. BMJ. 2003, 327: 557-60. 10.1136/bmj.327.7414.557.