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