XLSTAT 2006.5 - Two-sample t-test and z-test - on 11/27/2006 at 11:35:12 AM
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$J$20:$J$29 / 10 rows and 1 column
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg MAF'!$J$26:$J$35 / 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 1.890 6.620 3.991 1.391
Var1(2) 10 0 10 1.890 6.790 3.921 1.593
t-test for two independent samples / Two-tailed test:
95% confidence interval on the difference between the means:
] -1.335 , 1.475 [
Difference 0.070
t (Observed value) 0.105
t (Critical value) 2.101
DF 18
p-value (Two-tailed) 0.918
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 91.78%.