Q-testExcel2

Q-testExcel2 - 17 Conclusion Retain suspect result 18 19...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Q-test 0 A B C D E 1 Trial # Ordinal %Cu 2 5 12.30 3 3 12.36 4 1 12.42 5 6 12.52 6 2 12.58 7 4 12.90 8 9 Suspect value 12.90 =IF((B3-B2)>(B7-B6),B2,B7) 10 Gap 0.32 =IF((B3-B2)>(B7-B6),(B3-B2),(B7-B6)) 11 Range 0.60 =MAX(B2:B7)-MIN(B2:B7) 12 Q(calc) 0.53 =B10/B11 13 14 Number, n 6 =COUNT(B2:B7) 15 Q(table) 0.56 =VLOOKUP(B14,A24:B31),2) 16 Decision Retain IF(B12>B15,D25,D26)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 17 Conclusion Retain suspect result 18 19 Mean 12.51 =AVERAGE(B2:B7) 20 Median 12.47 =MEDIAN(B2:B7) 21 22 23 24 Excel does not have a Q table. This table is for 90% C.L. 25 26 n Q(table) Reject 27 3 0.94 Retain 28 4 0.76 29 5 0.64 30 6 0.56 31 7 0.51 32 8 0.47 33 9 0.44 34 10 0.41...
View Full Document

Ask a homework question - tutors are online