Question 752:An Excel Spreadsheet is reprinted below. Interpret the t-test results. Are they statistically significant?
t-Test: Paired Two Sample for Means
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
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.