{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Binary Outcome - McNemar"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Binary Outcome - McNemar","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Sensitivity Analysis for McNemar's Test: Simplied Formula"]
["Section 4.3.2. of Rosenbaum PR (2002) Observational Studies, 2nd Edition."]
["INSERT VALUES (IN RED) IN CELLS HIGHLIGHTED IN YELLOW."]
["Two-By-Two Table","Treated, outcome = Yes","Treated, outcome = No"]
["Control, outcome = Yes",10,40,{"$f":"B5+C5","v":50}]
["Control, outcome = No",33,193,{"$f":"B6+C6","v":226}]
[null,{"$f":"B5+B6","v":43},{"$f":"C5+C6","v":233},{"$f":"SUM(B5:C6)","v":276}]
[]
["Computed Summaries"]
["# of Pairs",{"$f":"D7","v":276},"# of matched pairs (overall)"]
["# of Discordant Pairs",{"$f":"B6+C5","v":73},"# of matched pairs in which exactly one has the outcome"]
["Test Statistic",{"$f":"B6","v":33},"# of discordant pairs where Treated has outcome"]
[]
["Sensitivity Analysis"]
["Gamma Values","2-tail P value (lower bound)","2-tail P value (upper bound)","P+","P-"]
[1,0,0,{"$f":"1/(1+A16)","v":0.5},{"$f":"A16/(A16+1)","v":0.5}]
[1.5,0,3.26405569239796e-14,0.4,0.6]
[2,0,5.5753490713073e-10,0.333333333333333,0.666666666666667]
[2.5,0,2.29826107922548e-7,0.285714285714286,0.714285714285714]
[3,0,1.26538924247743e-5,0.25,0.75]
[3.5,0,0.000209212118022828,0.222222222222222,0.777777777777778]
[4,0,0.00160088580352635,0.2,0.8]
[4.5,0,0.00728983637229619,0.181818181818182,0.818181818181818]
[5,0,0.0230796632732422,0.166666666666667,0.833333333333333]
[5.5,0,0.0562103302304242,0.153846153846154,0.846153846153846]
[6,0,0.112763106551162,0.142857142857143,0.857142857142857]
[]
["Insert Gamma Value Below","2-tail P value (lower bound)","2-tail P value (upper bound)","P+","P-"]
[5.472,0,0.0499,{"$f":"1/(1+A29)","v":0.15451174289246},{"$f":"A29/(A29+1)","v":0.84548825710754}]
["Stop when value for the upper bound of the P value (cell C29) is just below desired two-tailed significance level"]