Formulas > =TDIST()

How To Use TDIST() Function in Google Sheets


Calculates the probability for Student's t-distribution with a given input (x).

Common Questions About the TDIST Formula:
1. What is the TDIST formula?
2. What is the purpose of the TDIST formula?
3. How does one use the TDIST formula?

How Can the TDIST Formula be Used Appropriately?
1. The TDIST formula is used to calculate the probability of a student or person in a series of students or persons with a particular t-score or value.
2. It can be used to calculate the range of scores for which the occurrence of an individual score is statistically significant.

How Can the TDIST Formula be Commonly Mistyped?
1. The formula is often written as “T-DIS” or “TDIST.”
2. The parameters are sometimes confused: the two that are most often mistaken are degrees of freedom (df) and the percentile (p).

What are some Common Ways the TDIST Formula is Used Inappropriately?
1. People may enter parameters that are outside the range of valid values.
2. People may also enter wrong values for the percentiles of the t-distribution.

What are some Common Pitfalls When Using the TDIST Formula?
1. Being familiar with the normal distribution is important; if the normal distribution parameters are used for the t-distribution, the results may be incorrect.
2. Make sure the parameters are within the valid range for the t-distribution.

What are Common Mistakes When Using the TDIST Formula?
1. People may miscalculate the degrees of freedom (df) or the percentile parameter.
2. People may also enter parameters that are out of the valid range for the t-distribution.

What are Common Misconceptions People Might Have with the TDIST Formula?
1. People may think that the t-distribution is equivalent to the normal distribution, which is not true.
2. People may also think that t-distribution is only applicable to one-tailed normal distributions, which is not the case.

How To Actually Use TDIST() in Sheets

TDIST(x, degrees_freedom, tails)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the TDIST() formula:

Generate a TDIST() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.