T.DIST function

Returns the Student's t-distribution. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.


T.DIST(x,deg_freedom, cumulative)

The T.DIST function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

  • X     Required. The numeric value at which to evaluate the distribution
  • Deg_freedom     Required. An integer indicating 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.


  • If any argument is nonnumeric, 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.
Applies to:
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses