|
XLSTAT 2006.5 - Two-sample t-test and
z-test - on 11/27/2006 at 11:37:15 AM |
|
|
|
|
|
|
|
|
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg
MAF'!$D$20:$D$39 / 20 rows and 1 column |
|
|
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg
MAF'!$D$34:$D$53 / 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 |
7.350 |
32.600 |
15.757 |
5.799 |
|
Var1(2) |
20 |
0 |
20 |
7.330 |
32.600 |
15.861 |
6.206 |
|
|
t-test for two independent samples / Two-tailed test: |
|
|
|
95% confidence interval on the difference between the means: |
|
|
] -3.949 , |
3.741 [ |
|
|
|
Difference |
-0.104 |
|
|
t (Observed value) |
-0.055 |
|
|
t (Critical value) |
2.024 |
|
|
DF |
38 |
|
|
p-value (Two-tailed) |
0.957 |
|
|
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
95.66%. |
|
|
|
|
|
|
|
|
|
|