Excel Function : T.DIST.2T

Download now!

Excel Function : T.DIST.2T

Category

Statistical

Description

Returns the Percentage Points (probability) for the Student t-distribution

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TDIST2T-function-198e9340-e360-4230-bd21-f52f22ff5c28

Syntax and Description of the T.DIST.2T Excel Function

The syntax for the T.DIST.2T function in Microsoft Excel is: T.DIST.2T( x, degrees_freedom, cumulative ) Where the function arguments are as follows: x - The t-statistic whose p-value is to be calculated. degrees_freedom - The number of degrees of freedom. cumulative - A logical value that determines the form of the function. If cumulative is TRUE, T.DIST.2T returns the cumulative distribution function; if FALSE, it returns the probability density function. Additional details regarding the T.DIST.2T function can be found in the Microsoft Office documentation.

About T.DIST.2T Excel Function

The T.DIST.2T function in Excel returns the two-tailed Student's t-distribution. The t-distribution is a continuous probability distribution that is used to estimate population parameters when the sample size is small and/or when the population variance is unknown.