We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Office hours: 9am-5pm GMT Mon-Fri
It's Tuesday 5:02 PM and the office is closed - e-mail us and we'll get back to you as soon as possible.
This procedure is available in both the Analyse-it Standard and the Analyse-it Method Evaluation edition
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.