Definition of T.INV:
This formula calculates the negative inverse of the one-tailed TDIST function.
Syntax for T.INV:
- T.INV(probability, degrees_freedom)
probability- The probability associated with the t-distribution.
Must be greater than
0and less than
degrees_freedom- The number of degrees of freedom.
Truncated to an integer in the calculation if a non-integer is provided as an argument.
Must be greater than or equal to
- Both arguments to
T.INVmust be numeric or a destination cell whose value is numeric.
TDIST: Calculates the probability for Student's t-distribution with a given input (x).
Step 1. To use the T.INV Formula, start with the Excellentable you would like to edit.
Step 2. Then type the T.INV formula into the cell you have chosen to display the outcome:
Step 3. Fill in the 2 values- In this example I have chosen 2 values that are the same.
Step 4. Once saved, your completed formula will display in a confluence page like this.