{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Example 1","Example 2","Sheet"],"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":"Example 1","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,3,5,3]]}
["Three","Two"]
[1,0,null,"In this case a three level variable is perfectly related to a two level variable in such a way that whenever the three level variable is 1 or 3 the two level variable is 0 otherwise the two level variable is 0.  If we examine this relationship using correlations, we will find no correlation which would suggest no relationship.  The perfect relationship is captured in the Cramer's V Matrix."]
[2,1]
[3,0]
[1,0]
[2,1]
[3,0]
[1,0]
[2,1]
[3,0]
[]
["Correlation Matrix"]
[{"$f":"CORREL($A$2:$A$10,A$2:A$10)","v":1},{"$f":"CORREL($A$2:$A$10,B$2:B$10)","v":0}]
[{"$f":"CORREL(A$2:A$10,$B$2:$B$10)","v":0},{"$f":"CORREL(B$2:B$10,$B$2:$B$10)","v":1}]
[]
["Cramer's V Matrix"]
[{"$f":"Cramv($A$2:$A$10,A$2:A$10)","v":1},{"$f":"Cramv($A$2:$A$10,B$2:B$10)","v":1}]
[{"$f":"Cramv($B$2:$B$10,A$2:A$10)","v":1},{"$f":"Cramv($B$2:$B$10,B$2:B$10)","v":1}]

{"sheet":"Example 2","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,5,6,5]]}
["Var1","Var2","Var3","Var4"]
[0,1,0,0,null,"Var1 and Var2 are correlated at 0.1.  Because, they are dummy coded as \"0\" and \"1\" we would expect the same relationship in the Cramer's V.  Variable 3 perfectly but negatively correlated producing a correlation of -1.  The same strength is captured in Cramer's V except because the order of a categorical variable is meaningless, the negative is lost.  Finally,  Var4 and Var3 are related at -0.3.  The Cramer's V relationship is of the same strength but looses the negative value."]
[1,1,0,0]
[0,0,1,0]
[1,0,1,0]
[0,1,0,1]
[1,0,1,0]
[0,0,1,0]
[1,1,0,1]
[0,0,1,1]
[]
["Correlation Matrix"]
[{"$f":"CORREL($A$2:$A$10,A$2:A$10)","v":0.99999999999999989},{"$f":"CORREL($A$2:$A$10,B$2:B$10)","v":0.10000000000000003},{"$f":"CORREL($A$2:$A$10,C$2:C$10)","v":-0.10000000000000003},{"$f":"CORREL($A$2:$A$10,D$2:D$10)","v":-0.15811388300841897}]
[{"$f":"CORREL(A$2:A$10,$B$2:$B$10)","v":0.10000000000000003},{"$f":"CORREL(B$2:B$10,$B$2:$B$10)","v":0.99999999999999989},{"$f":"CORREL(C$2:C$10,$B$2:$B$10)","v":-0.99999999999999989},{"$f":"CORREL(D$2:D$10,$B$2:$B$10)","v":0.31622776601683794}]
[{"$f":"CORREL(A$2:A$10,$C$2:$C$10)","v":-0.10000000000000003},{"$f":"CORREL(B$2:B$10,$C$2:$C$10)","v":-0.99999999999999989},{"$f":"CORREL(C$2:C$10,$C$2:$C$10)","v":0.99999999999999989},{"$f":"CORREL(D$2:D$10,$C$2:$C$10)","v":-0.31622776601683794}]
[{"$f":"CORREL(A$2:A$10,$D$2:$D$10)","v":-0.15811388300841897},{"$f":"CORREL(B$2:B$10,$D$2:$D$10)","v":0.31622776601683794},{"$f":"CORREL(C$2:C$10,$D$2:$D$10)","v":-0.31622776601683794},{"$f":"CORREL(D$2:D$10,$D$2:$D$10)","v":1}]
[]
["Cramer's V Matrix"]
[{"$f":"Cramv($A$2:$A$10,A$2:A$10)","v":1},{"$f":"Cramv($A$2:$A$10,B$2:B$10)","v":0.10000000000000005},{"$f":"Cramv($A$2:$A$10,C$2:C$10)","v":0.10000000000000005},{"$f":"Cramv($A$2:$A$10,D$2:D$10)","v":0.15811388300841897}]
[{"$f":"Cramv($B$2:$B$10,A$2:A$10)","v":0.10000000000000005},{"$f":"Cramv($B$2:$B$10,B$2:B$10)","v":1},{"$f":"Cramv($B$2:$B$10,C$2:C$10)","v":1},{"$f":"Cramv($B$2:$B$10,D$2:D$10)","v":0.31622776601683794}]
[{"$f":"Cramv($C$2:$C$10,A$2:A$10)","v":0.10000000000000005},{"$f":"Cramv($C$2:$C$10,B$2:B$10)","v":1},{"$f":"Cramv($C$2:$C$10,C$2:C$10)","v":1},{"$f":"Cramv($C$2:$C$10,D$2:D$10)","v":0.31622776601683794}]
[{"$f":"Cramv($D$2:$D$10,A$2:A$10)","v":0.15811388300841897},{"$f":"Cramv($D$2:$D$10,B$2:B$10)","v":0.31622776601683794},{"$f":"Cramv($D$2:$D$10,C$2:C$10)","v":0.31622776601683794},{"$f":"Cramv($D$2:$D$10,D$2:D$10)","v":1}]

{"sheet":"Sheet","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}