Tell me more ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.
up vote 7 down vote favorite

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
5  
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

up vote 13 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
up vote 9 down vote

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

share|improve this answer

Your Answer

 
discard

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.