Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis
By J. Neyeloff, S. Fuchs, L. Moreira. BMC Research Notes, 2012
734 citations recorded by the source corpus.
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.
Subfields: Health, Toxicology and Mutagenesis, Nature and Landscape Conservation, Plant Science
View Paper: https://www.semanticscholar.org/paper/f80c4fea6adb00af41dc4fb892390ec20a721c4b
How researchers see this paper
The researchers whose trusted networks rank it highest, strongest advocate first. Every researcher gets a different order.
In Health, Toxicology and Mutagenesis
In Nature and Landscape Conservation
In Plant Science
Citations in the corpus
- The Incidence and Prevalence of Ankle Sprain Injury: A Systematic Review and Meta-Analysis of Prospective Epidemiological Studies (2013, methodology): “Data were then assessed for heterogeneity using Microsoft Excel 2010 [31], based on the Q test in conjunction with the I statistic.”
- Social influence approaches to encourage resource conservation: A meta-analysis (2013, background): “a control group (using an Excel spread sheet provided in Neyeloff et al., 2012). W. Abrahamse, L. Steg / Global Environmental Change 23 (2013) 1773–1785 1782”