{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","Mean","Variance & Std Dev-pop. data","Z-scores"," Variance & Std Deviation-A","Z-scores-A","Mean-A"],"not_rendered":{"charts":0,"images":15,"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 4"]
[]
[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":"Mean","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,4,9,5],[2,1,2,7],[0,1,0,7]]}
[null,"PRACTICE CALCULATING MEANS"]
[]
[null,"Calculate the mean (average) of the values in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on\nVariable X"]
[null,1,14,null,"Number of Cases (N):",12]
[null,2,15,null,"Mean:","hidden"]
[null,3,3]
[null,4,12,null,"Need some help?"]
[null,5,11]
[null,6,16]
[null,7,6]
[null,8,20]
[null,9,4]
[null,10,9]
[null,11,5]
[null,12,7]
[]
[null,"MEAN CALCULATION"]
[null,"Numerator"]
[null,null,"= 14 + 15 + 3 + 12 + 11 + 16 + 6 + 20 + 4 + 9 + 5 + 7"]
[null,null,"= ?"]
[null,"Denominator"]
[null,null,"= 12"]
[null,"Mean"]
[null,null,"= 122 ÷ 12"]
[null,null,"= ?"]

{"sheet":"Variance & Std Dev-pop. data","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,6,39,7],[40,6,40,7],[41,6,41,7],[32,3,32,4],[32,6,32,7],[33,6,33,7],[34,6,34,7],[36,6,36,7],[37,6,37,7],[29,3,29,4],[29,6,29,7],[30,3,30,4],[30,6,30,7],[31,3,31,4],[31,6,31,7],[26,3,26,4],[26,6,26,7],[27,3,27,4],[27,6,27,7],[28,3,28,4],[28,6,28,7],[23,3,23,4],[23,6,23,7],[24,3,24,4],[24,6,24,7],[25,3,25,4],[25,6,25,7],[22,3,22,4],[22,6,22,7],[0,1,0,8],[2,1,2,8],[6,4,6,5],[7,4,7,5],[9,4,9,5],[10,4,10,5],[13,4,13,5],[20,3,20,4],[20,6,20,7],[21,3,21,4],[21,6,21,7]]}
[null,"PRACTICE CALCULATING VARIANCE AND STANDARD DEVIATION (POPULATION DATA)"]
[]
[null,"Calculate the variance and standard deviation of the values in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button. "]
[]
[]
[null,"Case #","Value on\nVariable X"]
[null,1,20,null,"Number of Cases (N):",null,12]
[null,2,20,null,"Mean (X-bar):",null,12.58]
[null,3,9]
[null,4,8,null,"Variance:",null,"hidden"]
[null,5,10,null,"Standard Deviation:",null,"hidden"]
[null,6,7]
[null,7,8]
[null,8,13,null,"Need some help?"]
[null,9,20]
[null,10,7]
[null,11,9]
[null,12,20]
[]
[null,"VARIANCE AND STANDARD DEVIATION CALCULATIONS"]
[null,"Case #","Value \n","Mean\n",null,"Value - Mean\n","(Value-Mean)2\n"]
[null,1,20,12.58,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]
[null,2,20,12.58,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]
[null,3,9,12.58,null,"9 - 12.58 = ?","-3.58 x -3.58 = ?"]
[null,4,8,12.58,null,"8 - 12.58 = ?","-4.58 x -4.58 = ?"]
[null,5,10,12.58,null,"10 - 12.58 = ?","-2.58 x -2.58 = ?"]
[null,6,7,12.58,null,"7 - 12.58 = ?","-5.58 x -5.58 = ?"]
[null,7,8,12.58,null,"8 - 12.58 = ?","-4.58 x -4.58 = ?"]
[null,8,13,12.58,null,"13 - 12.58 = ?","0.42 x 0.42 = ?"]
[null,9,20,12.58,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]
[null,10,7,12.58,null,"7 - 12.58 = ?","-5.58 x -5.58 = ?"]
[null,11,9,12.58,null,"9 - 12.58 = ?","-3.58 x -3.58 = ?"]
[null,12,20,12.58,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]
[null,null,null,null,null,"Column Sum (Σ)","= 356.96"]
[null,null,null,null,null,"N","= 12"]
[null,null,null,null,null,"Variance"]
[null,null,null,null,null,null,"= 356.96 ÷ 12"]
[null,null,null,null,null,null,"= ?"]
[null,null,null,null,null,"Std. Deviation"]
[null,null,null,null,null,null,"= square root of (356.96 ÷ 12)"]
[null,null,null,null,null,null,"= square root of ?"]
[null,null,null,null,null,null,"= ?"]

{"sheet":"Z-scores","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,7,22,8],[9,5,9,6],[16,7,16,8],[17,7,17,8],[21,4,21,5],[22,4,22,5],[23,7,23,8],[24,7,24,8],[23,4,23,5],[24,4,24,5],[0,1,0,9],[2,1,2,9],[18,7,18,8],[19,7,19,8],[20,7,20,8],[20,4,20,5],[17,9,17,10],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[21,7,21,8]]}
[null,"PRACTICE CALCULATING Z-SCORES"]
[]
[null,"Calculate the z-score of each case, using the value in the yellow highlighted cell. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value on\nVariable X","Z-score"]
[null,1,6,"hidden",null,"Mean (X-bar):",null,12.63]
[null,2,15,"hidden",null,"Standard Deviation (S):",null,6.38]
[null,3,15,"hidden"]
[null,4,17,"hidden",null,"Need some help?"]
[null,5,19,"hidden"]
[null,6,8,"hidden"]
[null,7,1,"hidden"]
[null,8,20,"hidden"]
[]
[null,"Z-SCORE CALCULATIONS"]
[null,"Case #","Value\n","Mean\n","Std. Deviation\n",null,"Value-Mean\n","(Value-Mean) ÷ Std. Dev.\n"]
[null,1,6,12.63,6.38,null,"6 - 12.63 = ?","-6.63 ÷ 6.38 = ?"]
[null,2,15,12.63,6.38,null,"15 - 12.63 = ?","2.37 ÷ 6.38 = ?"]
[null,3,15,12.63,6.38,null,"15 - 12.63 = ?","2.37 ÷ 6.38 = ?"]
[null,4,17,12.63,6.38,null,"17 - 12.63 = ?","4.37 ÷ 6.38 = ?"]
[null,5,19,12.63,6.38,null,"19 - 12.63 = ?","6.37 ÷ 6.38 = ?"]
[null,6,8,12.63,6.38,null,"8 - 12.63 = ?","-4.63 ÷ 6.38 = ?"]
[null,7,1,12.63,6.38,null,"1 - 12.63 = ?","-11.63 ÷ 6.38 = ?"]
[null,8,20,12.63,6.38,null,"20 - 12.63 = ?","7.37 ÷ 6.38 = ?"]

{"sheet":" Variance & Std Deviation-A","index":4,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":true,"merged":[[52,6,52,7],[53,6,53,7],[54,6,54,7],[39,6,39,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[50,6,50,7],[51,6,51,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[23,3,23,4],[29,3,29,4],[28,6,28,7],[29,6,29,7],[30,3,30,4],[31,3,31,4],[32,3,32,4],[10,4,10,5],[12,4,12,5],[20,3,20,4],[21,3,21,4],[22,3,22,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[0,1,0,12],[2,1,2,12],[6,4,6,5],[7,4,7,5],[9,4,9,5],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[41,6,41,7],[33,6,33,7],[34,6,34,7],[36,6,36,7],[40,6,40,7],[37,6,37,7]]}
[null,"PRACTICE CALCULATING VARIANCE AND STANDARD DEVIATION (POPULATION)"]
[]
[]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,20)","v":16},1,20,null,"Number of Cases:",null,{"$f":"COUNT(C7:C18)","v":12}]
[5,2,20,null,"Mean:",null,{"$f":"ROUND(AVERAGE(C7:C18),2)","v":12.58}]
[4,3,9]
[15,4,8,null,"Variance:",null,{"$f":"J37","v":29.75}]
[12,5,10,null,"Standard Deviation:",null,{"$f":"J41","v":5.45}]
[19,6,7]
[9,7,8,null,"Need some help?"]
[18,8,13]
[11,9,20]
[6,10,7]
[14,11,9]
[8,12,20]
[]
[null,"VARIANCE AND STANDARD DEVIATION CALCULATIONS"]
[null,"Case #","Value","Mean",null,"Value - Mean","(Value-Mean)2"]
[null,1,{"$f":"C7","v":20},{"$f":"$G$8","v":12.58},null,{"$f":"CONCATENATE($C22,\" - \",$G$8,\" = \",$J22)","v":"20 - 12.58 = 7.42"},{"$f":"CONCATENATE($J22,\" x \",$J22,\" = \",$K22)","v":"7.42 x 7.42 = 55.06"},null,null,{"$f":"ROUND(C22-$G$8,2)","v":7.42},{"$f":"ROUND(J22^2,2)","v":55.06}]
[null,2,{"$f":"C8","v":20},{"$f":"$G$8","v":12.58},null,"20 - 12.58 = 7.42",{"$f":"CONCATENATE($J23,\" x \",$J23,\" = \",$K23)","v":"7.42 x 7.42 = 55.06"},null,null,7.42,{"$f":"ROUND(J23^2,2)","v":55.06}]
[null,3,9,12.58,null,"9 - 12.58 = -3.58","-3.58 x -3.58 = 12.82",null,null,-3.58,12.82]
[null,4,8,12.58,null,"8 - 12.58 = -4.58","-4.58 x -4.58 = 20.98",null,null,-4.58,20.98]
[null,5,10,12.58,null,"10 - 12.58 = -2.58","-2.58 x -2.58 = 6.66",null,null,-2.58,6.66]
[null,6,7,12.58,null,"7 - 12.58 = -5.58","-5.58 x -5.58 = 31.14",null,null,-5.58,31.14]
[null,7,8,12.58,null,"8 - 12.58 = -4.58","-4.58 x -4.58 = 20.98",null,null,-4.58,20.98]
[null,8,13,12.58,null,"13 - 12.58 = 0.42","0.42 x 0.42 = 0.18",null,null,0.42,0.18]
[null,9,20,12.58,null,"20 - 12.58 = 7.42","7.42 x 7.42 = 55.06",null,null,7.42,55.06]
[null,10,7,12.58,null,"7 - 12.58 = -5.58","-5.58 x -5.58 = 31.14",null,null,-5.58,31.14]
[null,11,9,12.58,null,"9 - 12.58 = -3.58","-3.58 x -3.58 = 12.82",null,null,-3.58,12.82]
[null,12,20,12.58,null,"20 - 12.58 = 7.42","7.42 x 7.42 = 55.06",null,null,7.42,55.06]
[null,null,null,null,null,"Column Sum",{"$f":"CONCATENATE(\"'= \",J34)","v":"'= 356.96"},null,null,{"$f":"ROUND(SUM(K22:K33),2)","v":356.96}]
[null,null,null,null,null,"n",{"$f":"CONCATENATE(\"'= \",J35)","v":"'= 12"},null,null,{"$f":"G7","v":12}]
[null,null,null,null,null,"Variance"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"'= \",J34,\" ÷ \",J35)","v":"'= 356.96 ÷ 12"},null,null,{"$f":"ROUND(J34/J35,2)","v":29.75}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"'= \",J37)","v":"'= 29.75"}]
[null,null,null,null,null,"Std. Deviation"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"'= square root of (\",J34,\" ÷ \",J35,\")\")","v":"'= square root of (356.96 ÷ 12)"}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"'= square root of \",J37)","v":"'= square root of 29.75"},null,null,{"$f":"ROUND(SQRT(J37),2)","v":5.45}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"'= \",J41)","v":"'= 5.45"}]
[null,null,null,null,null,"Value - Mean","(Value-Mean)2"]
[null,null,null,null,null,{"$f":"CONCATENATE($C22,\" - \",$G$8,\" = ?\")","v":"20 - 12.58 = ?"},{"$f":"CONCATENATE($J22,\" x \",$J22,\" = ?\")","v":"7.42 x 7.42 = ?"}]
[null,null,null,null,null,{"$f":"CONCATENATE($C23,\" - \",$G$8,\" = ?\")","v":"20 - 12.58 = ?"},{"$f":"CONCATENATE($J23,\" x \",$J23,\" = ?\")","v":"7.42 x 7.42 = ?"}]
[null,null,null,null,null,"9 - 12.58 = ?","-3.58 x -3.58 = ?"]
[null,null,null,null,null,"8 - 12.58 = ?","-4.58 x -4.58 = ?"]
[null,null,null,null,null,"10 - 12.58 = ?","-2.58 x -2.58 = ?"]
[null,null,null,null,null,"7 - 12.58 = ?","-5.58 x -5.58 = ?"]
[null,null,null,null,null,"8 - 12.58 = ?","-4.58 x -4.58 = ?"]
[null,null,null,null,null,"13 - 12.58 = ?","0.42 x 0.42 = ?"]
[null,null,null,null,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]
[null,null,null,null,null,"7 - 12.58 = ?","-5.58 x -5.58 = ?"]
[null,null,null,null,null,"9 - 12.58 = ?","-3.58 x -3.58 = ?"]
[null,null,null,null,null,"20 - 12.58 = ?","7.42 x 7.42 = ?"]

