T Test Statistics in Calc/text/scalc/01/statistics_test_t.xhpAnalysis toolpack;t-testAnalysis toolpack;paired t-testt-test;Analysis toolpackpaired t-test;Analysis toolpackData statistics;paired t-test
Paired t-test
Calculates the paired t-Test of two data samples.Choose 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.
Results for paired t-test:
The following table shows the paired t-test for the data series above:
paired t-testAlpha0.05Hypothesized Mean Difference0Variable 1Variable 2Mean16.923076923120.4615384615Variance125.076923076994.4358974359Observations1313Pearson Correlation-0.0617539772Observed Mean Difference-3.5384615385Variance of the Differences232.9358974359df 12t Stat-0.8359262137P (T<=t) one-tail0.2097651442t Critical one-tail1.7822875556P (T<=t) two-tail0.4195302884t Critical two-tail2.1788128297