Paired t-test is a parametric test for a difference in central location (mean) between two paired samples.
The requirements of the test are:
Data in existing Excel worksheets can be used and should be arranged in a List dataset layout. The dataset must contain two continuous scale variables.
When entering new data we recommend using New Dataset to create a new 2 variables dataset ready for data entry.
To start the test:
Excel 97, 2000, 2002 & 2003:
Select any cell in the range containing the dataset to analyse, then click Analyse on the Analyse-it toolbar, click Compare Pairs then click t-test.
The report shows the number of observations analysed, and, if applicable, how many missing values were excluded. Summary statistics for each sample and the differences between the samples are then shown.
The difference between the means and confidence interval are shown to quantify the difference between the samples in terms that can be practically evaluated.
The t-statistic and hypothesis test are shown. The p-value is the probability of rejecting the null hypothesis, that the samples have the same mean, when it is in fact true. A significant p-value implies that the two samples have different means.
(click to enlarge)