Paired t-Test Principles, Calculations, and Software Analysis
Foundations and Principles of the Paired t-Test
Conceptual Definition:
A paired -test is a specific application and special case of the single-sample -test.
Instead of evaluating two entirely independent groups, the test evaluates two sets of measurements collected from matched samples or paired observations.
In most research configurations, measurements are taken on the exact same experimental unit under two distinct conditions or points in time.
Common experimental scenarios include:
Before-and-after studies (evaluating an intervention on the same subject).
Diurnal comparisons (such as comparing daytime measurements against nighttime measurements on the same subject).
Reduction to a Single-Sample Framework:
While frequently treated as an independent statistical procedure, the paired -test mathematically converts paired bivariate data into a single sample of univariate differences.
The core variable of interest is not the raw measurement in condition or condition , but rather the calculated difference () between the paired observations for each individual unit.
Once these differences are determined, the analysis proceeds identically to a standard one-sample -test performed on the newly derived sample of differences.
Underlying Assumptions:
Random sampling: The pairs of observations must represent a random sample drawn from the target population.
Normality of differences: The sample of differences () must be normally distributed in the underlying population.
Experimental Design and Stair-Climbing Case Study
Research Question:
The objective is to determine whether physical exertion affects cardiovascular response, specifically asking: Does climbing stairs affect heart rate?
Although a directional hypothesis (e.g., climbing stairs increases heart rate) is biologically plausible and corresponds to a one-tailed test, the analysis is initially framed as a non-directional, two-tailed inquiry (does climbing stairs affect heart rate in either direction).
Experimental Protocol:
A cohort of subjects has their resting heart rates measured before physical activity.
Each subject climbs three flights of stairs.
Immediately following the stair climb, each subject's heart rate is measured a second time.
Baseline Data Matrix:
Subject (Bob): Heart rate before climbing = , Heart rate after climbing = .
Subject (Sally): Heart rate before climbing = , Heart rate after climbing = .
Subject (Meghan): Heart rate before climbing = , Heart rate after climbing = .
Subject (Bill): Heart rate before climbing = , Heart rate after climbing = .
Subject (Harriet): Heart rate before climbing = , Heart rate after climbing = .
Subject (Mary): Heart rate before climbing = , Heart rate after climbing = .
Subject (Carl): Heart rate before climbing = , Heart rate after climbing = .
Subject (Sid): Heart rate before climbing = , Heart rate after climbing = .
Formulation of Hypotheses and Test Setup
Defining the Difference Variable:
The difference metric is explicitly defined as:
Under this directional subtraction:
A positive difference () indicates an increase in heart rate following stair climbing.
A negative difference () indicates a decrease in heart rate following stair climbing.
A difference of zero () indicates no change in heart rate.
Statistical Hypotheses:
Null Hypothesis (): There is no true difference in mean heart rate before and after climbing stairs across the population.
Alternative Hypothesis ( or ): There is a statistically significant difference in mean heart rate before and after climbing stairs.
Here, represents the population mean of the paired differences.
Significance Level and Tail Configuration:
The significance threshold is set at .
Because the alternative hypothesis tests for any change (), the test is two-tailed, splitting the rejection region into two equal tails of area each.

General Forms of Hypothesis Tests for Means:
Two-tailed test: Rejection regions are placed symmetrically in both tails beyond and .
Right-tailed (upper-tail) test: Rejection region is located entirely in the right tail beyond .
Left-tailed (lower-tail) test: Rejection region is located entirely in the left tail beyond .
Critical Values, Decision Rules, and Sampling Distribution
Degrees of Freedom:
The degrees of freedom () for a paired -test are determined by the number of paired differences minus one:
Critical Value Identification:
Evaluating the Student's -distribution table with and an upper tail probability of (corresponding to a two-tailed confidence level of or ):
Because the test is two-tailed, the two critical thresholds are:

