Paired t-test
Calculates the paired t-Test of two data samples.
To access this command...
Choose Data - Statistics - Paired t-test
A paired t-test is any statistical hypothesis test that follows a Student's t distribution.
For more information on paired t-tests, refer to the corresponding Wikipedia article.
Data
Variable 1 range: The reference of the range of the first data series to analyze.
Variable 2 range: The reference of the range of the second data series to analyze.
Results to: The reference of the top left cell of the range where the test will be displayed.
Grouped By
Select whether the input data has columns or rows layout.
Example
The following table has two data sets.
| | A | B | | | ---- | -- | -- | | 1 | 28 | 19 | | 2 | 26 | 13 | | 3 | 31 | 12 | | 4 | 23 | 5 | | 5 | 20 | 34 | | 6 | 27 | 31 | | 7 | 28 | 31 | | 8 | 14 | 12 | | 9 | 4 | 24 | | 10 | 0 | 23 | | 11 | 2 | 19 | | 12 | 8 | 10 | | 13 | 9 | 33 |
Results for paired t-test:
The following table shows the paired t-test for the data series above:
| paired t-test | ||
|---|---|---|
| Alpha | 0.05 | |
| Hypothesized Mean Difference | 0 | |
| Variable 1 | Variable 2 | |
| Mean | 16.9230769231 | 20.4615384615 |
| Variance | 125.0769230769 | 94.4358974359 |
| Observations | 13 | 13 |
| Pearson Correlation | -0.0617539772 | |
| Observed Mean Difference | -3.5384615385 | |
| Variance of the Differences | 232.9358974359 | |
| df | 12 | |
| t Stat | -0.8359262137 | |
| P (T<=t) one-tail | 0.2097651442 | |
| t Critical one-tail | 1.7822875556 | |
| P (T<=t) two-tail | 0.4195302884 | |
| t Critical two-tail | 2.1788128297 |