Part 1: Introduction
Definition, The T.INV function in Microsoft Excel returns the left-tailed inverse of the Student’s t-distribution.
Purpose The function is used to find the t-value given a certain probability and degrees of freedom. This is particularly useful in hypothesis testing and confidence interval construction.
Syntax & Arguments
T.INV(probability, deg_freedom)
The T.INV function syntax has the following arguments:
- probability: Required. The chance associated with the Student’s t-distribution.
- deg_freedom: Required. The number of degrees of freedom with which to characterize the distribution.
Return value The T.INV function returns the left-tailed inverse of the Student’s t-distribution.
Remarks
- If either argument is non-numeric, T.INV returns the #VALUE! Error value.
- If probability <= 0 or if probability > 1, T.INV returns the #NUM! Error value.
- If deg_freedom is not an integer, it is truncated.
- If deg_freedom < 1, T.INV returns the #NUM! Error value.
Part 2: Examples
Example 1
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a given probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.75 | 2 | =T.INV(A2, B2) | 0.8165 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.75 and 2 degrees of freedom.
Example 2
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.80 | 3 | =T.INV(A2, B2) | 0.9785 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.80 and 3 degrees of freedom.
Example 3
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.85 | 4 | =T.INV(A2, B2) | 1.0639 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.85 and 4 degrees of freedom.
Example 4
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.90 | 5 | =T.INV(A2, B2) | 1.4759 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.90 and 5 degrees of freedom.
Example 5
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.95 | 6 | =T.INV(A2, B2) | 1.9432 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.95 and 6 degrees of freedom.
Example 6
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.99 | 7 | =T.INV(A2, B2) | 2.9979 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.99 and 7 degrees of freedom.
Example 7
Purpose of Example: To calculate the left-tailed inverse of the Student’s t-distribution for a different probability and degrees of freedom.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees of Freedom | Formula | Result |
2 | 0.995 | 8 | =T.INV(A2, B2) | 3.4995 |
Explanation: In this example, we use the T.INV function to calculate the left-tailed inverse of the Student’s t-distribution for a probability of 0.995 and 8 degrees of freedom.
Part 3: Tips and Tricks
- Always ensure that the degree of freedom is at least 1. If it’s less than 1, the T.INV function will return an error.
- The T.INV function can be used instead of a table of critical values for the t-distribution.
- If probability <= 0 or if probability > 1, T.INV returns the #NUM! Error value.
- If any argument is non-numeric, T.INV returns the #VALUE! Error value. Always ensure that your arguments are numeric.
- The T.INV function is helpful in hypothesis testing small sample data sets and constructing confidence intervals.