XLSTAT 2006.5 - Two-sample t-test and z-test - on 11/27/2006 at 11:58:46 AM
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$AC$6:$AC$15 / 10 rows and 1 column
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$AC$16:$AC$25 / 10 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 10 0 10 0.112 3.680 1.017 1.090
Var1(2) 10 0 10 0.275 3.710 1.380 1.016
t-test for two independent samples / Two-tailed test:
95% confidence interval on the difference between the means:
] -1.352 , 0.628 [
Difference -0.362
t (Observed value) -0.769
t (Critical value) 2.101
DF 18
p-value (Two-tailed) 0.452
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 45.18%.