8
$\begingroup$

TINV() returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. For example TINV(0.475,42) = 0.720842172. (source)

What is the Mathematica equivalent for the Excel function tinv()?

$\endgroup$
  • 5
    $\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$ – whuber Jun 7 '12 at 18:36
16
$\begingroup$

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.

$\endgroup$
10
$\begingroup$

Quantile[StudentTDistribution[42], 1 - 0.475/2] also works.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.