T Test in Excel

In this tutorial we will learn how to perform T Test in Excel. When we want to compare two means we use T Test. T Test is the test of null hypothesis, which states the mean of two population are equal.

H0: μ1 – μ2 = 0
H1: μ1 – μ2 ≠ 0

Alternate hypothesis H1 states that the two population means are not equal.

Data:

We will be using the scores of students across two different subjects to depict example on T test in Excel, Which is shown below.

T Test in Excel 1

 

Step 1: On the top right corner of the data tab click data analysis.

T Test in Excel 2

Note: if you can’t able to find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

 

Step 2: Select T – Test Two Sample Assuming Unequal Variances and click ok

T Test in Excel 3

 

Step 3: Click in the Input Range boxes and select the Variable 1 Range A2:A10 and Variable 2 Range B2:B10, Click in the Hypothesized Mean Difference box and enter 0 (H0: μ1 – μ2 = 0) and select the output range as D2, as shown below and click ok.

T Test in Excel 4

So the result will be

T Test in Excel 5

If t Stat < -t Critical two-tail or t Stat > t Critical two-tail, we reject the null hypothesis. In our case 0.201 > -2.13 and 0.201 < 2.13, so we cannot reject null hypothesis.  So both the means do not differ significantly.

previous small t test in excel                                                                                                                next small t test in excel