How to use the TDIST function, T.DIST function, T.DIST.RT function & T.DIST.2T function in Excel?
Tags: tousethetdistfunctio, excel, excelfunctions
Published: 2021-08-25 02:35:31

---
title: How to use the TDIST function, T.DIST function, T.DIST.RT function & T.DIST.2T function in Excel?
published: true
date: 2021-08-20 13:49:44 UTC
tags: ToUseTheTDISTFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-tdist-function-t-dist-function-t-dist-rt-function-t-dist-2t-function-in-excel/
---

Have you ever tried to use these different functions In your Excel Spreadsheet? In this tutorial, we will guide you on **how to use the TDIST Function, T.DIST Function, T.DIST.RT Function & T.DIST.2T Function In Excel Office 365**. Let’s get them below!! Get an 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)**

## TDIST Function

The **T.DIST function** in Excel returns the **t distribution probability percentage** of something across samples, The function takes **variable x and degrees of freedom** for the distribution along with the type of tailed test.

## TDIST Function syntax

```
=TDIST(x , deg_freedom ,tails)
```

**Syntax Explanation:**

- **x** : **value** at which distribution is evaluated.
- **deg\_freedom** : degrees of freedom.
- **Tails** : **one tailed** (use 1) or **two tailed** (use 2) test.

## TDIST Function Example

- Firstly, you have to **create the sample data** with **variable x and degree of freedom**.

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

- Then, you need to calculate the **[probability](https://geekexcel.com/excel-formulas-to-generate-random-number-weighted-probability/)percentage for the t distribution one-tailed test**.
- Now, you have to use the following **TDIST function**  **formula** in Excel.

```
=TDIST(B2 , B3 , 1)
```

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

- After that, you have to convert the **decimal value to percentage** by changing the **format of the cell to [percentage](https://geekexcel.com/excel-formulas-to-calculate-the-percentage-complete-for-project/)**.

![](https://geekexcel.com/wp-content/uploads/2021/08/convert-percentage-1024x249.png)<figcaption>Convert to percentage</figcaption>

- Now, you need to use the **same formula** with the same parameters for the **two tailed tests**.

```
 =TDIST(B2 , B3 , 2) 
```

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

## T.DIST.RT Function

**T.DIST.RT Function** returns the **right-tailed distribution for the one-tailed test** using the **variable x and deg of freedom**.

## T.DIST.RT Function syntax

```
=T.DIST.RT(x , deg_freedom)
```

**Syntax Explanation:**

- **x** : value at which distribution is evaluated.
- **deg\_freedom** : degrees of freedom.

## T.DIST.RT Function Example

- Here, you have to use the **same data** which is created in before example.

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

- Then, you need to evaluate the **right tailed test for the same parameters**.
- Now, you have to use the **T.DIST.RT function** formula given below.

```
=T.DIST.RT ( B2 , B3 )
```

![](https://geekexcel.com/wp-content/uploads/2021/08/right-tailed-1024x289.png)<figcaption>Right-tailed</figcaption>

**Check this too** : [How to use the PROB function in Excel Spreadsheets?](https://geekexcel.com/how-to-use-the-prob-function-in-excel-spreadsheets/)

## T.DIST.2T Function

**T.DIST.2T Function** returns the **two-tailed test for the distribution** using the **variable x and deg of freedom**.

## T.DIST.2T Function Syntax

```
=T.DIST.2T(x , deg_freedom)
```

- x : value at which distribution is evaluated.
- deg\_freedom : degrees of freedom.

## T.DIST.2T Function Example

- Here, you have to use the **same data** which is created in before example.

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

- Then, you need to evaluate the **two-tailed test for the same parameters**.
- Now, you have to use the **T.DIST.2T function** formula given below.

```
=T.DIST.2T ( B2 , B3 )
```

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

## T.DIST Function

**T.DIST Function** returns the student **t distribution for the left tailed test** using the **variable x and deg of freedom** along with the **type of distribution** (cdf or pdf).

## T.DIST Function syntax

```
=T.DIST(x , deg_freedom ,tails)
```

**Syntax Explanation:**

- **x** : **value** at which distribution is evaluated.
- **deg\_freedom** : degrees of freedom.
- **cumulative** : **logical value** that determines the form of the function. If **cumulative is TRUE** , **T.DIST** returns the **cumulative distribution function** ; if **FALSE** , it returns the **probability density function**.

## T.DIST Function Example

- Here, you have to use the **same data** which is created in before example.

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

- Now, you have to calculate the **left-tailed and cumulative distribution**.
- For that, you need to use the following **T.DIST function cdf formula** given below.

```
=T.DIST ( B2 , B3, TRUE )
```

![](https://geekexcel.com/wp-content/uploads/2021/08/left-tailed-cdf-1024x296.png)<figcaption>Left-tailed &amp; cdf</figcaption>

- After that, you have to calculate the **right-tailed and probability mass distribution**.
- You need to use the following **T.DIST function PDF formula** given below.

```
=T.DIST ( B2 , B3, FALSE )
```

![](https://geekexcel.com/wp-content/uploads/2021/08/right-tailed-pdf-1024x309.png)<figcaption>Right-tailed &amp; pdf</figcaption>

**Check this too** : [How to use the T.INV function in Excel office 365? – Easy Tricks!!](https://geekexcel.com/how-to-use-the-t-inv-function-in-excel-office-365-easy-tricks/)

**NOTE:**

- This Function only works with **numbers**.
- If any **argument** other than **cumulative is non-numeric** , the function **returns #VALUE! error**.
- The **function returns #NUM! Error**.
  - If x is negative
  - If the degree of freedom is < 1 or >10^10.
- Now, the **cumulative argument** can be used with **boolean numbers** (0 and 1) or (FALSE or TRUE).
- The **value in decimal** and **value in percentage** id is the same value in Excel and **convert the value to percentage** , if required.
- Finally, you can **feed the arguments** to the **function** directly or using the **cell reference,** as explained in the example.

## Verdict

We hope that this tutorial gives you guidelines on **how to use the TDIST Function, T.DIST Function, T.DIST.RT Function & T.DIST.2T Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Excel Formulas to Check If the Cell Value is (X and Y)!!](https://geekexcel.com/excel-formulas-to-check-if-the-cell-value-is-x-and-y/)**
- **[Formulas to Test if the Cell Contains all of Many Things ~ Easy Tips!!](https://geekexcel.com/excel-formulas-cell-contain-all-of-many-things/)**
- **[Excel Formulas to Test If the Cell Contains Numbers ~ Quick Solution!!](https://geekexcel.com/excel-formulas-to-test-if-the-cell-contains-numbers/)**
- **[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/)**