Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis

<p>Abstract</p> <p>Background</p> <p>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.</p> <p>Findings</p> <p>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.</p> <p>Conclusions</p> <p>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.</p

Impact of chronic stress protocols in learning and memory in rodents: systematic review and meta-analysis

The idea that maladaptive stress impairs cognitive function has been a cornerstone of decades in basic and clinical research. However, disparate findings have reinforced the need to aggregate results from multiple sources in order to confirm the validity of such statement. In this work, a systematic review and meta-analyses were performed to aggregate results from rodent studies investigating the impact of chronic stress on learning and memory. Results obtained from the included studies revealed a significant effect of stress on global cognitive performance. In addition, stressed rodents presented worse consolidation of learned memories, although no significantly differences between groups at the acquisition phase were found. Despite the methodological heterogeneity across studies, these effects were independent of the type of stress, animals' strains or age. However, our findings suggest that stress yields a more detrimental effect on spatial navigation tests' performance. Surprisingly, the vast majority of the selected studies in this field did not report appropriate statistics and were excluded from the quantitative analysis. We have therefore purposed a set of guidelines termed PROBE (Preferred Reporting Orientations for Behavioral Experiments) to promote an adequate reporting of behavioral experiments.This work was funded by the European Commission (FP7) "SwitchBox" (Contract HEALTH-F2-2010-259772) project and co-financed by the Portuguese North Regional Operational Program (ON.2 - O Novo Norte) under the National Strategic Reference Framework (QREN), through the European Regional Development Fund (FEDER), and by Fundacao Calouste Gulbenkian (Portugal) (Contract grant number: P-139977; project "Better mental health during ageing based on temporal prediction of individual brain ageing trajectories (TEMPO)"). PSM is supported by an FCT fellowship grant, from the PhD-iHES program, with the reference PDE/BDE/113601/2015.info:eu-repo/semantics/publishedVersio