formula for gap =IF(AND(MATCH(C2,$A$2:$A$16)1,MATCH(C2,A2:A16)COUNT(A2:A16)), MIN(ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(D2,$A$2:$A$16)+1))), IF(MATCH(C2,$A$2:$A$16)=1,ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16)+1)),ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16)-1))))
You really need to change the title of this video. It's very misleading and does not show people how to perform a Q-Test. Awful job.
wut?
can you post a link to the formulas possibly uploaded to an un-editable google docs sheet or something, it'd be of great help
formula for gap
=IF(AND(MATCH(C2,$A$2:$A$16)1,MATCH(C2,A2:A16)COUNT(A2:A16)),
MIN(ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(D2,$A$2:$A$16)+1))),
IF(MATCH(C2,$A$2:$A$16)=1,ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16)+1)),ABS(INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16))-INDEX($A$2:$A$16,MATCH(C2,$A$2:$A$16)-1))))
Does this work for sample numbers greater than 10? I have a sample number of 23.
this is awful.