**Part 1: Introduction**

**Definition,** The T.DIST function in Microsoft Excel returns the Student’s left-tailed t-distribution.

**Purpose** The t-distribution is used in the hypothesis testing of small sample data sets. This function is used in place of a table of critical values for the t-distribution.

**Syntax & Arguments**

`T.DIST(x, deg_freedom, cumulative) `

The T.DIST function syntax has the following arguments:

**x**: Required. The numeric value at which to evaluate the distribution.**deg_freedom**: Required. An integer indicates the number of degrees of freedom.**cumulative**: Required. A 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.

**Return value** The T.DIST function returns the Student’s left-tailed t-distribution.

**Remarks**

- If any argument is non-numeric, T.DIST returns the #VALUE! Error value.
- If deg_freedom < 1, T.DIST returns an error value. Deg_freedom needs to be at least 1.

**Part 2: Examples**

**Example 1**

*Purpose of Example*: Calculate the Student’s left-tailed t-distribution for a given value using 1 degree of freedom.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Value | Degrees of Freedom | Cumulative | Formula | Result |

2 | 60 | 1 | TRUE | `=T.DIST(A2, B2, C2)` | 0.9947 |

*Result*: The result of the formula would be the Student’s left-tailed t-distribution for the given value, returned as the cumulative distribution function.

*Explanation*: In this example, we use the T.DIST function to calculate the Student’s left-tailed t-distribution for a value of 60, using 1 degree of freedom. The cumulative parameter is set to TRUE, so the function returns the cumulative distribution function.

**Example 2**

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Value | Degrees of Freedom | Cumulative | Formula | Result |

2 | 8 | 3 | FALSE | `=T.DIST(A2, B2, C2)` | 0.0007 |

*Result*: The result of the formula would be the Student’s left-tailed t-distribution for the given value, returned as the probability density function.

*Explanation*: In this example, we use the T.DIST function to calculate the Student’s left-tailed t-distribution for a value of 8, using 3 degrees of freedom. The cumulative parameter is set to FALSE, so the function returns the probability density function.

**Example 3**

*Purpose of Example*: To calculate the Student’s left-tailed t-distribution for a given value using 2 degrees of freedom.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Value | Degrees of Freedom | Cumulative | Formula | Result |

2 | 10 | 2 | TRUE | `=T.DIST(A2, B2, C2)` | 0.9933 |

*Result*: The result of the formula would be the Student’s left-tailed t-distribution for the given value, returned as the cumulative distribution function.

*Explanation*: In this example, we use the T.DIST function to calculate the Student’s left-tailed t-distribution for a value of 10, using 2 degrees of freedom. The cumulative parameter is set to TRUE, so the function returns the cumulative distribution function.

**Example 4**

*Purpose of Example*: To calculate the Student’s left-tailed t-distribution for a given value, using 4 degrees of freedom.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Value | Degrees of Freedom | Cumulative | Formula | Result |

2 | 5 | 4 | FALSE | `=T.DIST(A2, B2, C2)` | 0.0146 |

*Result*: The result of the formula would be the Student’s left-tailed t-distribution for the given value, returned as the probability density function.

*Explanation*: In this example, we use the T.DIST function to calculate the Student’s left-tailed t-distribution for a value of 5, using 4 degrees of freedom. The cumulative parameter is set to FALSE, so the function returns the probability density function.

**Example 5**

*Purpose of Example*: To calculate the Student’s left-tailed t-distribution for a given value using 5 degrees of freedom.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Value | Degrees of Freedom | Cumulative | Formula | Result |

2 | 7 | 5 | TRUE | `=T.DIST(A2, B2, C2)` | 0.9918 |

*Result*: The result of the formula would be the Student’s left-tailed t-distribution for the given value, returned as the cumulative distribution function.

*Explanation*: In this example, we use the T.DIST function to calculate the Student’s left-tailed t-distribution for a value of 7, using 5 degrees of freedom. The cumulative parameter is set to TRUE, so the function returns the cumulative distribution function.

**Part 3: Tips and Tricks**

- Always ensure that the degree of freedom is at least 1. If it’s less than 1, the T.DIST function will return an error.
- The T.DIST function can be used instead of a table of critical values for the t-distribution.
- The cumulative parameter determines the form of the function. If it’s TRUE, T.DIST returns the cumulative distribution function; if it’s FALSE, it returns the probability density function.
- If any argument is non-numeric, T.DIST returns the #VALUE! Error value. Always ensure that your arguments are numeric.
- The T.DIST function is helpful in the hypothesis testing of small sample data sets.