T.DIST

Returns the right tailed Student distribution for a value x. Learn more.

Video field
Statistical

In Google Sheets, the function T.DIST(x, degrees_freedom, cumulative) is used to calculate the probability of the Student's t-distribution.

It returns the probability that a value in a Student's t-distribution is less than or equal to x.

The parameters of the T.DIST function are as follows:

x: This is the value at which you want to evaluate the distribution.

degrees_freedom: This represents the degrees of freedom of the distribution. It is the number of observations minus one.

cumulative: This is a logical value that determines the form of the function. If cumulative is set to TRUE, T.DIST returns the cumulative probability.

If cumulative is set to FALSE, T.DIST returns the probability density function (PDF) at the given value of x.

Here's an example of how to use the T.DIST function in Google Sheets:

=T.DIST(2, 10, TRUE)

In this example, we are calculating the cumulative probability of the value 2 in a Student's t-distribution with 10 degrees of freedom.

Note that in more recent versions of Google Sheets, the T.DIST function has been replaced by the T.DIST.2T function, which calculates the two-tailed probability of the Student's t-distribution.

However, T.DIST is still available for backward compatibility.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!