Formulas > =T.DIST()

How To Use T.DIST() Function in Google Sheets


Returns the right tailed Student distribution for a value x.

Common Questions about the T.DIST Formula:
What is the T.DIST Formula? How do I use the T.DIST Formula? What are the different parameters of the T.DIST Function?

How can the T.DIST Formula be Used Appropriately?
The T.DIST formula can be used appropriately to calculate the probability density of a Student’s t-distribution. It is often used in statistical analysis applications such as hypothesis testing.

How Can the T.DIST Formula be Commonly Mistyped?
The most commonly mistyped version of the T.DIST formula is T.DISTRIBUTION.

What are Some Common Ways the T.DIST Formula is Used Inappropriately?
The T.DIST formula is commonly used inappropriately when the wrong parameters are filled. Before using the T.DIST formula, make sure to do a careful review of the parameters to avoid making any mistakes.

What are Some Common Pitfalls When Using the T.DIST Formula?
The T.DIST formula does not take into account extreme outliers and does not result in an accurate probability. Additionally, the T.DIST formula can produce incorrect results if the data used is not representative of the population.

What are Common Mistakes when Using the T.DIST Formula?
Common mistakes when using the T.DIST formula include using the wrong parameters, using a biased dataset, and using incorrect degrees of freedom.

What are Common Misconceptions People Might Have with the T.DIST Formula?
A common misconception people tend to have with the T.DIST formula is that it will produce a precise probability. The T.DIST formula does not generate an exact probability as it does not take into account any outliers in the data. Additionally, the T.DIST formula assumes the distribution of the data is normal, which may not always be the case.

How To Actually Use T.DIST() in Sheets

T.DIST(x, degrees_freedom, cumulative)

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 T.DIST() formula:

Generate a T.DIST() 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. Free to try for non-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.