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.

EX-TRACT: An excel tool for the estimation of standard deviations from published articles / M. Acutis, T. Tadiello, A. Perego, A. Di Guardo, C. Schillaci, E. Valkama. - In: ENVIRONMENTAL MODELLING & SOFTWARE. - ISSN 1364-8152. - 147(2022), pp. 105236.1-105236.9. [10.1016/j.envsoft.2021.105236]

EX-TRACT: An excel tool for the estimation of standard deviations from published articles

M. Acutis;T. Tadiello;A. Perego;C. Schillaci;
2022

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.
Data extraction; Standard deviation; Meta-analysis; Excel© tool; ANOVA
Settore AGR/02 - Agronomia e Coltivazioni Erbacee
Settore SECS-S/01 - Statistica
Settore BIO/07 - Ecologia
2022
2-nov-2021
Article (author)
File in questo prodotto:
File Dimensione Formato  
Acutis et al 2022.pdf

accesso aperto

Tipologia: Publisher's version/PDF
Dimensione 1.74 MB
Formato Adobe PDF
1.74 MB Adobe PDF Visualizza/Apri
Pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/2434/895937
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 4
  • ???jsp.display-item.citation.isi??? 4
social impact