{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Title","Frequency Table","Ratio","Rate","Crosstabulation (2x2)","Crosstabulation (3x3)","Frequency Table-A","Ratio-A","Rate-A","Crosstabulation (2x2)-A","Crosstabulation (3x3)-A"],"not_rendered":{"charts":0,"images":7,"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 2"]
[]
[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":"Frequency Table","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[19,5,20,5],[12,7,12,8],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[2,1,2,7],[0,1,0,7],[4,5,5,5],[4,4,5,4],[4,3,5,3],[4,2,5,2],[4,1,5,1]]}
[null,"PRACTICE COMPLETING FREQUENCY TABLES"]
[]
[null,"Calculate the numbers in the percentage, valid percentage, and cumulative percentage columns \nusing the frequencies (counts) in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[null,"Category","Frequency \n(F)","Percent","Valid \nPercent","Cumulative Percent"]
[]
[null,"Attribute 1",2,"hidden","hidden","hidden"]
[null,"Attribute 2",4,"hidden","hidden","hidden"]
[null,"Attribute 3",15,"hidden","hidden","hidden"]
[null,"Attribute 4",15,"hidden","hidden","hidden"]
[null,"Attribute 5",1,"hidden","hidden","hidden"]
[null,"Attribute 6",13,"hidden","hidden","hidden"]
[null,"Attribute 7",14,"hidden","hidden","hidden",null,"Need some help?"]
[null,"Attribute 8",1,"hidden","hidden","hidden"]
[null,"Valid Total",65,"hidden","hidden","hidden"]
[null,"Missing attributes",9,"hidden","hidden","hidden"]
[null,"Total",74,"hidden","hidden","hidden"]
[]
[null,"FREQUENCY TABLE CALCULATIONS"]
[null,"Category","Frequency \n(F)","\nPercent","Valid \nPercent","Cumulative Percent"]
[]
[null,"Attribute 1",2,"(2 ÷ 74) x 100 = ?","(2 ÷ 65) x 100 = ?","(2 ÷ 65) x 100 = ?"]
[null,"Attribute 2",4,"(4 ÷ 74) x 100 = ?","(4 ÷ 65) x 100 = ?","(6 ÷ 65) x 100 = ?"]
[null,"Attribute 3",15,"(15 ÷ 74) x 100 = ?","(15 ÷ 65) x 100 = ?","(21 ÷ 65) x 100 = ?"]
[null,"Attribute 4",15,"(15 ÷ 74) x 100 = ?","(15 ÷ 65) x 100 = ?","(36 ÷ 65) x 100 = ?"]
[null,"Attribute 5",1,"(1 ÷ 74) x 100 = ?","(1 ÷ 65) x 100 = ?","(37 ÷ 65) x 100 = ?"]
[null,"Attribute 6",13,"(13 ÷ 74) x 100 = ?","(13 ÷ 65) x 100 = ?","(50 ÷ 65) x 100 = ?"]
[null,"Attribute 7",14,"(14 ÷ 74) x 100 = ?","(14 ÷ 65) x 100 = ?","(64 ÷ 65) x 100 = ?"]
[null,"Attribute 8",1,"(1 ÷ 74) x 100 = ?","(1 ÷ 65) x 100 = ?","(65 ÷ 65) x 100 = ?"]
[null,"Valid Total",65,"(65 ÷ 74) x 100 = ?","(65 ÷ 65) x 100 = ?"]
[null,"Missing attributes",9,"(9 ÷ 74) x 100 = ?"]
[null,"Total",74,"(74 ÷ 74) x 100 = ?"]

{"sheet":"Ratio","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[0,1,0,7],[2,1,2,7],[5,4,7,4],[5,5,6,5]]}
[null,"PRACTICE CALCULATING RATIOS"]
[]
[null,"Calculate the ratio of people with attribute 1 to people with attribute 2, using the frequencies (counts) in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answer, click on the 'Show Answer' button."]
[]
[null,"Category","Frequency \n(F)"]
[null,null,null,null,"Ratio of people with Attribute 1 to people with Attribute 2:","hidden"]
[null,"Attribute 1",11]
[null,"Attribute 2",9]
[null,"Total",20]
[]
[null,null,null,"Need some help?"]
[]
[]
[null,"RATIO CALCULATION"]
[null,"Ratio"]
[null,null,"= 11 ÷ 9"]
[null,null,"= ? or ?:1"]

{"sheet":"Rate","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,4,7,5],[0,1,0,8],[2,1,2,8],[4,3,5,3],[5,4,5,5]]}
[null,"PRACTICE CALCULATING RATES"]
[]
[null,"Calculate two rates using the frequency (count) and total number of cases in the yellow highlighted cells. \nFirst, calculate the rate out of 1,000 people (standardized denominator). Then, calculate the rate \"1 out of every _____ cases\" have the attribute (standardized numerator).\nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Frequency of Attribute (F)",122,null,"Rate: ____ out of 1,000 cases  ",null,"hidden"]
[]
[null,"Total Number of Cases (N)",374,null,"Rate: 1 out of every ____ cases",null,"hidden"]
[]
[null,null,null,"Need some help?"]
[]
[]
[null,"RATE CALCULATION: STANDARDIZED DENOMINATOR"]
[null,"Rate out of 1,000"]
[null,null,"(N)(x) = (F)(1000)"]
[null,null,"(374)(x) = (122)(1000)"]
[null,null,"374x = 122000"]
[null,null,"x = ? ÷ ?"]
[null,null,"x = ?"]
[]
[null,"RATE CALCULATION: STANDARDIZED NUMERATOR"]
[null,"1 out of every _____"]
[null,null,"(F)(x) = (N)(1)"]
[null,null,"(122)(x) = (374)(1)"]
[null,null,"122x = 374"]
[null,null,"x = ? ÷ ?"]
[null,null,"x = ?"]

{"sheet":"Crosstabulation (2x2)","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,7,13,8],[20,3,20,5],[22,1,24,1],[2,1,2,7],[0,1,0,7],[15,1,17,1],[5,1,5,5],[6,3,6,5],[8,1,10,1],[12,1,12,5],[13,3,13,5]]}
[null,"PRACTICE CALCULATING COLUMN PERCENTAGES: 2x2 CROSSTABULATION"]
[]
[null,"Calculate the column percentages for each cell using the frequencies (counts) in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"FREQUENCIES"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1",5,11,16]
[null,null,"Attribute 2",6,9,15]
[null,null,"Total",11,20,31]
[]
[null,"COLUMN PERCENTAGES"]
[null,null,null,"Independent Variable",null,null,null,"Need some help?"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1","hidden","hidden","hidden"]
[null,null,"Attribute 2","hidden","hidden","hidden"]
[null,null,"Total","hidden","hidden","hidden"]
[]
[null,"COLUMN PERCENTAGE CALCULATIONS"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1","(5 ÷ 11) x 100 = ?","(11 ÷ 20) x 100 = ?","(16 ÷ 31) x 100 = ?"]
[null,null,"Attribute 2","(6 ÷ 11) x 100 = ?","(9 ÷ 20) x 100 = ?","(15 ÷ 31) x 100 = ?"]
[null,null,"Total","(11 ÷ 11) x 100 = ?","(20 ÷ 20) x 100 = ?","(31 ÷ 31) x 100 = ?"]

{"sheet":"Crosstabulation (3x3)","index":5,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,3,22,6],[24,1,27,1],[14,8,14,9],[2,1,2,8],[0,1,0,8],[16,1,19,1],[5,1,5,6],[6,3,6,6],[8,1,11,1],[13,1,13,6],[14,3,14,6]]}
[null,"PRACTICE CALCULATING COLUMN PERCENTAGES: 3x3 CROSSTABULATION"]
[]
[null,"Calculate the column percentages for each cell using the frequencies (counts) in the yellow highlighted cells. \nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"FREQUENCIES"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1",1,5,18,24]
[null,null,"Attribute 2",8,17,1,26]
[null,null,"Attribute 3",14,9,5,28]
[null,null,"Total",23,31,24,78]
[]
[null,"COLUMN PERCENTAGES"]
[null,null,null,"Independent Variable",null,null,null,null,"Need some help?"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1","hidden","hidden","hidden","hidden"]
[null,null,"Attribute 2","hidden","hidden","hidden","hidden"]
[null,null,"Attribute 3","hidden","hidden","hidden","hidden"]
[null,null,"Total","hidden","hidden","hidden","hidden"]
[]
[null,"COLUMN PERCENTAGE CALCULATIONS"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1","(1 ÷ 23) x 100 = ?","(5 ÷ 31) x 100 = ?","(18 ÷ 24) x 100 = ?","(24 ÷ 78) x 100 = ?"]
[null,null,"Attribute 2","(8 ÷ 23) x 100 = ?","(17 ÷ 31) x 100 = ?","(1 ÷ 24) x 100 = ?","(26 ÷ 78) x 100 = ?"]
[null,null,"Attribute 3","(14 ÷ 23) x 100 = ?","(9 ÷ 31) x 100 = ?","(5 ÷ 24) x 100 = ?","(28 ÷ 78) x 100 = ?"]
[null,null,"Total","(23 ÷ 23) x 100 = ?","(31 ÷ 31) x 100 = ?","(24 ÷ 24) x 100 = ?","(78 ÷ 78) x 100 = ?"]

{"sheet":"Frequency Table-A","index":6,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[0,1,0,7],[2,1,2,7],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
[null,"PRACTICE COMPLETING FREQUENCY TABLES"]
[]
[]
[]
[null,"Category","Frequency (# of cases)","Percent","Valid \nPercent","Cumulative Percent"]
[]
[{"$f":"RANDBETWEEN(1,20)","v":6},"Attribute 1",2,{"$f":"ROUND($C7/$C$17,4)","v":2.7E-2},{"$f":"ROUND($C7/$C$15,4)","v":3.0800000000000001E-2},{"$f":"ROUND(SUM($C$7:$C7)/$C$15,4)","v":3.0800000000000001E-2}]
[{"$f":"RANDBETWEEN(1,20)","v":13},"Attribute 2",4,{"$f":"ROUND($C8/$C$17,4)","v":5.4100000000000002E-2},{"$f":"ROUND($C8/$C$15,4)","v":6.1499999999999999E-2},{"$f":"ROUND(SUM($C$7:$C8)/$C$15,4)","v":9.2299999999999993E-2}]
[9,"Attribute 3",15,0.20269999999999999,0.23080000000000001,{"$f":"ROUND(SUM($C$7:$C9)/$C$15,4)","v":0.3231}]
[5,"Attribute 4",15,0.20269999999999999,0.23080000000000001,{"$f":"ROUND(SUM($C$7:$C10)/$C$15,4)","v":0.55379999999999996}]
[8,"Attribute 5",1,1.35E-2,1.54E-2,{"$f":"ROUND(SUM($C$7:$C11)/$C$15,4)","v":0.56920000000000004}]
[6,"Attribute 6",13,0.1757,0.2,{"$f":"ROUND(SUM($C$7:$C12)/$C$15,4)","v":0.76919999999999999}]
[1,"Attribute 7",14,0.18920000000000001,0.21540000000000001,{"$f":"ROUND(SUM($C$7:$C13)/$C$15,4)","v":0.98460000000000003}]
[17,"Attribute 8",1,1.35E-2,1.54E-2,{"$f":"ROUND(SUM($C$7:$C14)/$C$15,4)","v":1}]
[{"$f":"SUM(A7:A14)","v":65},"Valid Total",65,0.87839999999999996,1]
[{"$f":"RANDBETWEEN(1,20)","v":6},"Missing answers",9,0.1216]
[{"$f":"SUM(A15:A16)","v":71},"Total",74,1]
[]
[]
[null,"Category","Frequency \n(# of cases)","Percent","Valid \nPercent","Cumulative Percent"]
[]
[null,"Attribute 1",{"$f":"C7","v":2},{"$f":"CONCATENATE(\"(\",C22,\" ÷ \",$C$32,\")\",\" x 100 = \",G22)","v":"(2 ÷ 74) x 100 = 2.7"},{"$f":"CONCATENATE(\"(\",C22,\" ÷ \",$C$30,\")\",\" x 100 = \",H22)","v":"(2 ÷ 65) x 100 = 3.08"},{"$f":"CONCATENATE(\"(\",I22,\" ÷ \",$C$30,\")\",\" x 100 = \",J22)","v":"(2 ÷ 65) x 100 = 3.08"},{"$f":"ROUND(((C22/$C$32)*100),2)","v":2.7},{"$f":"ROUND(((C22/$C$30)*100),2)","v":3.08},{"$f":"SUM(C22)","v":2},{"$f":"ROUND(((I22/$C$30)*100),2)","v":3.08}]
[null,"Attribute 2",4,{"$f":"CONCATENATE(\"(\",C23,\" ÷ \",$C$32,\")\",\" x 100 = \",G23)","v":"(4 ÷ 74) x 100 = 5.41"},{"$f":"CONCATENATE(\"(\",C23,\" ÷ \",$C$30,\")\",\" x 100 = \",H23)","v":"(4 ÷ 65) x 100 = 6.15"},{"$f":"CONCATENATE(\"(\",I23,\" ÷ \",$C$30,\")\",\" x 100 = \",J23)","v":"(6 ÷ 65) x 100 = 9.23"},{"$f":"ROUND(((C23/$C$32)*100),2)","v":5.41},{"$f":"ROUND(((C23/$C$30)*100),2)","v":6.15},{"$f":"SUM(C22:C23)","v":6},{"$f":"ROUND(((I23/$C$30)*100),2)","v":9.23}]
[null,"Attribute 3",15,"(15 ÷ 74) x 100 = 20.27","(15 ÷ 65) x 100 = 23.08","(21 ÷ 65) x 100 = 32.31",20.27,23.08,{"$f":"SUM(C22:C24)","v":21},32.31]
[null,"Attribute 4",15,"(15 ÷ 74) x 100 = 20.27","(15 ÷ 65) x 100 = 23.08","(36 ÷ 65) x 100 = 55.38",20.27,23.08,{"$f":"SUM(C22:C25)","v":36},55.38]
[null,"Attribute 5",1,"(1 ÷ 74) x 100 = 1.35","(1 ÷ 65) x 100 = 1.54","(37 ÷ 65) x 100 = 56.92",1.35,1.54,{"$f":"SUM(C22:C26)","v":37},56.92]
[null,"Attribute 6",13,"(13 ÷ 74) x 100 = 17.57","(13 ÷ 65) x 100 = 20","(50 ÷ 65) x 100 = 76.92",17.57,20,{"$f":"SUM(C22:C27)","v":50},76.92]
[null,"Attribute 7",14,"(14 ÷ 74) x 100 = 18.92","(14 ÷ 65) x 100 = 21.54","(64 ÷ 65) x 100 = 98.46",18.920000000000002,21.54,{"$f":"SUM(C22:C28)","v":64},98.46]
[null,"Attribute 8",1,"(1 ÷ 74) x 100 = 1.35","(1 ÷ 65) x 100 = 1.54","(65 ÷ 65) x 100 = 100",1.35,1.54,{"$f":"SUM(C22:C29)","v":65},100]
[null,"Valid Total",65,"(65 ÷ 74) x 100 = 87.84","(65 ÷ 65) x 100 = 100",null,87.84,100]
[null,"Missing attributes",9,"(9 ÷ 74) x 100 = 12.16",null,null,12.16]
[null,"Total",74,"(74 ÷ 74) x 100 = 100",null,null,100]
[]
[null,null,null,{"$f":"CONCATENATE(\"(\",C22,\" ÷ \",$C$32,\")\",\" x 100 = ?\")","v":"(2 ÷ 74) x 100 = ?"},{"$f":"CONCATENATE(\"(\",C22,\" ÷ \",$C$30,\")\",\" x 100 = ?\")","v":"(2 ÷ 65) x 100 = ?"},{"$f":"CONCATENATE(\"(\",I22,\" ÷ \",$C$30,\")\",\" x 100 = ?\")","v":"(2 ÷ 65) x 100 = ?"}]
[null,null,null,{"$f":"CONCATENATE(\"(\",C23,\" ÷ \",$C$32,\")\",\" x 100 = ?\")","v":"(4 ÷ 74) x 100 = ?"},{"$f":"CONCATENATE(\"(\",C23,\" ÷ \",$C$30,\")\",\" x 100 = ?\")","v":"(4 ÷ 65) x 100 = ?"},{"$f":"CONCATENATE(\"(\",I23,\" ÷ \",$C$30,\")\",\" x 100 = ?\")","v":"(6 ÷ 65) x 100 = ?"}]
[null,null,null,"(15 ÷ 74) x 100 = ?","(15 ÷ 65) x 100 = ?","(21 ÷ 65) x 100 = ?"]
[null,null,null,"(15 ÷ 74) x 100 = ?","(15 ÷ 65) x 100 = ?","(36 ÷ 65) x 100 = ?"]
[null,null,null,"(1 ÷ 74) x 100 = ?","(1 ÷ 65) x 100 = ?","(37 ÷ 65) x 100 = ?"]
[null,null,null,"(13 ÷ 74) x 100 = ?","(13 ÷ 65) x 100 = ?","(50 ÷ 65) x 100 = ?"]
[null,null,null,"(14 ÷ 74) x 100 = ?","(14 ÷ 65) x 100 = ?","(64 ÷ 65) x 100 = ?"]
[null,null,null,"(1 ÷ 74) x 100 = ?","(1 ÷ 65) x 100 = ?","(65 ÷ 65) x 100 = ?"]
[null,null,null,"(65 ÷ 74) x 100 = ?","(65 ÷ 65) x 100 = ?"]
[null,null,null,"(9 ÷ 74) x 100 = ?"]
[null,null,null,"(74 ÷ 74) x 100 = ?"]

{"sheet":"Ratio-A","index":7,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,1,0,7],[2,1,2,7],[4,1,5,1],[4,2,5,2],[4,3,5,3],[5,4,6,4]]}
[null,"PRACTICE CALCULATING RATIOS"]
[]
[]
[]
[null,"Category","Frequency \n(# of cases)"]
[null,null,null,null,"Ratio of people with Attribute 1 \nto people with Attribute 2 ",{"$f":"CONCATENATE($D$17,\"   or   \",$D$17,\":1\")","v":"1.22   or   1.22:1"}]
[{"$f":"RANDBETWEEN(1,20)","v":9},"Attribute 1",11]
[{"$f":"RANDBETWEEN(1,20)","v":13},"Attribute 2",9]
[{"$f":"SUM(A7:A8)","v":22},null,20]
[]
[null,"Need some help?"]
[]
[]
[null,"RATIO CALCULATION"]
[null,"Ratio","'= F1 ÷ F2"]
[null,null,{"$f":"CONCATENATE(\"'= \",C7,\" ÷ \",C8)","v":"'= 11 ÷ 9"}]
[null,null,{"$f":"CONCATENATE(\"'= \",D17,\"  or  \",D17,\":1\")","v":"'= 1.22  or  1.22:1"},{"$f":"ROUND(C7/C8,2)","v":1.22}]

{"sheet":"Rate-A","index":8,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,1,0,8],[2,1,2,8],[4,3,5,3],[7,3,8,3],[5,4,5,5],[7,4,7,5]]}
[null,"PRACTICE CALCULATING RATES"]
[]
[]
[{"$f":"RANDBETWEEN(1,500)","v":97}]
[{"$f":"RANDBETWEEN(1,500)","v":204}]
[{"$f":"MIN($A$4,$A$5)","v":97},"Frequency of Attribute (F)",122,null,"Rate: ____ out of 1,000 cases  ",null,{"$f":"CONCATENATE(\"'\",$E$19,\" out of 1,000 cases\")","v":"'326.2 out of 1,000 cases"}]
[]
[{"$f":"MAX($A$4,$A$5)","v":204},"Total Number of Cases (N)",374,null,"Rate: 1 out of every ____ cases",null,{"$f":"CONCATENATE(\"'1 out of every \",$E$27,\" cases\")","v":"'1 out of every 3.07 cases"}]
[]
[null,"Need some help?"]
[]
[]
[null,"RATE CALCULATION: STANDARDIZED DENOMINATOR"]
[null,"Rate out of 1,000"]
[null,null,"(N)(x)=(F)(1000)"]
[null,null,{"$f":"CONCATENATE(\"'(\",$C$8,\")(x) = (\",$C$6,\")(1000)\")","v":"'(374)(x) = (122)(1000)"}]
[null,null,{"$f":"CONCATENATE(\"'\",$C$8,\"x = \",$E$17)","v":"'374x = 122000"},null,{"$f":"C6*1000","v":122000}]
[null,null,{"$f":"CONCATENATE(\"'x = \",$E$17,\" ÷ \",$C$8)","v":"'x = 122000 ÷ 374"}]
[null,null,{"$f":"CONCATENATE(\"'x = \",$E$19)","v":"'x = 326.2"},null,{"$f":"ROUND(E17/C8,2)","v":326.2}]
[]
[null,"RATE CALCULATION: STANDARDIZED NUMERATOR"]
[null,"1 out of 1,000"]
[null,null,"(F)(x)=(N)(1)"]
[null,null,{"$f":"CONCATENATE(\"'(\",$C$6,\")(x) = (\",$C$8,\")(1)\")","v":"'(122)(x) = (374)(1)"}]
[null,null,{"$f":"CONCATENATE(\"'\",$C$6,\"x = \",$C$8)","v":"'122x = 374"}]
[null,null,{"$f":"CONCATENATE(\"'x = \",$C$8,\" ÷ \",$C$6)","v":"'x = 374 ÷ 122"}]
[null,null,{"$f":"CONCATENATE(\"'x = \",$E$27)","v":"'x = 3.07"},null,{"$f":"ROUND(C8/C6,2)","v":3.07}]

{"sheet":"Crosstabulation (2x2)-A","index":9,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[[20,3,20,5],[22,1,24,1],[13,3,13,5],[15,1,17,1],[0,1,0,6],[2,1,2,6],[5,1,5,5],[6,3,6,5],[8,1,10,1],[12,1,12,5]]}
[null,"PRACTICE CALCULATING COLUMN PERCENTAGES"]
[]
[]
[]
[]
[null,"OBSERVED COUNTS"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1",5,11,16,{"$f":"RANDBETWEEN(1,20)","v":11},{"$f":"RANDBETWEEN(1,20)","v":5},{"$f":"SUM(G9:H9)","v":16}]
[null,null,"Attribute 2",6,9,15,{"$f":"RANDBETWEEN(1,20)","v":10},{"$f":"RANDBETWEEN(1,20)","v":2},{"$f":"SUM(G10:H10)","v":12}]
[null,null,"Total",11,20,31,{"$f":"SUM(G9:G10)","v":21},{"$f":"SUM(H9:H10)","v":7},{"$f":"SUM(G9:H10)","v":28}]
[]
[null,"COLUMN PERCENTAGES"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1",{"$f":"ROUND($D9/$D$11,4)","v":0.45450000000000002},{"$f":"ROUND($E9/$E$11,4)","v":0.55000000000000004},{"$f":"ROUND($F9/$F$11,4)","v":0.5161}]
[null,null,"Attribute 2",{"$f":"ROUND($D10/$D$11,4)","v":0.54549999999999998},{"$f":"ROUND($E10/$E$11,4)","v":0.45},{"$f":"ROUND($F10/$F$11,4)","v":0.4839}]
[null,null,"Total",1,1,1]
[]
[]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Total"]
[null,"Dependent\n Variable","Attribute 1",{"$f":"CONCATENATE(\"(\",D9,\" ÷ \",$D$11,\") x 100 = \",G23)","v":"(5 ÷ 11) x 100 = 45.45"},{"$f":"CONCATENATE(\"(\",E9,\" ÷ \",$E$11,\") x 100 = \",H23)","v":"(11 ÷ 20) x 100 = 55"},{"$f":"CONCATENATE(\"(\",F9,\" ÷ \",$F$11,\") x 100 = \",I23)","v":"(16 ÷ 31) x 100 = 51.61"},{"$f":"ROUND((D9/$D$11)*100,2)","v":45.45},{"$f":"ROUND((E9/$E$11)*100,2)","v":55},{"$f":"ROUND((F9/$F$11)*100,2)","v":51.61}]
[null,null,"Attribute 2",{"$f":"CONCATENATE(\"(\",D10,\" ÷ \",$D$11,\") x 100 = \",G24)","v":"(6 ÷ 11) x 100 = 54.55"},{"$f":"CONCATENATE(\"(\",E10,\" ÷ \",$E$11,\") x 100 = \",H24)","v":"(9 ÷ 20) x 100 = 45"},{"$f":"CONCATENATE(\"(\",F10,\" ÷ \",$F$11,\") x 100 = \",I24)","v":"(15 ÷ 31) x 100 = 48.39"},{"$f":"ROUND((D10/$D$11)*100,2)","v":54.55},{"$f":"ROUND((E10/$E$11)*100,2)","v":45},{"$f":"ROUND((F10/$F$11)*100,2)","v":48.39}]
[null,null,"Total",{"$f":"CONCATENATE(\"(\",D11,\" ÷ \",$D$11,\") x 100 = \",G25)","v":"(11 ÷ 11) x 100 = 100"},{"$f":"CONCATENATE(\"(\",E11,\" ÷ \",$E$11,\") x 100 = \",H25)","v":"(20 ÷ 20) x 100 = 100"},{"$f":"CONCATENATE(\"(\",F11,\" ÷ \",$F$11,\") x 100 = \",I25)","v":"(31 ÷ 31) x 100 = 100"},100,100,100]
[]
[null,null,null,{"$f":"CONCATENATE(\"(\",D9,\" ÷ \",$D$11,\") x 100 = ?\")","v":"(5 ÷ 11) x 100 = ?"},{"$f":"CONCATENATE(\"(\",E9,\" ÷ \",$E$11,\") x 100 = ?\")","v":"(11 ÷ 20) x 100 = ?"},{"$f":"CONCATENATE(\"(\",F9,\" ÷ \",$F$11,\") x 100 = ?\")","v":"(16 ÷ 31) x 100 = ?"}]
[null,null,null,{"$f":"CONCATENATE(\"(\",D10,\" ÷ \",$D$11,\") x 100 = ?\")","v":"(6 ÷ 11) x 100 = ?"},{"$f":"CONCATENATE(\"(\",E10,\" ÷ \",$E$11,\") x 100 = ?\")","v":"(9 ÷ 20) x 100 = ?"},{"$f":"CONCATENATE(\"(\",F10,\" ÷ \",$F$11,\") x 100 = ?\")","v":"(15 ÷ 31) x 100 = ?"}]
[null,null,null,"(11 ÷ 11) x 100 = ?","(20 ÷ 20) x 100 = ?","(31 ÷ 31) x 100 = ?"]

{"sheet":"Crosstabulation (3x3)-A","index":10,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":true,"merged":[[22,3,22,6],[24,1,27,1],[14,3,14,6],[16,1,19,1],[0,1,0,8],[2,1,2,8],[5,1,5,6],[6,3,6,6],[8,1,11,1],[13,1,13,6]]}
[null,"PRACTICE CALCULATING COLUMN PERCENTAGES"]
[]
[]
[]
[]
[null,"OBSERVED COUNTS"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1",1,5,18,24,{"$f":"RANDBETWEEN(1,20)","v":20},{"$f":"RANDBETWEEN(1,20)","v":18},9,{"$f":"SUM(H9:J9)","v":47}]
[null,null,"Attribute 2",8,17,1,26,{"$f":"RANDBETWEEN(1,20)","v":6},5,13,{"$f":"SUM(H10:J10)","v":24}]
[null,null,"Attribute 3",14,9,5,28,17,5,8,{"$f":"SUM(H11:J11)","v":30}]
[null,null,"Total",23,31,24,78,{"$f":"SUM(H9:H11)","v":43},{"$f":"SUM(I9:I11)","v":28},{"$f":"SUM(J9:J11)","v":30},{"$f":"SUM(H9:J11)","v":101}]
[]
[null,"COLUMN PERCENTAGES"]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1",{"$f":"ROUND(D9/D$12,4)","v":4.3499999999999997E-2},{"$f":"ROUND(E9/E$12,4)","v":0.1613},0.75,0.30769999999999997]
[null,null,"Attribute 2",{"$f":"ROUND(D10/D$12,4)","v":0.3478},0.5484,4.1700000000000001E-2,0.33329999999999999]
[null,null,"Attribute 3",{"$f":"ROUND(D11/D$12,4)","v":0.60870000000000002},0.2903,0.20830000000000001,0.35899999999999999]
[null,null,"Total",{"$f":"ROUND(D12/D$12,4)","v":1},1,1,1]
[]
[]
[null,null,null,"Independent Variable"]
[null,null,null,"Group 1","Group 2","Group 3","Total"]
[null,"Dependent\n Variable","Attribute 1",{"$f":"CONCATENATE(\"(\",D9,\" ÷ \",$D$12,\") x 100 = \",H25)","v":"(1 ÷ 23) x 100 = 4.35"},{"$f":"CONCATENATE(\"(\",E9,\" ÷ \",$E$12,\") x 100 = \",I25)","v":"(5 ÷ 31) x 100 = 16.13"},{"$f":"CONCATENATE(\"(\",F9,\" ÷ \",$F$12,\") x 100 = \",J25)","v":"(18 ÷ 24) x 100 = 75"},{"$f":"CONCATENATE(\"(\",G9,\" ÷ \",$G$12,\") x 100 = \",K25)","v":"(24 ÷ 78) x 100 = 30.77"},{"$f":"ROUND((D9/$D$12)*100,2)","v":4.3499999999999996},{"$f":"ROUND((E9/$E$12)*100,2)","v":16.13},{"$f":"ROUND((F9/$F$12)*100,2)","v":75},{"$f":"ROUND((G9/$G$12)*100,2)","v":30.77}]
[null,null,"Attribute 2",{"$f":"CONCATENATE(\"(\",D10,\" ÷ \",$D$12,\") x 100 = \",H26)","v":"(8 ÷ 23) x 100 = 34.78"},{"$f":"CONCATENATE(\"(\",E10,\" ÷ \",$E$12,\") x 100 = \",I26)","v":"(17 ÷ 31) x 100 = 54.84"},{"$f":"CONCATENATE(\"(\",F10,\" ÷ \",$F$12,\") x 100 = \",J26)","v":"(1 ÷ 24) x 100 = 4.17"},{"$f":"CONCATENATE(\"(\",G10,\" ÷ \",$G$12,\") x 100 = \",K26)","v":"(26 ÷ 78) x 100 = 33.33"},{"$f":"ROUND((D10/$D$12)*100,2)","v":34.78},{"$f":"ROUND((E10/$E$12)*100,2)","v":54.84},{"$f":"ROUND((F10/$F$12)*100,2)","v":4.17},{"$f":"ROUND((G10/$G$12)*100,2)","v":33.33}]
[null,null,"Attribute 3",{"$f":"CONCATENATE(\"(\",D11,\" ÷ \",$D$12,\") x 100 = \",H27)","v":"(14 ÷ 23) x 100 = 60.87"},{"$f":"CONCATENATE(\"(\",E11,\" ÷ \",$E$12,\") x 100 = \",I27)","v":"(9 ÷ 31) x 100 = 29.03"},{"$f":"CONCATENATE(\"(\",F11,\" ÷ \",$F$12,\") x 100 = \",J27)","v":"(5 ÷ 24) x 100 = 20.83"},{"$f":"CONCATENATE(\"(\",G11,\" ÷ \",$G$12,\") x 100 = \",K27)","v":"(28 ÷ 78) x 100 = 35.9"},60.87,29.03,20.83,35.9]
[null,null,"Total",{"$f":"CONCATENATE(\"(\",D12,\" ÷ \",$D$12,\") x 100 = \",H28)","v":"(23 ÷ 23) x 100 = 100"},{"$f":"CONCATENATE(\"(\",E12,\" ÷ \",$E$12,\") x 100 = \",I28)","v":"(31 ÷ 31) x 100 = 100"},{"$f":"CONCATENATE(\"(\",F12,\" ÷ \",$F$12,\") x 100 = \",J28)","v":"(24 ÷ 24) x 100 = 100"},{"$f":"CONCATENATE(\"(\",G12,\" ÷ \",$G$12,\") x 100 = \",K28)","v":"(78 ÷ 78) x 100 = 100"},100,100,100,100]
[]
[null,null,null,{"$f":"CONCATENATE(\"(\",D9,\" ÷ \",$D$12,\") x 100 = ?\")","v":"(1 ÷ 23) x 100 = ?"},{"$f":"CONCATENATE(\"(\",E9,\" ÷ \",$E$12,\") x 100 = ?\")","v":"(5 ÷ 31) x 100 = ?"},{"$f":"CONCATENATE(\"(\",F9,\" ÷ \",$F$12,\") x 100 = ?\")","v":"(18 ÷ 24) x 100 = ?"},{"$f":"CONCATENATE(\"(\",G9,\" ÷ \",$G$12,\") x 100 = ?\")","v":"(24 ÷ 78) x 100 = ?"}]
[null,null,null,{"$f":"CONCATENATE(\"(\",D10,\" ÷ \",$D$12,\") x 100 = ?\")","v":"(8 ÷ 23) x 100 = ?"},{"$f":"CONCATENATE(\"(\",E10,\" ÷ \",$E$12,\") x 100 = ?\")","v":"(17 ÷ 31) x 100 = ?"},{"$f":"CONCATENATE(\"(\",F10,\" ÷ \",$F$12,\") x 100 = ?\")","v":"(1 ÷ 24) x 100 = ?"},{"$f":"CONCATENATE(\"(\",G10,\" ÷ \",$G$12,\") x 100 = ?\")","v":"(26 ÷ 78) x 100 = ?"}]
[null,null,null,"(14 ÷ 23) x 100 = ?","(9 ÷ 31) x 100 = ?","(5 ÷ 24) x 100 = ?","(28 ÷ 78) x 100 = ?"]
[null,null,null,"(23 ÷ 23) x 100 = ?","(31 ÷ 31) x 100 = ?","(24 ÷ 24) x 100 = ?","(78 ÷ 78) x 100 = ?"]