How to Use the TINV Function in Excel
Today, we’ll delve into an important statistical function used in both Excel and Google Sheets – the TINV function. This function is utilized to calculate the inverse of the Student’s T-distribution, essentially helping us determine the value at which a specified cumulative distribution function is met.
Syntax:
The syntax for the TINV function is as follows:
=TINV(probability, deg_freedom)probability: This represents the probability corresponding to the two-tailed T-distribution.deg_freedom: This denotes the number of degrees of freedom in the distribution.
Examples:
To better understand the application of the TINV function, let’s look at a couple of examples in both Excel and Google Sheets.
Example 1:
Let’s calculate the inverse T value for a probability of 0.05 with 10 degrees of freedom.
| Excel Formula | Result |
|---|---|
=TINV(0.05, 10) |
2.228139 |
The calculated inverse T value, with a probability of 0.05 and 10 degrees of freedom, is approximately 2.228139.
Example 2:
Determine the inverse T value for a cumulative probability of 0.025 with 20 degrees of freedom.
| Google Sheets Formula | Result |
|---|---|
=TINV(0.025, 20) |
2.845339 |
With a cumulative probability of 0.025 and 20 degrees of freedom, the inverse T value is approximately 2.845339.
These examples illustrate how the TINV function can be effectively used to compute the inverse T values for specific probabilities and degrees of freedom in both Excel and Google Sheets.
More information: https://support.microsoft.com/en-us/office/tinv-function-a7c85b9d-90f5-41fe-9ca5-1cd2f3e1ed7c