sensitivity spreadsheet
DESCRIPTION
Sensitivity SpreadsheetTRANSCRIPT
Sensitivity Analysis for McNemar's Test: Simplied FormulaSection 4.3.2. of Rosenbaum PR (2002) Observational Studies, 2nd Edition.
Two-By-Two Table Treated, outcome = Yes Treated, outcome = NoControl, outcome = Yes 175 12 187Control, outcome = No 110 703 813
285 715 1000
Computed Summaries# of Pairs 1000 # of matched pairs (overall)
# of Discordant Pairs 122 # of matched pairs in which exactly one has the outcomeTest Statistic 110 # of discordant pairs where Treated has outcome
Sensitivity AnalysisGamma Values 2-tail P value (lower bound) 2-tail P value (upper bound) P+
1.0 0.0000 0.0000 0.5001.5 0.0000 0.0000 0.4002.0 0.0000 0.0000 0.3332.5 0.0000 0.0000 0.2863.0 0.0000 0.0000 0.2503.5 0.0000 0.0002 0.2224.0 0.0000 0.0016 0.2004.5 0.0000 0.0073 0.1825.0 0.0000 0.0231 0.1675.5 0.0000 0.0562 0.1546.0 0.0000 0.1128 0.143
Insert Gamma Value Below 2-tail P value (lower bound) 2-tail P value (upper bound) P+5.426 0.0000 0.0499 0.156
INSERT VALUES (IN RED) IN CELLS HIGHLIGHTED IN YELLOW.
Stop when value for the upper bound of the P value (cell C29) is just below desired two-tailed significance level
# of matched pairs in which exactly one has the outcome# of discordant pairs where Treated has outcome
P-0.5000.6000.6670.7140.7500.7780.8000.8180.8330.8460.857
P-0.844
just below desired two-tailed significance level
Sensitivity Analysis for McNemar's Test: Simplied FormulaSection 4.3.3. of Rosenbaum PR (2002) Observational Studies, 2nd Edition.
DataTotal # of Pairs (S) 33Wilcoxon Test Statistic, T 527 sum of ranks of absolute differences for pairs where exposed had higher value than control
Sensitivity AnalysisGamma Values 2-tail P value (lower bound) 2-tail P value (upper bound)
1.0 0.0000 0.00001.5 0.0000 0.00052.0 0.0000 0.00372.5 0.0000 0.01253.0 0.0000 0.02843.5 0.0000 0.05144.0 0.0000 0.08074.5 0.0000 0.11525.0 0.0000 0.15385.5 0.0000 0.19526.0 0.0000 0.2388
Insert Gamma Value Below 2-tail P value (lower bound) 2-tail P value (upper bound)4.286 0.0000 0.0999
INSERT VALUES (IN RED) IN CELLS HIGHLIGHTED IN YELLOW.
Stop when value for the upper bound of the P value (cell C24) is just below desired two-tailed significance level
sum of ranks of absolute differences for pairs where exposed had higher value than control
P+ P- E(T+) E(T-) SD(T+)0.500 0.500 280.50 280.50 55.970.400 0.600 224.40 336.60 54.840.333 0.667 187.00 374.00 52.770.286 0.714 160.29 400.71 50.570.250 0.750 140.25 420.75 48.470.222 0.778 124.67 436.33 46.530.200 0.800 112.20 448.80 44.770.182 0.818 102.00 459.00 43.170.167 0.833 93.50 467.50 41.710.154 0.846 86.31 474.69 40.390.143 0.857 80.14 480.86 39.17
P+ P- E(T+) E(T-) SD(T+)0.189 0.811 106.13 454.87 43.84
just below desired two-tailed significance level
Sensitivity Analysis for A Simple Comparison for Censored SurvivalSection 4.4.8. of Rosenbaum PR (2002) Observational Studies, 2nd Edition.
DataTotal # of Pairs With A Clear Winner 440T = # of Pairs Where Exposed Outlives Control 335
Sensitivity AnalysisGamma Values 2-tail P value (lower bound)
1.0 0.00001.5 0.00002.0 0.00002.5 0.00003.0 0.00003.5 0.00004.0 0.00004.5 0.00005.0 0.00005.5 0.00006.0 0.0000
Insert Gamma Value Below 2-tail P value (lower bound)2.563 0.0000
INSERT VALUES (IN RED) IN CELLS HIGHLIGHTED IN YELLOW.
Stop when value for the upper bound of the P value (cell C24) is just below desired two-tailed significance level
2-tail P value (upper bound) P+ P- E(T+) E(T-) SD(T+)0.0000 0.500 0.500 220.00 220.00 10.490.0000 0.400 0.600 176.00 264.00 10.280.0000 0.333 0.667 146.67 293.33 9.890.0288 0.286 0.714 125.71 314.29 9.480.5820 0.250 0.750 110.00 330.00 9.081.0000 0.222 0.778 97.78 342.22 8.721.0000 0.200 0.800 88.00 352.00 8.391.0000 0.182 0.818 80.00 360.00 8.091.0000 0.167 0.833 73.33 366.67 7.821.0000 0.154 0.846 67.69 372.31 7.571.0000 0.143 0.857 62.86 377.14 7.34
2-tail P value (upper bound) P+ P- E(T+) E(T-) SD(T+)0.0498 0.281 0.719 123.49 316.51 9.43
just below desired two-tailed significance level