{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Input","Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[39,0,39,3]]}
["Participant","\"Odds\" total","Evens\" total","Score on Related Measure"]
[1,1,2,3]
[2,2,3,4]
[3,5,6,7]
[4,6,6,4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]

{"sheet":"Analysis","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"Participant"},{"$f":"Input!B1","v":"\"Odds\" total"},{"$f":"Input!C1","v":"Evens\" total"},{"$f":"Input!D1","v":"Score on Related Measure"},"Total Score on Survey (Odds + Evens)"]
[{"$f":"Input!A2","v":1},{"$f":"Input!B2","v":1},{"$f":"Input!C2","v":2},{"$f":"Input!D2","v":3},{"$f":"B2 + C2","v":3}]
[{"$f":"Input!A3","v":2},{"$f":"Input!B3","v":2},{"$f":"Input!C3","v":3},{"$f":"Input!D3","v":4},{"$f":"B3 + C3","v":5}]
[{"$f":"Input!A4","v":3},{"$f":"Input!B4","v":5},{"$f":"Input!C4","v":6},{"$f":"Input!D4","v":7},11]
[{"$f":"Input!A5","v":4},{"$f":"Input!B5","v":6},{"$f":"Input!C5","v":6},{"$f":"Input!D5","v":4},12]
[{"$f":"Input!A6","v":5},7,8,8,15]
[{"$f":"Input!A7","v":6},0,0,{"$f":"Input!D7","v":0},0]
[{"$f":"Input!A8","v":7},0,0,{"$f":"Input!D8","v":0},0]
[{"$f":"Input!A9","v":8},0,0,{"$f":"Input!D9","v":0},0]
[{"$f":"Input!A10","v":9},0,0,{"$f":"Input!D10","v":0},0]
[{"$f":"Input!A11","v":10},null,null,{"$f":"Input!D11","v":0},0]
[{"$f":"Input!A12","v":11},null,null,{"$f":"Input!D12","v":0},0]
[{"$f":"Input!A13","v":12},null,null,{"$f":"Input!D13","v":0},0]
[{"$f":"Input!A14","v":13},null,null,{"$f":"Input!D14","v":0},0]
[{"$f":"Input!A15","v":14},null,null,{"$f":"Input!D15","v":0},0]
[{"$f":"Input!A16","v":15},null,null,{"$f":"Input!D16","v":0},0]
[{"$f":"Input!A17","v":16},null,null,{"$f":"Input!D17","v":0},0]
[{"$f":"Input!A18","v":17},null,null,{"$f":"Input!D18","v":0},0]
[{"$f":"Input!A19","v":18},null,null,{"$f":"Input!D19","v":0},0]
[{"$f":"Input!A20","v":19},null,null,{"$f":"Input!D20","v":0},0]
[{"$f":"Input!A21","v":20},null,null,{"$f":"Input!D21","v":0},0]
[{"$f":"Input!A22","v":21},null,null,{"$f":"Input!D22","v":0},0]
[{"$f":"Input!A23","v":22},null,null,{"$f":"Input!D23","v":0},0]
[{"$f":"Input!A24","v":23},null,null,null,0]
[{"$f":"Input!A25","v":24},null,null,null,0]
[{"$f":"Input!A26","v":25}]
[{"$f":"Input!A27","v":26}]
[{"$f":"Input!A28","v":27}]
[{"$f":"Input!A29","v":28}]
[29]
[30]
["Number of participants",{"$f":" COUNTIF(B2:B31, \">0\")","v":5}]
[]
["Odd Even Correlation = ",{"$f":"CORREL(IF(B2:B31 * C2:C31, B2:B31 ), IF(B2:B31 * C2:C31, C2:C31))","v":0.98575046543204969}]
[]
["Correlation between your survey and a related measure",{"$f":"CORREL(IF(D2:D31 * E2:E31, D2:D31 ), IF(D2:D31 * E2:E31, E2:E31))","v":0.79941087730895843}]