{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Chi-sq","Cramer's V","Bonniferoni'sTest"],"not_rendered":{"charts":0,"images":0,"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":"Chi-sq","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Source: ","https://www.youtube.com/watch?v=dgjHsv8FBYU"]
[null,null,null,"Pearson chi-square test of independence"]
[null,null,null,"example"]
[]
[null,null,null,"Observed","Male","Female","Total"]
[null,null,null,"Married",456,516,{"$f":"SUM(E6:F6)","v":972}]
[null,null,null,"Widowed",58,123,{"$f":"SUM(E7:F7)","v":181}]
[null,null,null,"Divorced",142,172,314]
[null,null,null,"Separated",29,50,79]
[null,null,null,"Never married",188,207,395]
[null,null,null,"Total",{"$f":"SUM(E6:E10)","v":873},{"$f":"SUM(F6:F10)","v":1068},1941]
[]
[null,null,null,"Expected",{"$f":"E5","v":"Male"},{"$f":"F5","v":"Female"}]
[null,null,null,{"$f":"D6","v":"Married"},{"$f":"$G6*E$11/$G$11","v":437.17465224111282},{"$f":"$G6*F$11/$G$11","v":534.82534775888712}]
[null,null,null,"Widowed",{"$f":"$G7*E$11/$G$11","v":81.408037094281298},99.591962905718702]
[null,null,null,"Divorced",{"$f":"$G8*E$11/$G$11","v":141.22720247295209},{"$f":"$G8*F$11/$G$11","v":172.77279752704791}]
[null,null,null,"Separated",{"$f":"$G9*E$11/$G$11","v":35.531684698608963},43.468315301391037]
[null,null,null,"Never married",{"$f":"$G10*E$11/$G$11","v":177.65842349304484},217.34157650695516]
[]
[]
["UDF",{"$f":"PearsonInd($E$6:$F$10,3)","v":0},null,"Percentage of cells with expected count less than 5:",null,null,null,null,{"$f":"COUNTIF(E14:F18,\"<5\")/COUNT(E14:F18)","v":0}]
["UDF",{"$f":"PearsonInd($E$6:$F$10,4)","v":35.531684698608963},null,"Minimum expected count:",null,null,null,null,{"$f":"MIN(E14:F18)","v":35.531684698608963}]
[]
[null,null,null,"Significance",{"$f":"_xlfn.CHISQ.TEST(E6:F10,E14:F18)","v":1.9418339492422952E-3}]
[]
[null,null,null,"(O-E)2/E",{"$f":"E5","v":"Male"},{"$f":"F5","v":"Female"}]
[null,null,null,{"$f":"D6","v":"Married"},{"$f":"(E6-E14)^2/E14","v":0.81064562281067798},{"$f":"(F6-F14)^2/F14","v":0.66263448381434231}]
[null,null,null,"Widowed",{"$f":"(E7-E15)^2/E15","v":6.7307383910100489},5.5018114375952925]
[null,null,null,"Divorced",{"$f":"(E8-E16)^2/E16","v":4.228760517477146E-3},3.4566553668141839E-3]
[null,null,null,"Separated",{"$f":"(E9-E17)^2/E17","v":1.2007003147732163},0.98147132471630882]
[null,null,null,"Never married",{"$f":"(E10-E18)^2/E18","v":0.60198780641208316},0.49207430243234901]
[]
["UDF",{"$f":"PearsonInd($E$6:$F$10,1)","v":16.989749099448613},null,"Pearson Chi-square value:",null,null,{"$f":"SUM(E27:F31)","v":16.989749099448613}]
[]
["UDF",{"$f":"PearsonInd($E$6:$F$10,2)","v":4},null,"Degrees of freedom:",null,null,{"$f":"(COUNT(E27:E31)-1)*(COUNT(E27:F27)-1)","v":4}]
[]
["UDF",{"$f":"PearsonInd($E$6:$F$10,0)","v":1.9418339492422952E-3},null,"significance:",null,null,{"$f":"CHIDIST(G33,G35)","v":1.9418339492422952E-3},{"$f":"_xlfn.CHISQ.DIST.RT(G33,G35)","v":1.9418339492422952E-3}]

{"sheet":"Cramer's V","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"Source: ","https://www.youtube.com/watch?v=dgjHsv8FBYU"]
[null,null,null,"Pearson chi-square test of independence"]
[null,null,null,"example"]
[null,null,null,"https://www.youtube.com/watch?v=YXe51-N9xjM"]
[null,null,null,"Observed","Male","Female","Total"]
[null,null,null,"Married",456,516,{"$f":"SUM(E6:F6)","v":972}]
[null,null,null,"Widowed",58,123,{"$f":"SUM(E7:F7)","v":181}]
[null,null,null,"Divorced",142,172,314]
[null,null,null,"Separated",29,50,79]
[null,null,null,"Never married",188,207,395]
[null,null,null,"Total",{"$f":"SUM(E6:E10)","v":873},{"$f":"SUM(F6:F10)","v":1068},1941]
[]
[null,null,null,"Pearson Chi-square value:",null,null,{"$f":"'Chi-sq'!G33","v":16.989749099448613}]
[null,null,null,null,"# of rows (r) ",null,{"$f":"COUNT(E6:E10)","v":5}]
[null,null,null,null,"# of cols (c) ",null,{"$f":"COUNT(E6:F6)","v":2}]
[null,null,null,null,"q",null,{"$f":"MIN(G14,G15)","v":2}]
[]
[null,null,null,null,"Cramer's V",null,{"$f":"SQRT(G13/(G11*(G16-1)))","v":9.3557953836889793E-2}]

{"sheet":"Bonniferoni'sTest","index":2,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,"Source: ","https://www.youtube.com/watch?time_continue=6&v=FrKvSWV1A-Y"]
[null,null,null,"Pearson chi-square test of independence"]
[null,null,null,"example"]
[]
[null,null,null,"Observed","Male","Female","Total"]
[null,null,null,"Married",456,516,{"$f":"SUM(E6:F6)","v":972}]
[null,null,null,"Widowed",58,123,{"$f":"SUM(E7:F7)","v":181}]
[null,null,null,"Divorced",142,172,314]
[null,null,null,"Separated",29,50,79]
[null,null,null,"Never married",188,207,395]
[null,null,null,"Total",{"$f":"SUM(E6:E10)","v":873},{"$f":"SUM(F6:F10)","v":1068},1941]
[]
[null,null,null,"Expected",{"$f":"E5","v":"Male"},{"$f":"F5","v":"Female"}]
[null,null,null,{"$f":"D6","v":"Married"},{"$f":"$G6*E$11/$G$11","v":437.17465224111282},{"$f":"$G6*F$11/$G$11","v":534.82534775888712}]
[null,null,null,"Widowed",{"$f":"$G7*E$11/$G$11","v":81.408037094281298},99.591962905718702]
[null,null,null,"Divorced",141.22720247295209,{"$f":"$G8*F$11/$G$11","v":172.77279752704791}]
[null,null,null,"Separated",35.531684698608963,43.468315301391037]
[null,null,null,"Never married",177.65842349304484,217.34157650695516]
[]
[]
[null,null,null,"Adjusted Residuals"]
[null,null,null,"(O-E)2/E",{"$f":"E5","v":"Male"},{"$f":"F5","v":"Female"}]
[null,null,null,{"$f":"D6","v":"Married"},{"$f":"(E6-E14)/SQRT((E14*(1-($G6/$G$11))*(1-(E$11/$G$11))))","v":1.7178828400011015},{"$f":"(F6-F14)/SQRT((F14*(1-($G6/$G$11))*(1-(F$11/$G$11))))","v":-1.7178828400010964}]
[null,null,null,"Widowed",{"$f":"(E7-E15)/SQRT((E15*(1-($G7/$G$11))*(1-(E$11/$G$11))))","v":-3.6729492745583836},3.6729492745583836]
[null,null,null,"Divorced",{"$f":"(E8-E16)/SQRT((E16*(1-($G8/$G$11))*(1-(E$11/$G$11))))","v":9.5753063604028577E-2},-9.5753063604028577E-2]
[null,null,null,"Separated",{"$f":"(E9-E17)/SQRT((E17*(1-($G9/$G$11))*(1-(E$11/$G$11))))","v":-1.5082293329809682},1.5082293329809677]
[null,null,null,"Never married",{"$f":"(E10-E18)/SQRT((E18*(1-($G10/$G$11))*(1-(E$11/$G$11))))","v":1.1720037775689387},-1.1720037775689387]
[]
[]
[null,null,null,"Significance level",0.05]
[null,null,null,"# of tests",{"$f":"COUNT(E6:E10)*COUNT(E6:F6)","v":10}]
[null,null,null,"Adjusted sig level",{"$f":"E30/E31","v":5.0000000000000001E-3}]
[]
[]
[null,null,null,"z-criteria",{"$f":"NORMSINV(E32/2)","v":-2.8070337683438042}]