T.DIST function

The T.DIST function returns the right tailed Student distribution for a value x. Along with T.DIST.2T, this function replaces TDIST and is equivalent to calling TDIST with the tails argument set to 1.

Parts of a T.DIST function

T.DIST(x, degrees_freedom, cumulative)

Part Description
x Required. The x value to evaluate the distribution at.
degrees_freedom Required. The degrees of freedom.
cumulative Required. True/false value field. If true, returns the cumulative probability for x. If false, returns the probability density function for x.

Sample formulas

  • Example 1: A1 has T.DIST(1.96, 60, false)
  • Example 2: A1 has T.DIST(-1.98, 2, false)
  • Example 3: A1 has T.DIST(1.96, 60, true)
  • Example 4: A1 has T.DIST(-1.98, 2, true)

Notes

If deg_freedom is less than 1, returns as #NUM error. 

Examples

Result for A1=T.DIST(1.96, 60, false)

  A B
1 0.059847906211419  
2    

Result for A1=T.DIST(-1.98, 2, false)

  A B
1 0.06941821226899947  
2    

Result for A1=T.DIST(1.96, 60, true)

  A B
1 0.972677535131736  
2    

Result for A1=T.DIST(-1.98, 2, true)

  A B
1 0.09312625192178947  
2    

Related functions

  • TDIST: Calculates the probability for Student's t-distribution with a given input (x).
  • T.DIST.2T: The T.DIST.2T function returns the two tailed Student distribution for a value x.
  • T.DIST.RT: Returns the right tailed Student distribution for a value x.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu