{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Statistic protocol"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Statistic protocol","index":0,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[[29,19,35,20],[27,12,32,14],[54,1,59,3],[56,9,57,9],[56,4,58,8],[48,1,52,3],[48,4,52,8],[51,12,59,14],[55,18,56,18],[58,18,59,18],[41,12,45,14],[42,4,43,6],[45,4,46,6],[42,7,43,10],[45,7,46,10],[58,19,59,20],[55,19,56,20],[41,15,42,17],[55,15,59,17],[44,15,45,17],[41,18,42,20],[44,18,45,20],[51,18,52,19],[51,15,52,17],[42,1,46,3],[24,1,36,3],[40,1,40,11],[40,12,40,20],[34,9,37,12],[24,4,28,8],[27,15,29,15],[30,15,32,15],[46,12,50,14],[47,15,49,19],[32,4,36,8],[20,9,32,11],[20,12,25,14],[21,17,27,18],[21,19,27,20],[29,17,35,18],[21,1,23,3],[3,10,5,10],[7,10,16,10],[8,14,10,15],[12,14,14,15],[15,11,16,12],[18,1,19,20],[20,15,22,15],[23,15,25,15],[1,1,1,20],[14,17,14,18],[6,3,6,6],[7,3,7,7],[8,3,8,8],[9,3,9,6],[8,17,8,18],[10,17,10,18],[12,17,12,18],[8,19,10,20],[3,12,4,17],[5,12,5,17],[8,11,14,12],[10,2,14,8],[5,1,14,1]]}
[]
[null,"INSTRUCTIONS: Click on the options that better fit your data and statistical target. The file will guide you through the protocol until suggesting which would be the most appropriate test for you"]
[]
[null,null,null,null,null,null,null,null,null,null,"The variable is invalid",null,"The necessary measures have been taken to make the variable valid (cells D12-D14)"]
[]
[null,"CLICK HERE TO START\n\nVariable reliability",null,null,null,null,null,null,null,null,null,null,"The variable is definitely invalid"]
[null,null,null,"The variable has no statistical interest OR"]
[null,null,null,"The variable is not numeric and cannot be classified into categories OR",null,null,null,null,null,null,"The variable is valid"]
[null,null,null,"The percentage of replicates with available and/or reliable data is less than 50% OR",null,null,null,null,null,null,null,"The variable is qualitative",null,null,"The variable is nominal",null,null,"It cannot be converted to ordinal",null,"Only simple data grouping, percentage calculations and subjective inferences can be made"]
[null,null,null,"More than 50% of the replicates are outliers"]
[null,null,"The variable has statistical interest AND\nThe variable is numeric / can be classified \ninto categories AND\nThe percentage of replicates with available and/or reliable data is greater than 50% AND\nLess than 50% of the replicates are outliers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"It can be converted to ordinal"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The variable is ordinal",null,null,"It cannot be converted to quantitative"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"It can be converted to quantitative"]
[null,null,null,null,null,null,null,null,null,null,null,"The variable is quantitative"]
[]
[]
[null,"                       Analysis for ONE variable                                Comparisons between TWO variables            Comparisons of MORE THAN TWO variables"]
[]
[null,null,null,null,null,null,null,null,null,"The data follow \na normal distribution (Shapiro-Wilk test, α=0,01)",null,null,"The variances of \nboth variables are homogeneous \n(Levene test, α=0,05)",null,null,"CORRELATION ANALYSIS"]
[null,"The data follow a normal distribution (Shapiro-Wilk test, α=0,01)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bidimensional display ",null,"Cladogram display"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNIFICANT ANALYSIS"]
[null,"The data do not follow \na normal distribution (Shapiro-Wilk test, \nα=0,01)",null,null,"A mathematical transformation converts the data to normal"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"The variances of \nboth variables are \nnot homogeneous (Levene test, α=0,05)",null,null,"CORRELATION ANALYSIS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Principal Component\nAnalysis (PCA)",null,"Cluster analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNIFICANT ANALYSIS"]
[]
[null,null,null,null,"A mathematical transformation does not convert the data to normal"]
[]
[null,null,null,null,null,null,null,null,null,"The data do not follow a normal distribution (Shapiro-Wilk test, α=0,01)"]
[]
[]
[]
[]
[]
[null,"Parametric analysis\n(for significant tests, post hoc comparisons will be at the user´s choice; α=0,05)",null,null,null,null,null,null,null,null,null,null,"Non parametric analysis \n(for significant tests, post hoc comparisons will be at the user´s choice; α=0,05)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"To detect differences between independent samples",null,null,"Comparison of means in \ntwo samples",null,null,"Kolmogorov-Smirnov for 2 samples test  (α=0,01)"]
[null,"To detect differences between independent samples",null,null,"Comparison of means in \ntwo samples",null,null,"Student´s t test  (α=0,01)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comparison of means \nin more than two samples",null,null,"Kruskal-Wallis test by ranks (α=0,01)"]
[null,null,null,null,"Comparison of means \nin more than two samples",null,null,"One-way ANOVA (α=0,01)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"To detect differences between dependent samples (including dichotomous ones)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cochran´s Q test (α=0,01)"]
[null,"To detect differences between dependent samples (including dichotomous ones)",null,null,"Repeated measures ANOVA (α=0,01)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"To detect correlations \nbetween variables",null,null,"Non-categorical variables",null,null,"Spearman's R2 correlation coefficient"]
[]
[]
[null,"To detect correlations between variables"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Categorical variables",null,null,"2 variables","Pearson's chi-squared test "]
[null,null,null,null,"Pearson correlacion coefficient"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 2 variables","Kendall coefficient of concordance "]