This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2T(prog,deg)
This function has these arguments:
| Argument | Description |
|---|---|
| prog | Probability of the two-tailed student’s t-distribution |
| deg | Number of degrees of freedom to characterize the distribution; if not an integer, the number is truncated |
The #VALUE! error value is returned if any argument is nonnumeric.
Accepts numeric data for all arguments. Returns numeric data.
T.INV.2T(A4,2)
T.INV.2T(0.68,4) gives the result 0.44400612800394834
This function is available in Spread for Windows Forms 11.0 or later.