Log-in | Contact Jeff | Email Updates

Question 752:

An Excel Spreadsheet is reprinted below. Interpret the t-test results. Are they statistically significant?

t-Test: Paired Two Sample for Means
Beer Soda

Variable 1 Variable 2
Mean 16.83333333 15.8
Variance 10.35057471 7.820689655
Observations 30 30
Pearson Correlation 0.264451682
Hypothesized Mean Difference 0
df 29
t Stat 1.545410551
P(T<=t) one-tail 0.06654553
t Critical one-tail 1.699127097
P(T<=t) two-tail 0.13309106
t Critical two-tail 2.045230758

Need more than just an answer? Download the Easy t Excel T-test Calculator Package which gets you the answer with the detailed calculations.

Not what you were looking for or need help?

Ask a new Question

Browse All 872 Questions

Search All Questions: