T. DIST.2T - the Function Returns the Two-tailed Student Distribution in

This guide provides a practical overview of T. DIST.2T - the Function Returns the Two-tailed Student Distribution in, including its main features, benefits, limitations, and important considerations.

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

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

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.

Attention:

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

- If deg_freedom <1 -> the function returns the #NUM! Error value

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

- If x <0 -> the function returns the #NUM! Error value

For example:

Calculate the Student 2 t- tailed distribution as described in the following data table:

- In the cell to calculate, enter the formula : = T. DIST.2T (D6, D7)

- Press Enter -> 2 t Student distribution is:

- If the number of degrees of freedom is less than 1 -> the function returns the #NUM! Error value

- Where the value for distribution distribution is less than 0 -> the function returns the #NUM! Error value

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

Good luck!