Парный t-критерий
Calculates the paired t-Test of two data samples.
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.
Данные
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.
Results for paired t-test:
The following table shows the paired t-test for the data series above:
|
парный t-критерий |
||
|---|---|---|
|
Альфа |
0.05 |
|
|
Гипотетическая разность средних |
0 |
|
|
Variable 1 |
Variable 2 |
|
|
Среднее |
16.9230769231 |
20.4615384615 |
|
Дисперсия |
125.0769230769 |
94.4358974359 |
|
Наблюдения |
13 |
13 |
|
Корреляция Пирсона |
-0.0617539772 |
|
|
Наблюдаемая разность средних |
-3.5384615385 |
|
|
Дисперсия разностей |
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 |