TINV()returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. For exampleTINV(0.475,42) = 0.720842172. (source)
What is the Mathematica equivalent for the Excel function tinv()?
$\begingroup$
$\endgroup$
1
-
6$\begingroup$ Technically, there is no exact Mathematica equivalent (at least for TINV in older versions of Excel--it may have been improved in the latest version): TINV is flawed and produces ever more erroneous results as the first argument approaches 0 or 1 :-). $\endgroup$– whuberCommented Jun 7, 2012 at 18:36
Add a comment
|
2 Answers
$\begingroup$
$\endgroup$
Either of InverseCDF[StudentTDistribution[42], 1 - 0.475/2] or InverseSurvivalFunction[StudentTDistribution[42], 0.475/2] should do the trick, taking into account that you're using the form for two-tailed tests.
answered Jun 7, 2012 at 16:33
J. M.'s missing motivation♦J. M.'s missing motivation
125k11 gold badges407 silver badges581 bronze badges
$\begingroup$
$\endgroup$
Quantile[StudentTDistribution[42], 1 - 0.475/2] also works.
