Q-testExcel

# Q-testExcel - Decision Retain suspect result Mean 12.51 =AVERAGE(B2:B7 Median 12.47 =MEDIAN(B2:B7 Excel does not have a Q table This table is for

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

Q-test Trial # Ordinal %Cu 5 12.30 3 12.36 1 12.42 6 12.52 2 12.58 4 12.90 Suspect value 12.90 =IF((B3-B2)>(B7-B6),B2,B7) Gap 0.32 =IF((B3-B2)>(B7-B6),(B3-B2),(B7-B6)) Range 0.60 =MAX(B2:B7)-MIN(B2:B7) Q(calc) 0.53 =B10/B11 Number, n 6 =COUNT(B2:B7) Q(table) 0.56 =VLOOKUP(B14,A24:B31),2)
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Decision Retain suspect result Mean 12.51 =AVERAGE(B2:B7) Median 12.47 =MEDIAN(B2:B7) Excel does not have a Q table. This table is for 90% C.L. n Q(table) Reject 3 0.94 Retain 4 0.76 5 0.64 6 0.56 7 0.51 8 0.47 9 0.44 10 0.41...
View Full Document

## This note was uploaded on 10/19/2011 for the course CHEM 197 taught by Professor Bonk during the Summer '11 term at Duke.

Ask a homework question - tutors are online