Skip to main content Skip to complementary content

TDIST - script and chart function

TDIST() returns the probability for the Student's t-distribution where a numeric value is a calculated value of t for which the probability is to be computed.

Syntax:  

TDIST(value, degrees_freedom, tails)

Return data type: number

Arguments:  

Argument Description
value The value at which you want to evaluate the distribution and must not be negative.
degrees_freedom A positive integer stating the number of degrees of freedom.
tails Must be either 1 (one-tailed distribution) or 2 (two-tailed distribution).

This function is related to the TINV function in the following way:
If prob = TDIST(value, df ,2), then TINV(prob, df) = value

Limitations:  

All arguments must be numeric, else NULL will be returned.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!