The article will show you how to do a **T Test** in Excel. **T-Tests** are hypothesis tests that evaluate one or two groups’ means. Hypothesis tests employ sample data to infer population traits. In this lesson, we will look at the different types of **T-Tests**, and how to run** T-Tests** in Excel. We’ll go over both paired and two sample **T-Tests**, with detailed instructions on how to prepare your data, run the test, and interpret the findings.

Understanding how to use the **T.TEST** function in Excel will improve your ability to draw significant insights and make data-driven decisions, whether you’re a student, researcher, business analyst, or anybody else who works with data. Let’s say, you’re doing education research to assess the efficacy between traditional and new approaches. **T-tests** will guide you through providing the mean scores of students based on the approaches that they were taught. So that, you can make a decision based on the students’ performance.

**Download Practice Workbook**

**Table of Contents**Expand

## T Test Type

There are basically two types of t-tests. They are:

- One-tailed t-test
- Two-tailed t-test

Each of them has 3 types. They are:

- Paired
- Two sample equal variance
- Two sample unequal variance

We will show you the application of some of these types. The procedure of getting the results for all types of t-tests in Excel are the same. Let’s dig into some details and see how it can be done.

## How to Do a T Test in Excel: 2 Effective Ways

**1. Using Excel T.TEST Or TTEST Function to Do T Test**

Here, we are going to show you how to determine the **T Test** result by using formulas. Excel has **T.TEST **and **TTEST **functions to operate t-test on different variables. Both functions work similarly. First, we will cover how to determine the t-test value of two sample variables with equal variance.

**1.1 Two Sample Equal Variance T Test**

In the dataset, you will see the prices of different laptops and smartphones. Here is a formula that performs a **T Test** on the prices of these products and returns the t-test result.

`=T.TEST(B5:B14,C5:C14,2,2)`

We set the 3rd argument of the function to **2 **as we are doing a two tailed t-test on the dataset. The 4th argument should be **2 **for a two sample equal variance t-test.

**1.2 Paired T Test**

Now, we are going to apply another formula to calculate the **Paired T-Test**. The following dataset shows the performance mark of some employees in two different criteria.

`=T.TEST(C5:C13,D5:D13,2,1)`

*Note: **The explanation of the results is described in the following sections.*

**2. Using Analysis Toolpak**

The above tasks can be done with the **Analysis Toolpak** **Add-in** too. The **Analysis Toolpak Add-in** is not available in the ribbon by default. To initiate it,

- Go to the
**Options**window first. - Next, select
**Add-ins**and click on the**Go**button beside the Manage section. - After that, click
**OK**.

- Thereafter, the
**Add-ins**window will appear. Select**Analysis Toolpak**>> click**OK**again.

This **Add-in** will be added to the ribbon of the **Data** tab.

**2.1 Two Sample Equal Variance T Test**

We will do a two sample equal variance t-test using the **Analysis Toolpak** here. We used the dataset that contains the prices of laptops and smartphones. For this purpose,

- Click on the
**Data Analysis**button from the ribbon of the**Data**tab. - The
**Data Analysis**features will appear. Select**t-Test: Two Sample Assuming Equal Variances**and click**OK**.

- After that, you need to set up the parameters for the
**t-test**operation. Insert the*Laptop*and*Smartphone*prices as**Variable 1 Range**and**Variable 2 Range**Include the headings in the range and check Labels. - Next, set the value of
**Hypothesized Mean Difference**to**0**. - Finally, select an Output option of your preference and click
**OK**.

As we have chosen a New Worksheet for the outputs, we will see the results in a new sheet.

Now, let’s get to the discussion on the results.

**Comments on Results**

The output shows that the mean values for ** Laptops **and

**are**

*Smartphones***1608.85**and

**1409.164**respectively. We can see from the Variances row that they are not precisely equal, but they are close enough to be assumed to have equal variances. The most relevant metric is the

**p-value**.

The difference between means is statistically significant if the** p-value** is less than your significance level. Excel calculates **p-values** for one- and **two-tailed T Tests**.

**One-tailed T Tests** can detect only one direction of difference between means. A one-tailed test, for example, might only evaluate whether * Smartphones *have higher prices than

**. Two-tailed tests can reveal differences that are larger or smaller than. There are some other disadvantages to utilizing one-tailed testing, so I’ll continue with the conventional two-tailed results.**

*Laptops*For our results, we’ll utilize **P(T=t)** two-tail, which is the **p-value** for the **t-test’s** two-tailed version. We cannot reject the null hypothesis because our **p-value** (**0.095639932**) is greater than the conventional significance level of **0.05**. The hypothesis that the population means differ is supported by our sample data. The mean price of ** Laptops **is greater than the mean price of

**.**

*Smartphones’*The** Analysis Toolpak** operation also returns results for **one-tailed t-test**. Here, **the one-tailed P** value of two sample equal variance** t-test** is **1.734**.

