SigTest - TINV(0.05,(B6+C6-2)) 13 14 Analysis If t(calc)...

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

View Full Document Right Arrow Icon
A B C D E F G 1 T-test for significance of differences between two samples at 95% level of confidence 2 3 Sample 1 Sample 2 4 Average 2.310109 2.299472 5 Std. Dev. 0.000143 0.001379 6 n 7 8 7 8 s(pooled) 0.00101656 SQRT(((B5^2)*(B6-1) +(C5^2)*(C6-1))/(B6+C6-2)) 9 10 t(calc) 20.2177872 abs((C4-B4)/B8)*SQRT((B6*C6)/(B6+C6)) 11 12 t(table) 2.16036865
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: TINV(0.05,(B6+C6-2)) 13 14 Analysis If t(calc) > t(table), then difference is significant, else NOT IF(B10>B12,B16,B18) 15 16 Difference is significant 17 Choices OR 18 Difference is NOT significant 19 20 21 22 Conclusion Difference is significant 23 at the 95% Level of Confidence 24...
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