Pass or fail? Binomialrelated hypothesis testing and confidence intervals using paired samples - Improving the User Experience through Practical Data Analytics - page 128

Now calculate Q using this formula:

(

K*TSSQ−T 2

)

Q= (K−1) * /(K*D12−E12)

(
2*61−11 2

)

=1* /(2*11−19)

=1* (122−121)/(22−19)
=1/3
=0 . 333

Step (6) Now we use the Q value (0.333) to ind the p -value of the test. We do this
by using the Excel command.

FIGURE 5.6
Calculating the sum of columns E and F; Excel.

After pressing "Enter," this
cell displays the p -value:
.564

FIGURE 5.7
Setting up to ind the p -value of the Cochran Q test; Excel.