{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Choose Statistical Test"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Choose Statistical Test","index":0,"n_rows":27,"n_cols":124,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aim.of.test ","Type.of.comparison","Tested.Variable","Number.of.groups","Times.of.measures","Qualitative","Quantitative","Type.of.relationship","Prediction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comparison","Between groups","Quantitative","2 groups","2 times","2 Classes","Normally distributed","Association","Quantitative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relationship","Within group","Qualitative","> 2 groups","> 2 times","> 2 classes","Not Normally distributed","Prediction","Qualitative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time to event"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Statistical Test Decision Tree Algorithm"]
[null,null,null,"This tool can be used easily, just choose from the drop list what suits your research question till all required cells are coloured green\n\nDon't forget to use the reset button at the bottom whenever you changed any choice"]
[]
[null,null,null,"Aim of the test"]
[]
[]
[null,null,{"$f":"IF(D18=\"Comparison\",\"Comparison.Type\",IF(D18=\"Relationship\",\"Relationship.Type\",\" \"))","v":" "},null,{"$f":"IF(D18=\"Comparison\",\"Tested.Variable\",\" \")","v":" "}]
[]
[]
[null,null,{"$f":"IF(C21=\"prediction\",\"Outcome.Type\",IF(C21=\"Between groups\",\"Number.of.groups\",IF(C21=\"Within group\",\"Times.of.measures\",IF(C21=\"Association\",\"Distribution\",\" \"))))","v":" "},null,{"$f":"IF(E21=\"Quantitative\",\"Distribution\",IF(E21=\"Qualitative\",\"Classes\",\" \"))","v":" "}]
[]
[]
[null,null,null,"Statistical Test"]
[null,null,null,{"$f":"IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"quantitative\",C24=\"> 2 groups\",E24=\"normally distributed\"),\"ANOVA Test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"quantitative\",C24=\"2 groups\",E24=\"normally distributed\"),\"Unpaired t test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"quantitative\",C24=\"> 2 groups\",E24=\"not normally distributed\"),\"Kruskal-Wallis Test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"quantitative\",C24=\"2 groups\",E24=\"Not normally distributed\"),\"Mann-Whitney U Test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"qualitative\",C24=\"> 2 groups\"),\"Chi-square Test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"qualitative\",C24=\"2 groups\",E24=\"> 2 classes\"),\"Chi-square Test\",IF(AND(D18=\"Comparison\",(C21=\"between groups\"),E21=\"qualitative\",C24=\"2 groups\",E24=\"2 classes\"),\"Chi-square Test or Fisher's exact Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"quantitative\",C24=\"2 times\",E24=\"normally distributed\"),\"Paired t test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"quantitative\",C24=\"> 2 times\",E24=\"normally distributed\"),\"Repeated Measures ANOVA\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"quantitative\",C24=\"2 times\",E24=\"Not normally distributed\"),\"Wilcoxon Signed Rank Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"quantitative\",C24=\"> 2 times\",E24=\"Not Normally distributed\"),\"Friedman Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"qualitative\",C24=\"2 times\",E24=\"2 classes\"),\"McNemar Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"qualitative\",C24=\"2 times\",E24=\"> 2 classes\"),\"McNemar-Bowker Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"qualitative\",C24=\"> 2 times\",E24=\"2 classes\"),\"Cochran Q Test\",IF(AND(D18=\"Comparison\",(C21=\"within group\"),E21=\"qualitative\",C24=\"> 2 times\",E24=\"> 2 classes\"),\"Friedman Test\",IF(AND(D18=\"Relationship\",(C21=\"Association\"),C24=\"Normally distributed\"),\"Pearson Correlation Coefficient\",IF(AND(D18=\"Relationship\",(C21=\"Association\"),C24=\"Not Normally distributed\"),\"Spearman Rank Correlation Coefficient\",IF(AND(D18=\"Relationship\",(C21=\"Prediction\"),C24=\"Quantitative\"),\"Linear Regression\",IF(AND(D18=\"Relationship\",(C21=\"Prediction\"),C24=\"Qualitative\"),\"Logistic Regression\",IF(AND(D18=\"Relationship\",(C21=\"Prediction\"),C24=\"Time to event\"),\"Cox Regression\",\" \"))))))))))))))))))))","v":" "}]