Title
EX-TRACT: An excel tool for the estimation of standard deviations from published articles
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.
Year
DOI
Venue
2022
10.1016/j.envsoft.2021.105236
Environmental Modelling & Software
Keywords
DocType
Volume
Data extraction,Standard deviation,Meta-analysis,Excel© tool,ANOVA
Journal
147
ISSN
Citations 
PageRank 
1364-8152
0
0.34
References 
Authors
2
6
Name
Order
Citations
PageRank
Marco Acutis100.34
Tommaso Tadiello200.34
Alessia Perego300.34
Andrea Di Guardo400.34
Calogero Schillaci500.34
Elena Valkama600.34