Take the 2-minute tour ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.

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()?

share|improve this question
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 :-). –  whuber Jun 7 '12 at 18:36

2 Answers 2

up vote 15 down vote accepted

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.

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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