T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel

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

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 1

Description: The function returns the two-sided inverse of the Student's t-distribution. Support functions from Excel 2010 onwards.

Syntax: T.INV (probability, deg_freedom)

Inside:

- probability: Probability associated with t value of Student's t-distribution , which 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 probability ≤ 0 or probability> 1 -> the function returns the #NUM! 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 deg_freedom is not an integer -> it is truncated to an integer.

- T.INV.2T returns the value of t , such that P (| X |> t) = probability with X being a random variable depending on the distribution and P (| X |> t) = P (X < -t or X> t).

For example:

Calculate the two-tailed inverse value of the Student 's t-distribution of values ​​in the following data table:

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 2

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

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 3

- Press Enter -> the two-tailed inverse value of the Student 's t-distribution is:

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 4

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

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 5

- Where the probability of combining with the t value is greater than 1 -> the function returns the #NUM! Error value

T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel Picture 6

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

Good luck!