{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Cohen's d","T-Test of Independent Means","Cohen's d-A","T-Test of Independent Means-A"],"not_rendered":{"charts":0,"images":13,"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":"Title","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculation practice activities to accompany\nCHAPTER 7"]
[]
[null,null,"Social Statistics in Action: A Canadian Introduction"]
[null,null,"Andrea M. Noack"]
[]
[null,null,"Oxford University Press, 2018"]
[]
[null,null,"For more information, visit: "]
[null,null,"https://www.oupcanada.com/catalog/9780199015214.html"]

{"sheet":"Cohen's d","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,2,10],[0,1,0,10],[5,1,5,2],[5,4,5,5],[6,1,7,1],[6,2,7,2],[6,4,7,4],[6,5,7,5]]}
[null,"PRACTICE CALCULATING COHEN'S D"]
[]
[null,"Use the statistics provided to calculate Cohen's d. \nKeep two decimal places throughout your calculations. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"GROUP 1",null,null,"GROUP 2"]
[null,"Case #","Value on \nVariable X",null,"Case #","Value on \nVariable X"]
[null,null,null,null,null,null,null,"Group 1 Mean (x-bar1):",17]
[null,1,21,null,11,23,null,"Group 2 Mean (x-bar2):",15]
[null,2,4,null,12,22,null,"Standard deviation [overall] (s):",9.57]
[null,3,4,null,13,7]
[null,4,31,null,14,17,null,"Cohen's d:","hidden"]
[null,5,17,null,15,27]
[null,6,18,null,16,9]
[null,7,9,null,17,18]
[null,8,12,null,18,2,null,"Need some help?"]
[null,9,39,null,19,17]
[null,10,15,null,20,8]
[]
[null,"COHEN'S D CALCULATION"]
[null,"Numerator"]
[null,null,null,"= 17 - 15"]
[null,null,null,"= ?"]
[null,"Denominator"]
[null,null,null,"= 9.57"]
[null,"Cohen's d"]
[null,null,null,"= 2 ÷ 9.57"]
[null,null,null,"= ?"]

{"sheet":"T-Test of Independent Means","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,11],[2,1,2,11],[12,7,12,9],[16,7,16,9],[4,1,4,2],[4,4,4,5],[11,7,11,9],[5,8,6,8],[5,9,6,9],[5,7,6,7],[5,1,6,1],[5,2,6,2],[5,4,6,4],[5,5,6,5]]}
[null,"PRACTICE CALCULATING A T-TEST OF INDEPENDENT MEANS"]
[]
[null,"Use the statistics provided for each group to calculate the t-statistic and the degrees of freedom of the t-statistic. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' buttons."]
[]
[null,"GROUP 1",null,null,"GROUP 2"]
[null,"Case #","Value on \nVariable X",null,"Case #","Value on \nVariable X",null,null,"Group 1 \nStatistics","Group 2 \nStatistics"]
[]
[null,1,13,null,11,14,null,"Mean (x-bar):",26.4,17.2]
[null,2,29,null,12,18,null,"Variance (s2):",71.16,64.400000000000006]
[null,3,35,null,13,29,null,"Standard Deviation (s):",8.44,8.02]
[null,4,25,null,14,15,null,"Number of Cases (n):",10,10]
[null,5,27,null,15,26]
[null,6,34,null,16,1,null,"T-statistic"]
[null,7,18,null,17,13,null,"Degrees of freedom:",null,"hidden"]
[null,8,16,null,18,24,null,"T-statistic:",null,"hidden"]
[null,9,38,null,19,19]
[null,10,29,null,20,13,null,"If the T-statistic is beyond +/-2.1 then p<0.05."]
[]
[null,null,null,null,null,"Need some help?"]
[]
[null,"T-STATISTIC CALCULATION"]
[null,"Numerator"]
[null,null,null,"= 26.4 - 17.2"]
[null,null,null,"= ?"]
[null,"Denominator"]
[null,null,null,"= square root of [(71.16 ÷ 10) + (64.4 ÷ 10)]"]
[null,null,null,"= square root of (? + ?)"]
[null,null,null,"= square root of ?"]
[null,null,null,"= ?"]
[null,"T-Statistic"]
[null,null,null,"= 9.2 ÷ 3.68"]
[null,null,null,"= ?"]
[]
[null,"DEGREES OF FREEDOM OF THE T-STATISTIC CALCULATION"]
[null,"Numerator"]
[null,null,null,"= [(71.16 ÷ 10) + (64.4 ÷ 10)]²"]
[null,null,null,"= ( ? + ?)²"]
[null,null,null,"= ?²"]
[null,null,null,"= ?"]
[null,"Denominator"]
[null,null,null,"= [(71.16 ÷ 10)² ÷ (10 - 1)] + [(64.4 ÷ 10)² ÷ (10 - 1)]"]
[null,null,null,"= (?² ÷ ?) + (?² ÷ ?)"]
[null,null,null,"=(? ÷ ?) + (? ÷ ?)"]
[null,null,null,"= ? + ?"]
[null,null,null,"= ?"]
[null,"Degrees of Freedom"]
[null,null,null,"= 183.87 ÷ 10.24"]
[null,null,null,"= ? (round to ?)"]

{"sheet":"Cohen's d-A","index":3,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,1,0,10],[2,1,2,10],[5,1,5,2],[5,4,5,5]]}
[null,"PRACTICE CALCULATING COHEN'S D"]
[]
[null,"Calculate Cohen's d. \nKeep two decimal places in your calculations. \nTo check your answers, click on the 'Show Cohen's d' button."]
[]
[]
[null,"GROUP 1",null,null,"GROUP 2"]
[null,"Case #","Value",null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,40)","v":20},1,21,{"$f":"RANDBETWEEN(1,30)","v":11},11,23,null,"Group 1 Mean",{"$f":"ROUND(AVERAGE(C8:C17),2)","v":17},null,{"$f":"ROUND(C8-$I$11,2)","v":5},{"$f":"ROUND(K8*K8,2)","v":25}]
[{"$f":"RANDBETWEEN(1,40)","v":14},2,4,{"$f":"RANDBETWEEN(1,30)","v":26},12,22,null,"Group 2 Mean",{"$f":"ROUND(AVERAGE(F8:F17),2)","v":15},null,{"$f":"ROUND(C9-$I$11,2)","v":-12},144]
[5,3,4,13,13,7,null,"Standard deviation (overall)",{"$f":"L30","v":9.57},null,-12,144]
[11,4,31,28,14,17,null,null,{"$f":"ROUND(AVERAGE(C8:C17,F8:F17),2)","v":16},null,15,225]
[14,5,17,18,15,27,null,"Cohen's d",{"$f":"F28","v":0.21},null,1,1]
[29,6,18,10,16,9,null,null,null,null,2,4]
[22,7,9,4,17,18,null,null,null,null,-7,49]
[25,8,12,21,18,2,null,"Need some help?",null,null,-4,16]
[27,9,39,24,19,17,null,null,null,null,23,529]
[25,10,15,9,20,8,null,null,null,null,-1,1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F8-$I$11,2)","v":7},49]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F9-$I$11,2)","v":6},36]
[null,"COHEN'S D CALCULATION",null,null,null,null,null,null,null,null,-9,81]
[null,"Numerator",null,null,null,null,null,null,null,null,1,1]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I8,\" - \",I9)","v":"'= 17 - 15"},null,null,null,null,null,null,11,121]
[null,null,null,{"$f":"CONCATENATE(\"'= \",F23)","v":"'= 2"},null,{"$f":"ROUND(I8-I9,2)","v":2},null,null,null,null,-7,49]
[null,"Denominator",null,null,null,null,null,null,null,null,2,4]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I10)","v":"'= 9.57"},null,null,null,null,null,null,-14,196]
[null,"Cohen's d",null,null,null,null,null,null,null,null,1,1]
[null,null,null,{"$f":"CONCATENATE(\"'= \",F23,\" ÷ \",I10)","v":"'= 2 ÷ 9.57"},null,null,null,null,null,null,{"$f":"ROUND(F17-$I$11,2)","v":-8},64]
[null,null,null,{"$f":"CONCATENATE(\"'= \",F28)","v":"'= 0.21"},null,{"$f":"ROUND(F23/I10,2)","v":0.21},null,null,null,null,null,{"$f":"ROUND(SUM(L8:L27),2)","v":1740}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L28/19,2)","v":91.58}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT(L29),2)","v":9.57}]

