Menu
EXCEL T.DIST FUNCTION
Excel T.DIST Function Introduction
The T.DIST function in Excel computes the one-tailed Student’s Two – tailed test, which is a statistical tool commonly used for testing hypotheses on small sample data sets.
Description of Excel T.DIST Function
Syntax :
=T.DIST( x, degrees_freedom, cumulative )
Parameters :
- The following parameter are:
x
- – The value where the spread should be evaluated.
degrees freedom –
- The amount of degrees of freedom required (must be 1).
cumulative –
- A logical argument indicating the type of distribution to be used:
TRUE denotes Cumulative Distribution. Function
Probability Density Function = FALSE
Step By Step Guide of T.DIST Function
Example :
The right graphic depicts the one-tailed continuous Student’s T Distribution with ten degrees of freedom.
If you wish to compute the value of this function at x = 1, use the Excel T.Dist function.
Key Points
- #NUM! – Occurs if either the provided total is TRUE and degrees freedom is 1 or the provided total is FALSE and degrees freedom is 0.
- #NUM! – Occurs if either the provided total is TRUE and degrees freedom is 1 or the provided total is FALSE and degrees freedom is 0.
- #VALUE!- Occurs if the given cumulative is FALSE and degrees freedom is 0. – This error occurs if any of the given parameters are not numeric.
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
