Inspired by the Real Statistics Resources article by Charles Zaiontz, I wanted to make the described excel formulas work automatically and agnostic to the orientation of the contingency table.
Using the same contingency table as in the real-statistics link above:
A | B | C | D | |
---|---|---|---|---|
5 | Intervention | Control | Total | |
6 | Cured | 2 | 7 | 9 |
7 | Not Cured | 9 | 3 | 12 |