Menu
EXCEL TDIST FUNCTION
Excel TDIST Function Introduction
The TDIST function in Excel computes the Student’s T Distribution, which is a continuous probability distribution commonly used for testing hypotheses on small sample data sets.
Description of Excel TDIST Function
Syntax :
=TDIST( x, degrees_freedom, tails )
Parameters :
- The following parameter are:
x –
- The value at which the Student’s T Distribution should be evaluated.
degrees freedom –
- The amount of degrees of freedom required (must be 1).
tails –
- The distribution’s number of tails. This must be either:
1 – Provides the one-tailed distribution.
2 – Provides the two-tailed distribution.
Step By Step Guide of TDIST Function
Example :
The right graphic depicts the 1-tailed Student’s T Distribution with 10 degrees of freedom.
If you wish to determine the value of this function at x = 1, use the Excel Tdist function, as shown below:
Key Points
- #NUM!-Occurs if one of the following conditions is met: the provided value of x is 0; the supplied degrees freedom argument is 1; or the supplied tails argument is not equal to 1 or 2.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
