T.INV.2T
The positive t value whose two tails together hold a given probability: the critical value of a two-sided t test.
Group: Statistics. Compatible with DAX.
Syntax
T.INV.2T ( <Probability>, <Deg_freedom> )| Parameter | Type | Description |
|---|---|---|
Probability | Number | The probability of both tails together, above 0: 0.05 for a 95 % interval. |
Deg_freedom | Whole number | The degrees of freedom, 1 or more; rounded to a whole number. |
Returns
Number. The t whose two tails, beyond −t and beyond t, together hold the probability.
Remarks
T.INV.2T ( p, df )isT.INV ( 1 − p / 2, df ): the critical value of a two-sided test at level p.- A probability of 0 or less, or of 2 or more, is an error.
Examples
The critical t at 5 %
EVALUATE
ROW ( "Two-sided 5 %", T.INV.2T ( 0.05, 10 ), "Same as", T.INV ( 0.975, 10 ) )| Two-sided 5 % | Same as |
|---|---|
| 2.22813885198627 | 2.22813885198627 |