XLSTAT 2006.5 - Two-sample t-test and z-test - on 11/27/2006 at 11:57:22 AM
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$V$29:$V$48 / 20 rows and 1 column
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$V$17:$V$35 / 19 rows and 1 column
Hypothesized difference (D): 0
Significance level (%): 5
Summary statistics:
Variable Observations Obs. with missing data Obs. without missing data Minimum Maximum Mean Std. deviation
Var1 20 0 20 56.700 180.100 102.190 38.165
Var1(2) 19 0 19 52.500 147.500 87.689 24.500
t-test for two independent samples / Two-tailed test:
95% confidence interval on the difference between the means:
] -6.433 , 35.434 [
Difference 14.501
t (Observed value) 1.404
t (Critical value) 2.026
DF 37
p-value (Two-tailed) 0.169
alpha 0.05
Test interpretation:
H0: The difference between the means is not significantly different from 0.
Ha: The difference between the means is significantly different from 0.
As the computed p-value is greater than the significance level alpha=0.05, one should accept the null hypothesis H0.
The risk to reject the null hypothesis H0 while it is true is 16.88%.