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.
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)