T Dist 2t Function. The Students t-distribution is used in the hypothesis testing of small sample data sets. Remarks This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security RLS rules.
However this function along with the new TDISTRT function replaces the TDIST function which is available in earlier versions of Excel. For example to calculate the two-tailed probability density of the t-value 2093025 given 19 degrees of freedom you use the following formula. The Students t-distribution is used in the hypothesis testing of small sample data sets.
The Excel TDIST2T function calculates the two-tailed Students T Distribution which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.
TDIST2Txdeg_freedom The TDIST2T function syntax has the following arguments. Related Support Forum Posts. The Excel TDIST2T function calculates the two-tailed Students T Distribution which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. Returns the two-tailed Students t-distribution.