|
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%. |
|
|
|
|
|
|
|
|
|
|