{"sheet":"Z-scores-A","index":5,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[0,1,0,8],[2,1,2,8],[9,5,9,6],[16,4,16,5],[17,4,17,5],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[23,4,23,5],[24,4,24,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5]]}
[null,"PRACTICE CALCULATING Z-SCORES"]
[]
[]
[]
[]
[null,"Case #","Value","Z-score"]
[{"$f":"RANDBETWEEN(1,20)","v":4},1,6,{"$f":"K18","v":-1.04},null,"Mean:",null,{"$f":"ROUND(AVERAGE(C7:C14),2)","v":12.63},null,{"$f":"ROUND(C7-$H$7,2)","v":-6.63},{"$f":"ROUND(J7*J7,2)","v":43.96}]
[{"$f":"RANDBETWEEN(1,20)","v":15},2,15,0.37,null,"Standard Deviation:",null,{"$f":"M15","v":6.38},null,2.37,{"$f":"ROUND(J8*J8,2)","v":5.62}]
[15,3,15,0.37,null,null,null,null,null,2.37,5.62]
[20,4,17,0.68,null,"Need some help?",null,null,null,4.37,19.100000000000001]
[8,5,19,1,null,null,null,null,null,6.37,40.58]
[13,6,8,-0.73,null,null,null,null,null,-4.63,21.44]
[16,7,1,-1.82,null,null,null,null,null,-11.63,135.26]
[20,8,20,1.1599999999999999,null,null,null,null,null,7.37,54.32]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K7:K14),2)","v":325.89999999999998},{"$f":"ROUND(K15/8,2)","v":40.74},{"$f":"ROUND(SQRT(L15),2)","v":6.38}]
[]
[null,"Case #","Value","Mean","Std. Dev.",null,"Value-Mean","Z-Score"]
[null,1,{"$f":"C7","v":6},{"$f":"$H$7","v":12.63},{"$f":"$H$8","v":6.38},null,{"$f":"CONCATENATE(C18,\" - \",$H$7,\" = \",J18)","v":"6 - 12.63 = -6.63"},{"$f":"CONCATENATE(J18,\" ÷ \",$H$8,\" = \",K18)","v":"-6.63 ÷ 6.38 = -1.04"},null,{"$f":"ROUND(C18-$H$7,2)","v":-6.63},{"$f":"ROUND(J18/$H$8,2)","v":-1.04}]
[null,2,15,12.63,6.38,null,"15 - 12.63 = 2.37",{"$f":"CONCATENATE(J19,\" ÷ \",$H$8,\" = \",K19)","v":"2.37 ÷ 6.38 = 0.37"},null,2.37,0.37]
[null,3,15,12.63,6.38,null,"15 - 12.63 = 2.37","2.37 ÷ 6.38 = 0.37",null,2.37,0.37]
[null,4,17,12.63,6.38,null,"17 - 12.63 = 4.37","4.37 ÷ 6.38 = 0.68",null,4.37,0.68]
[null,5,19,12.63,6.38,null,"19 - 12.63 = 6.37","6.37 ÷ 6.38 = 1",null,6.37,1]
[null,6,8,12.63,6.38,null,"8 - 12.63 = -4.63","-4.63 ÷ 6.38 = -0.73",null,-4.63,-0.73]
[null,7,1,12.63,6.38,null,"1 - 12.63 = -11.63","-11.63 ÷ 6.38 = -1.82",null,-11.63,-1.82]
[null,8,20,12.63,6.38,null,"20 - 12.63 = 7.37","7.37 ÷ 6.38 = 1.16",null,7.37,1.1599999999999999]
[]
[]
[null,null,null,null,null,null,"Value-Mean","Z-Score"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(C18,\" - \",$H$7,\" = ?\")","v":"6 - 12.63 = ?"},{"$f":"CONCATENATE(J18,\" ÷ \",$H$8,\" = ?\")","v":"-6.63 ÷ 6.38 = ?"}]
[null,null,null,null,null,null,"15 - 12.63 = ?","2.37 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"15 - 12.63 = ?","2.37 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"17 - 12.63 = ?","4.37 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"19 - 12.63 = ?","6.37 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"8 - 12.63 = ?","-4.63 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"1 - 12.63 = ?","-11.63 ÷ 6.38 = ?"]
[null,null,null,null,null,null,"20 - 12.63 = ?","7.37 ÷ 6.38 = ?"]

{"sheet":"Mean-A","index":6,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,1,0,9],[2,1,2,9],[9,4,9,5]]}
[null,"PRACTICE CALCULATING MEANS"]
[]
[]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,20)","v":20},1,14,null,"Number of Cases:",{"$f":"COUNT(C7:C18)","v":12}]
[{"$f":"RANDBETWEEN(1,20)","v":18},2,15,null,"Mean:",{"$f":"ROUND(AVERAGE(C7:C18),2)","v":10.17}]
[19,3,3]
[1,4,12,null,"Need some help?"]
[1,5,11]
[15,6,16]
[5,7,6]
[9,8,20]
[1,9,4]
[16,10,9]
[19,11,5]
[17,12,7]
[]
[null,"MEAN CALCULATION"]
[null,"Numerator:"]
[null,null,{"$f":"CONCATENATE(\"'= \",C7,\" + \",C8,\" + \",C9,\" + \",C10,\" + \",C11,\" + \",C12,\" + \",C13,\" + \",C14,\" + \",C15,\" + \",C16,\" + \",C17,\" + \",C18)","v":"'= 14 + 15 + 3 + 12 + 11 + 16 + 6 + 20 + 4 + 9 + 5 + 7"},null,null,null,null,{"$f":"SUM(C7:C18)","v":122}]
[null,null,{"$f":"CONCATENATE(\"'= \",H22)","v":"'= 122"}]
[null,"Denominator:"]
[null,null,{"$f":"CONCATENATE(\"'= \",F7)","v":"'= 12"},null,null,null,null,{"$f":"ROUND(H22/F7,2)","v":10.17}]
[null,"Mean:"]
[null,null,{"$f":"CONCATENATE(\"'= \",H22,\" ÷ \",F7)","v":"'= 122 ÷ 12"}]
[null,null,{"$f":"CONCATENATE(\"'= \",H25)","v":"'= 10.17"}]