Manuals/calci/TTESTUNEQUALVARIANCES
TTESTTWOSAMPLESUNEQUALVARIANCES(Array1, Array2, HypothesizeDiff, Alpha, NewTableFlag)
where,
Array1 - Input range should be one block.
Array2 - Input range should be one block.
HypothesizeDiff - represents the Hypothesized Mean Difference.A value 0 indicates that sample means are hypothesized to be equal.
Alpha - represents the significance level and value in range 0 to 1.
' 'NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.Lets see an example in (Column3Row1)
=TTESTTWOSAMPLESUNEQUALVARIANCES (R1C1:R6C1, R1C2:R5C2, 0, 0.05, TRUE)
TTESTTWOSAMPLESUNEQUALVARIANCES returns the result in new sheet(9Space).
=TTESTTWOSAMPLESUNEQUALVARIANCES(R1C1:R4C1,R1C2:R6C2, 0,- 0.055, TRUE)
TTESTTWOSAMPLESUNEQUALVARIANCES returns the #ERROR(Alpha = -0.055).
T-TEST : TWO SAMPLE ASSUMING UNEQUAL VARIANCES
If the Alpha < 0 or Alpha >1, TTESTTWOSAMPLESUNEQUALVARIANCES returns the #ERROR.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 3 | 5Space | |
| Row2 | 7 | 8 | ||
| Row3 | 12 | 8 | ||
| Row4 | 17 | 18 | #ERROR | |
| Row5 | 46 | 34 | ||
| Row6 | 6 | 7 |
| Variable1 | Variable2 | |
|---|---|---|
| Mean | 16.333333333333332 | 14.2 |
| Variance | 226.66666666666668 | 152.2 |
| Observations | 6 | 5 |
| Hypothesized Mean Difference | 0 | |
| Degree Of Freedom | 9 | |
| T Statistics | 0.2582913934642728 | |
| P(T<=t) One-tail | 0.4009958484338277 | |
| T Critical One-tail | 1.833112928058645 | |
| P(T<=t) Two-tail | 0.8019916968676554 | |
| T Critical Two-tail | 2.262157150957689 |