XLSTAT 2006.5 - Two-sample t-test and z-test - on 11/27/2006 at 11:55:29 AM
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$V$4:$V$23 / 20 rows and 1 column
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$V$29:$V$48 / 20 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 51.100 250.300 99.360 46.699
Var1(2) 20 0 20 56.700 180.100 102.190 38.165
t-test for two independent samples / Two-tailed test:
95% confidence interval on the difference between the means:
] -30.131 , 24.471 [
Difference -2.830
t (Observed value) -0.210
t (Critical value) 2.024
DF 38
p-value (Two-tailed) 0.835
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 83.49%.