This tutorial shows detailed steps of how to do paired-sample t-test in Excel with a data example.
Data Example
The data table shown below has 3 columns, name, math, and English. We are going to compare if Math and English are significantly different.
![Data for Paired Samples t-test](https://tidystat.com/wp-content/uploads/2023/01/image-4.png)
Hypothesis
The followings are the null hypothesis and the alternative one for paired sample t-test.
- Null Hypothesis: Math and English scores do not differ from each other.
- Alternative Hypothesis: Math and English scores do differ from each other.
Step 1: Click “Data Analysis”
Next, click the “Data” menu and find the “Analysis” box. Then, click the “Data Analysis” module.
![](https://tidystat.com/wp-content/uploads/2023/01/image-1.png)
If you can not find the Data Analysis” module, please refer to another tutorial showing how to add “Data Analysis” to Excel.
Step 2:
On the pop-up window, click the “t-Test: Paired Two Sample for Means” and then click “OK.”
![Menu Option for Paired Samples t-test in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-2.png)
Step 3: Input Range
Select B2 to B7 to Variable 1 Range, and C2 to C7 to Variable 2 Range. Then, click “OK.”
![Input Range for Paired Samples t-test in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-5.png)
Step 4: Interpretation
The following is the output of Paired Samples t-test in Excel. We use the two-tail p-value, which is equal to 0.021, namely smaller than 0.05. Thus, we reject the null hypothesis and conclude that Math and English scores do differ from each other.
![Output of Paired Samples t-test in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-6.png)