Statistical Decision Criteria:
If the calculated test statistic satisfies or , the test statistic falls into the rejection region.
Falling in the critical region indicates that the probability of observing such extreme differences under the assumption of a true null hypothesis is less than ().
Decision rule: Reject in favor of if . Fail to reject if .
Manual Step-by-Step Mathematical Calculation
Test Statistic Formula:
The general test statistic for a sample of differences is:
Where:
is the sample mean of the differences.
is the hypothesized population difference under the null hypothesis (typically ).
is the sample standard deviation of the differences.
is the total number of paired units ().
represents the estimated standard error of the mean difference ().
Setting , the formula reduces to:
Subject-Level Differences:
Bob: (recorded manually as )
Sally:
Meghan:
Bill:
Harriet:
Mary:
Carl:
Sid:
Manual Sample Summary Statistics:
Sample size:
Sample mean difference:
Sample standard deviation of differences:
Evaluation of the Test Statistic:
Standard error denominator:
Substitution into the -ratio:
Hypothesis Decision:
Comparing the calculated statistic to the critical value:
The test statistic falls deep within the upper rejection tail.
Conclusion: Reject . There is statistically significant evidence at the level that climbing stairs affects heart rate.
Implementation and Analysis in Microsoft Excel
Data Arrangement:
Column A: Subject identifiers (
Name), rows through .Column B: Baseline measurements (
Before), rows through .Column C: Post-intervention measurements (
After), rows through .
Software Navigation:
Navigate through the Excel ribbon to the
Datatab.Within the
Analysisgroup, selectData Analysis.From the list of analysis tools, choose
t-Test: Paired Two Sample for Meansand clickOK.

Parameter Configuration:
Variable 1 Range:$C$1:$C$9(corresponding to theAftercolumn, including header label).Variable 2 Range:$B$1:$B$9(corresponding to theBeforecolumn, including header label).Hypothesized Mean Difference: leave blank or enter0.Labels: select the checkbox (indicating row contains column headers).Alpha:0.05.Output options: selectNew Worksheet Plyand title itPaired t-test results.
Excel Computational Output:
Mean: After = , Before =Variance: After = , Before =Observations: After = , Before =Pearson Correlation:Hypothesized Mean Difference:df:t Stat:P(T<=t) one-tail:t Critical one-tail:P(T<=t) two-tail:t Critical two-tail:
Interpretation of Excel Output:
The two-tailed -value is .
Because , the null hypothesis is rejected.
The calculated -statistic of exceeds the critical threshold of .
Implementation and Analysis in Minitab
Worksheet Setup:
Column
C1-T:Name(Bob, Sally, Meghan, Bill, Harriet, Mary, Carl, Sid).Column
C2:Before(, , , , , , , ).Column
C3:After(, , , , , , , ).
Menu Pathway and Dialog Options:
Menu path:
Stat->Basic Statistics->Paired t....In the primary dialog window:
Choose the radio button
Samples in columns.Set
First sample:After.Set
Second sample:Before.(Minitab evaluates the paired test as first sample minus second sample).
Click the
Options...sub-menu:Confidence level:95.0.Test mean:0.0.Alternative: selectnot equal.Confirm by selecting
OKin both dialogs.

Minitab Session Window Output:
Paired for
After-Before:After: , , ,Before: , , ,Difference: , , ,Confidence Interval for mean difference:
-Test of mean difference = (vs not = ):
Graphical Interpretation and Final Conclusions

Visual Analysis of the Boxplot of Differences:
The boxplot displays the distribution of the eight difference scores along an axis spanning from to .
The median difference lies near .
The sample mean difference is marked at .
The horizontal blue interval bracket denotes the -confidence interval for the true mean difference, spanning from to .
The null hypothesis value () is plotted as a red crossed circle at .
Because the null value () falls completely outside the confidence interval boundary (), the null hypothesis is rejected at the level.
Synthesis of Test Results Across Methods:
Manual calculation: , exceeding the critical value .
Excel analysis: , critical , .
Minitab analysis: , , CI: .
All computational methods provide consistent and conclusive statistical evidence rejecting the null hypothesis, confirming that climbing stairs produces a statistically significant change in heart rate.
Lecture
Paired t-test looks at two sets of measurements on MATCHED samples; meaning its the same measurements; kinda like a before and after, daytime and nighttime. Single sample of DIFFERENCES.
Calculating t:
will usually be 0, so it can be dropped from the equation.
For Minitab
Go to Basic Statistics
Choose Paired T-test
It will subtract second sample from first sample; First sample should be for “AFTER” data, and the second sample for “BEFORE” data
Go into options to determine the parameters and what type of tailed test