the Statistics Add-In for Microsoft® Excel

McNemar Test

Sample Results as an Excel Table:

         

McNemar Test

       
         

Column variable:

Medicine

     

Row variable:

Placebo

     
         
 

yes

no

Sums

 
         

yes

2

1

3

 

no

8

9

17

 
         

Sums

10

10

20

 
         
 

Chi-Square

Degrees of freedom

P

Kappa

         
 

3.6

1

0.05777958

0.1