|
XLSTAT 2006.5 - Two-sample t-test and
z-test - on 11/27/2006 at 11:57:22 AM |
|
|
|
|
|
|
|
|
Sample 1: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg
MAF'!$V$29:$V$48 / 20 rows and 1 column |
|
|
Sample 2: Workbook = Avg_MAF.xls / Sheet = Avg MAF / Range = 'Avg
MAF'!$V$17:$V$35 / 19 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 |
56.700 |
180.100 |
102.190 |
38.165 |
|
Var1(2) |
19 |
0 |
19 |
52.500 |
147.500 |
87.689 |
24.500 |
|
|
t-test for two independent samples / Two-tailed test: |
|
|
|
95% confidence interval on the difference between the means: |
|
|
] -6.433 , |
35.434 [ |
|
|
|
Difference |
14.501 |
|
|
t (Observed value) |
1.404 |
|
|
t (Critical value) |
2.026 |
|
|
DF |
37 |
|
|
p-value (Two-tailed) |
0.169 |
|
|
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
16.88%. |
|
|
|
|
|
|
|
|
|
|