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 information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?