{"sheet":"T-Test of Independent Means-A","index":4,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[[11,7,11,9],[12,7,12,9],[16,7,16,9],[0,1,0,11],[2,1,2,11],[5,1,5,2],[5,4,5,5],[5,7,6,7],[5,8,6,8],[5,9,6,9]]}
[null,"PRACTICE CALCULATING A T-TEST OF INDEPENDENT MEANS"]
[]
[null,"Calculate the between group sum of squares, the within group sum of squares, the total sum of squares, the degrees of freedom and the F-statistic. \nKeep two decimal places in your calculations. \nTo check your answers, click on the 'Show Sum of Squares' and/or 'Show F-Statistic' buttons."]
[]
[]
[null,"GROUP 1",null,null,"GROUP 2",null,null,null,"Group 1 \nStatistics","Group 2 \nStatistics"]
[null,"Case #","Value",null,"Case #","Value"]
[{"$f":"RANDBETWEEN(10,40)","v":25},1,13,{"$f":"RANDBETWEEN(1,30)","v":16},11,14,null,"Mean",{"$f":"ROUND(AVERAGE(C8:C17),2)","v":26.4},{"$f":"ROUND(AVERAGE(F8:F17),2)","v":17.2},null,{"$f":"ROUND(C8-$I$8,2)","v":-13.4},{"$f":"ROUND(L8*L8,2)","v":179.56},{"$f":"ROUND(F8-$J$8,2)","v":-3.2},{"$f":"ROUND(N8*N8,2)","v":10.24}]
[{"$f":"RANDBETWEEN(10,40)","v":29},2,29,{"$f":"RANDBETWEEN(1,30)","v":25},12,18,null,"Variance (s2)",{"$f":"M19","v":71.16},{"$f":"O19","v":64.400000000000006},null,{"$f":"ROUND(C9-$I$8,2)","v":2.6},{"$f":"ROUND(L9*L9,2)","v":6.76},{"$f":"ROUND(F9-$J$8,2)","v":0.8},{"$f":"ROUND(N9*N9,2)","v":0.64}]
[18,3,35,28,13,29,null,"Standard Deviation (s)",{"$f":"M20","v":8.44},{"$f":"O20","v":8.02},null,8.6,73.959999999999994,11.8,139.24]
[28,4,25,8,14,15,null,"Number of Cases",10,10,null,-1.4,1.96,-2.2000000000000002,4.84]
[16,5,27,25,15,26,null,null,null,null,null,0.6,0.36,8.8000000000000007,77.44]
[40,6,34,23,16,1,null,"T-statistic",null,null,null,7.6,57.76,-16.2,262.44]
[33,7,18,13,17,13,null,"Degrees of freedom",null,{"$f":"J48","v":18},null,-8.4,70.56,-4.2,17.64]
[24,8,16,8,18,24,null,"T-statistic",null,{"$f":"I32","v":2.5},null,-10.4,108.16,6.8,46.24]
[20,9,38,20,19,19,null,null,null,null,null,11.6,134.56,1.8,3.24]
[18,10,29,20,20,13,null,{"$f":"CONCATENATE(\"If the T-statistic is beyond +/-\",J49,\" then p<0.05.\")","v":"If the T-statistic is beyond +/-2.1 then p<0.05."},null,null,null,2.6,6.76,-4.2,17.64]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(M8:M17),2)","v":640.4},null,{"$f":"ROUND(SUM(O8:O17),2)","v":579.6}]
[null,null,null,null,null,"Need some help?",null,null,null,null,null,null,{"$f":"ROUND(M18/9,2)","v":71.16},null,{"$f":"ROUND(O18/9,2)","v":64.400000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT(M19),2)","v":8.44},null,{"$f":"ROUND(SQRT(O19),2)","v":8.02}]
[null,"T-STATISTIC CALCULATION"]
[null,"Numerator"]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I8,\" - \",J8)","v":"'= 26.4 - 17.2"}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I24)","v":"'= 9.2"},null,null,null,null,{"$f":"I8-J8","v":9.1999999999999993}]
[null,"Denominator"]
[null,null,null,{"$f":"CONCATENATE(\"'= square root of [(\",I9,\" ÷ 10) + (\",J9,\" ÷ 10)]\")","v":"'= square root of [(71.16 ÷ 10) + (64.4 ÷ 10)]"}]
[null,null,null,{"$f":"CONCATENATE(\"'= square root of (\",I27,\" + \",J27,\")\")","v":"'= square root of (7.12 + 6.44)"},null,null,null,null,{"$f":"ROUND(I9/10,2)","v":7.12},{"$f":"ROUND(J9/10,2)","v":6.44}]
[null,null,null,{"$f":"CONCATENATE(\"'= square root of \",I28)","v":"'= square root of 13.56"},null,null,null,null,{"$f":"ROUND(I27+J27,2)","v":13.56}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I29)","v":"'= 3.68"},null,null,null,null,{"$f":"ROUND(SQRT(I28),2)","v":3.68}]
[null,"T-Statistic"]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I24,\" ÷ \",I29)","v":"'= 9.2 ÷ 3.68"}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I32)","v":"'= 2.5"},null,null,null,null,{"$f":"ROUND(I24/I29,2)","v":2.5}]
[]
[null,"DEGREES OF FREEDOM OF THE T-STATISTIC CALCULATION"]
[null,"Numerator"]
[null,null,null,{"$f":"CONCATENATE(\"'= [(\",I9,\" ÷ 10) + (\",J9,\" ÷ 10)]\",I36)","v":"'= [(71.16 ÷ 10) + (64.4 ÷ 10)]²"},null,null,null,null,"²"]
[null,{"$f":"CONCATENATE(\"'= ( ? + ?)\",I36)","v":"'= ( ? + ?)²"},null,{"$f":"CONCATENATE(\"'= (\",I37,\" + \",J37,\")\",I36)","v":"'= (7.12 + 6.44)²"},null,null,null,null,{"$f":"I27","v":7.12},{"$f":"J27","v":6.44}]
[null,{"$f":"CONCATENATE(\"'= ?\",I36)","v":"'= ?²"},null,{"$f":"CONCATENATE(\"'= \",I38,I36)","v":"'= 13.56²"},null,null,null,null,{"$f":"I28","v":13.56}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I39)","v":"'= 183.87"},null,null,null,null,{"$f":"ROUND(I38*I38,2)","v":183.87}]
[null,"Denominator"]
[null,null,null,{"$f":"CONCATENATE(\"'= [(\",I9,\" ÷ 10)\",I36,\" ÷ (10 - 1)] + [(\",J9,\" ÷ 10)\",I36,\" ÷ (10 - 1)]\")","v":"'= [(71.16 ÷ 10)² ÷ (10 - 1)] + [(64.4 ÷ 10)² ÷ (10 - 1)]"}]
[null,{"$f":"CONCATENATE(\"'= (?\",I36,\" ÷ ?) + (?\",I36,\" ÷ ?)\")","v":"'= (?² ÷ ?) + (?² ÷ ?)"},null,{"$f":"CONCATENATE(\"'= (\",I42,I36,\" ÷ 9) + (\",J42,I36,\" ÷ 9)\")","v":"'= (7.12² ÷ 9) + (6.44² ÷ 9)"},null,null,null,null,{"$f":"I37","v":7.12},{"$f":"J37","v":6.44}]
[null,null,null,{"$f":"CONCATENATE(\"'= (\",I43,\" ÷ 9) + (\",J43,\" ÷ 9)\")","v":"'= (50.69 ÷ 9) + (41.47 ÷ 9)"},null,null,null,null,{"$f":"ROUND(I42*I42,2)","v":50.69},{"$f":"ROUND(J42*J42,2)","v":41.47}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I44,\" + \",J44)","v":"'= 5.63 + 4.61"},null,null,null,null,{"$f":"ROUND(I43/9,2)","v":5.63},{"$f":"ROUND(J43/9,2)","v":4.6100000000000003}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I45)","v":"'= 10.24"},null,null,null,null,{"$f":"ROUND(SUM(I44:J44),2)","v":10.24}]
[null,"Degrees of Freedom"]
[null,null,null,{"$f":"CONCATENATE(\"'= \",I39,\" ÷ \",I45)","v":"'= 183.87 ÷ 10.24"}]
[null,null,null,{"$f":"CONCATENATE(\"'=\",I48,\" (round to \",J48,\")\")","v":"'=17.96 (round to 18)"},null,null,null,null,{"$f":"ROUND(I39/I45,2)","v":17.96},{"$f":"ROUND(I48,0)","v":18}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(_xlfn.T.INV.2T(0.05,J48),2)","v":2.1}]