EX-TRACT: An excel tool for the estimation of standard deviations from published articles. (January 2022)

• Record Type: Journal Article
• Authors: Acutis, Marco; Tadiello, Tommaso; Perego, Alessia; Di Guardo, Andrea; Schillaci, Calogero; Valkama, Elena
• Is Part Of: Environmental modelling & software. Volume 147(2022)
• Publication Date: 2022-01
• Subjects: Data extraction -- Standard deviation -- Meta-analysis -- Excel© tool -- ANOVA; Environmental monitoring -- Computer programs -- Periodicals; Ecology -- Computer simulation -- Periodicals; Digital computer simulation -- Periodicals; Computer software -- Periodicals; Environmental Monitoring -- Periodicals; Computer Simulation -- Periodicals; Environnement -- Surveillance -- Logiciels -- Périodiques; Écologie -- Simulation, Méthodes de -- Périodiques; Simulation par ordinateur -- Périodiques; Logiciels -- Périodiques; Computer software; Digital computer simulation; Ecology -- Computer simulation; Environmental monitoring -- Computer programs; Periodicals; Electronic journals; 363.70015118
• DOI: 10.1016/j.envsoft.2021.105236
• Languages: English
• ISSNs: 1364-8152

Abstract

Abstract: Meta-analysis, power analysis, and sensitivity analysis are widespread statistical techniques, which can be correctly performed only if variability statistics, such as standard deviation, are available; however, standard deviations are often missing in published articles. This work illustrates the functionality and the versatility of a newly developed Excel© tool for the standard deviation extraction from ANOVA and Multiple Comparison Test (MCT) results. The tool implements four methods, which can be alternatively applied according to the available statistics usually reported in ANOVA and/or MCT tables and graphs: 1) least significant difference (LSD), 2) significance level (p(F)), 3) letters for means separation assigned by MCT, 4) a range of significance level, indicated by "stars". The tool can be applied in one, two and three-way factorial experiments arranged in complete randomization, randomized block, split-plot or split-block. The performances of the different methods were tested in a case study about meta-analysis database preparation. Highlights: We developed a tool to extract standard deviation from ANOVA and post-hoc tests. The tool implements four methods, using different input information. The tool handles factorial ANOVA in the most common experimental schemes. The tool allows to double the number of studies suitable for a meta-analysis.