T.DIST - The function returns the Student t-distribution on the left in Excel

T.DIST: The function returns the Student's t-distribution on the left. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010 onwards. Syntax: T.DIST (x, deg_freedom, cumulative)

The following article introduces you to the T.DIST function - one of the functions in the statistical function group is very popular in Excel.

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 1T.DIST - The function returns the Student t-distribution on the left in Excel Picture 1

Description: The function returns the Student's t-distribution on the left. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010 onwards.

Syntax: T.DIST (x, deg_freedom, cumulative)

Inside:

- x: Value used to evaluate the distribution, is a required parameter.

- deg_freedom: Number of degrees of freedom of the distribution, is a required parameter.

- cumulative: A logical value that determines the form of the function, which is a required parameter, including:

+ cumulative = True -> returns the cumulative distribution function.

+ cumulative = False -> returns the probability density function.

Attention:

- Any argument that is not a number -> the function returns the #VALUE! Error value

- If deg_freedom <1 -> the function returns an error value.

- The minimum value of deg_freedom must be equal to 1.

For example:

Calculate the Student's t-distribution on the left as described in the following data table:

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 2T.DIST - The function returns the Student t-distribution on the left in Excel Picture 2

- Calculates the Student's t-distribution on the left is returned with the cumulative distribution function. In a cell to calculate, enter the formula : = T.DIST (D6, D7, D8)

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 3T.DIST - The function returns the Student t-distribution on the left in Excel Picture 3

- Press Enter -> Student's left t-distribution is returned with the cumulative distribution function is:

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 4T.DIST - The function returns the Student t-distribution on the left in Excel Picture 4

- Calculate the Student's t-distribution on the left is returned with probability density function. In a cell to calculate, enter the formula : = T.DIST (D6, D7, D9)

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 5T.DIST - The function returns the Student t-distribution on the left in Excel Picture 5

- Press Enter -> Student's left t-distribution is returned with the probability density function is:

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 6T.DIST - The function returns the Student t-distribution on the left in Excel Picture 6

- If the number of degrees of freedom is less than 1 -> the function returns the error value:

T.DIST - The function returns the Student t-distribution on the left in Excel Picture 7T.DIST - The function returns the Student t-distribution on the left in Excel Picture 7

Above are instructions and some specific examples when using T.DIST function in Excel.

Good luck!

5 ★ | 2 Vote