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.
TDIST(value, degrees_freedom, tails)
Return data type: number
|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
All arguments must be numeric, else NULL will be returned.
Examples and results:
|TDIST(1, 30, 2)||Returns 0.3253|