Home : TINV
Q14713 - INFO: TINV

TINV spread function returns the two-tailed inverse of the Student's t-distribution. 

SYNTAX:

TINV(probability,degrees of freedom)

Probability: The associated probability for the two-tailed Student's t-distribution.  The following probabilities are supported:

Probability Cum. Prob Confidence Level
0.50 t.75 50%
0.40 t.80 60%
0.30 t.85 70%
0.20 t.90 80
0.10 t.95 90%
0.05 t.975 95%
0.02 t.99 98%
0.01 t.995 99%
0.002 t.999 99.8%
0.001 t.9995 99.9%

Degrees of freedom: The degrees of freedom with which to characterize the distribution.  A whole number between 1 and 100.  All numbers greater than 100 return the Z value. 

 

EXAMPLES:

 Calculate the Student's t-value when calculating a Lab MDL based on 7 samples.  Use the 0.02 Probability (98% confidence level) and 6 degrees of freedom(n-1).

=TINV(0.02,7-1) returns 3.14267

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 3/24/2022 1:01 PM.
Last Modified on 3/24/2022 3:55 PM.
Last Modified by Scott Dorner.
Article has been viewed 1181 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article