How To Use Excel T TEST Function in Excel office 365?
Tags: touseexcelttestfunct, excel, excelfunctions
Published: 2021-08-27 07:24:19

---
title: How To Use Excel T TEST Function in Excel office 365?
published: true
date: 2021-08-25 18:43:22 UTC
tags: ToUseExcelTTESTFunct,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-t-test-function-in-excel-office-365/
---

In this article, you will learn how to use **Excel T TEST Function in Excel 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## T TEST Function

The T TEST or Student’s test is used to determine the confidence of an analysis. In mathematical terms, it is used to know if the mean of the two samples is equal. T.TEST is used to accept or reject the null hypothesis.

## T TEST Function Syntax

```
=T.TEST(group1, group2, tails, type)
```

**Syntax Explanation:**

- **group1:** the first group of experiments.
- **group2:** the second group of experiments. It can have the same subject as of group1, different subjects with the same variance and different subjects with different variance.
- **tails:** it has two options, 1 tailed, and 2 tailed. 1 tailed T TEST is used when we know that the effect of the experiment is one-directional. 2 tailed T TEST, it is used when we don’t know the direction of the effect of the experiment
- **type:** There are three options available (1,2,3).
  - 1 (Paired): we use it when group1 and group2 have same subjects.
  - 2 (Two sample equal variance): When the subjects of these groups are different, but variance is same.
  - 3 (two sample unequal variances): When subjects of two groups are different and variance is also different.

## Example

- Firstly, you need to **create a sample data** with **Group 1 studied while chewing gum** and  **group 2 studied normally**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-33.png)<figcaption>Sample data</figcaption>

- Then, you have to **collect the data** and calculated the **mean** in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/08/Mean-value.png)<figcaption>Mean value</figcaption>

- Now, you need to calculate the **T TEST function** in the Excel.
- **Null Hypothesis (H0):** There is no difference in score due to studying while chewing gum.
- After that, you have to calculate the **1 tailed T-TEST**  **function** with the paired group.

```
=T.TEST(B3:B10,C3:C10,1,1)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/one-tailed-2-1024x457.png)<figcaption>One-tailed</figcaption>

- Finally, you need to calculate the **2 tailed T TEST function**.

```
=T.TEST(B3:B10,C3:C10,2,1)

```

![](https://geekexcel.com/wp-content/uploads/2021/08/two-tailed-3-1024x452.png)<figcaption>two-tailed</figcaption>

## Sum-Up

In the above short tutorial, we have illustrated **how to use the Excel T TEST Function In Excel Office 365**. Hope you like this article. Please feel free to state your **query** or **feedback** for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[How to Use Excel T Function in Office 365? [With Examples]](https://geekexcel.com/how-to-use-t-function-in-microsoft-excel-365-with-examples/)**
- **[Excel Formulas to Calculate a Percent Variance ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-a-percent-variance/)**
- **[Formulas to Test If the Cell Contains Numbers ~ Quick Solution!!](https://geekexcel.com/excel-formulas-to-test-if-the-cell-contains-numbers/)**
- **[Excel Formulas to Test the Cells that Contains Specific Text!!](https://geekexcel.com/excel-formulas-to-test-the-cell-that-contains-specific-text/)**
- **[Excel Formulas to Test All Cells in Range are Blank ~ Easy Guide!!](https://geekexcel.com/excel-formulas-test-all-cells-in-a-range-are-blank/)**