**2.2 Paired T Test**

Similarly, you can find out the **Paired t-Test** result for the dataset containing employee performances. Just select the **t-Test: Paired Two Samples** for **Mean** when you open the **Data Analysis** window.

**Comments on Results**

The result shows that the mean for the ** Workpace **is

**104**and the mean for the

**is**

*Efficiency***96.56**.

The difference between means is statistically significant if the p-value is less than your significance level. For our results, we’ll utilize **P(T=t)** two-tail, which is the **p-value** for the **t-test’s** two-tailed version. We cannot reject the null hypothesis because our **p-value** (**0.188**) is greater than the conventional significance level of **0.05**. The hypothesis that the population means differ is supported by our sample data. In particular, the ** Workpace **mean exceeds the

**mean.**

*Efficiency*## How to Interpret t-Test Results in Excel

Although we explained the results of the **t-Test** earlier, we didn’t show the proper interpretation. So here, I’ll show you the interpretation of the **two sample equal variance** t-test.

Let’s bring out the results again first.

**i. Mean:**

- The mean of laptop prices =
**1608.85** - The mean of smartphone prices =
**1409.164**

**ii. Variance**

- The variance of laptop prices =
**77622.597** - The variance of smartphone prices =
**51313.7904**

**iii. Observations**

The number of observations for both laptops and smartphones are **10**.

**iv. Pooled Variance**

The samples’ average variance, calculated by pooling the variances of each sample.

The mathematical formula for this parameter is:

((No of observations of Sample 1-1)*(Variance of Sample 1) + (No of observations of Sample 2-1)*(Variance of Sample 2))/(No of observations of Sample 1 + No of observations of Sample 2 – 2)

So it becomes: **((10-1)*77622.59676+(10-1)*51313.7904)/(10+10-2) = 64468.19358**

**v. Hypothesized Mean Difference**

We “hypothesize” that the number is the difference between the two population means. In this situation, we chose 0 because we want to see if the difference between the means of the two populations is zero.

**vi. df**

It indicates the value of the Degrees of Freedom. Formula for this parameter is:

No of observations of Sample 1 + No of observations of Sample 2 – 2 = **10 + 10 – 2 = 18**

**vii. t Stat**

The test statistic value of the t-Test operation.

The formula for this parameter is given below.

(Mean of Sample 1 – Mean of Sample 2)/(Square root of (Pooling Variance* (1/No of observations of Sample 1 + 1/No of observations of Sample 2)))

So it becomes: **(1608.85 – 1409.164)/Sqrt(64468.19358 * (1/10 + 1/10)) = 1.758570846**

**viii. P(T<=t) two-tail**

A two-tailed t-test’s p-value. This value can be found by entering** t = 1.758570846** with **18** degrees of freedom into any **T** Score to **P** Value Calculator.

In this situation, the value of **p** is **0.095639932**. Because this is greater than **0.05**, we cannot reject the null hypothesis. This suggests that we lack adequate evidence to conclude that the two population means differ.

**ix. t Critical two-tail**

This is the test’s crucial value. A t Critical value Calculator with **18** degrees of freedom and a **95%** confidence level can be used to calculate this number.

In this instance, the critical value is **2.10092204**. We cannot reject the null hypothesis because our test statistic t is less than this number. Again, we lack adequate information to conclude that the two population means are distinct.

## Things to Remember

- Excel demands that your data be arranged in columns, with data from each group in a separate column. The first row should have labels or headers.
- Clearly state your null hypothesis (usually that there is no significant difference between the group means) and your alternative hypothesis (the opposite of the null hypothesis).
- As a result of the t-test, Excel returns the p-value. A little p-value (usually less than the specified alpha level) indicates that the null hypothesis may be rejected and that there is a substantial difference between the group means.

## Frequently Asked Questions

**1. Can I perform a t-test on unequal sample sizes in Excel?**

Answer: Yes, you can use the **T.TEST** function to do a t-test on unequal sample sizes. When calculating the test statistic, Excel automatically accounts for unequal sample sizes.

**2. What is the difference between a one-tailed and a two-tailed t-test?**

Answer: A one-tailed t-test determines if the means of the two groups differ substantially in a given direction (e.g., greater or smaller). A two-tailed t-test looks for any significant difference, regardless of direction.

**3. Can I calculate effect size in Excel for t-tests?**

Answer: While there is no built-in tool in Excel to calculate effect size, you may manually compute Cohen’s d for independent t-tests and paired sample correlations for paired t-tests using Excel’s basic mathematical operations.

## Conclusion

In the end, we can conclude that you will learn some basic ideas on how to do a t Test in Excel. If you have any questions or feedback regarding this article, please share them in the comment section. Your valuable ideas will enrich my Excel expertise and hence the content of my upcoming articles.

**<< Go Back to Statistical Significance in Excel | Excel for Statistics | Learn Excel**