Manuals/calci/TTESTPAIRED
TTESTPAIRED(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)
=TTESTPAIRED (R1C1:R6C1, R1C2:R6C2, 0, 0.05, TRUE)
TTESTPAIRED returns the result in new sheet(5Space).
=TTESTPAIRED(R1C1:R4C1,R1C2:R6C2, 0, 0.055, TRUE)
TTESTPAIRED returns the #ERROR(LengthofArray1 != LengthofArray2).
T-TEST : PAIRED TWO SAMPLE FOR MEANS
If the Alpha < 0 or Alpha >1, TTESTPAIRED returns the #ERROR.
TTESTPAIRED returns the #ERROR, if Length of Array1 != Length of Array2.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 5Space | |
| Row2 | 7 | 8 | ||
| Row3 | 12 | 5 | #ERROR | |
| Row4 | 17 | 18 | ||
| Row5 | 37 | 31 | ||
| Row6 | 6 | 9 |
| Variable1 | Varianble2 | |
|---|---|---|
| Mean | 13.333333333333334 | 12.333333333333334 |
| Variance | 164.26666666666665 | 110.26666666666665 |
| Observations | 6 | 6 |
| Pearson Correlation | 0.9500807056547026 | |
| Hypothesized Mean Difference | 0 | |
| Degree Of Freedom | 5 | |
| T Statistics | 0.5649326828660319 | |
| P(T<=t) One-tail | 0.29826188106281603 | |
| T Critical One-tail | 2.015048294624481 | |
| P(T<=t) Two-tail | 0.5965237621256321 | |
| T Critical Two-tail | 2.5705816859349686 |