TINV - script and chart function

TINV() returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.

Syntax:  

TINV(prob, degrees_freedom)

Return data type: number

Arguments:  

Argument Description
prob A two-tailed probability associated with the t-distribution. It must be a number between 0 and 1.
degrees_freedom An integer stating the number of degrees of freedom.

Limitations:  

All arguments must be numeric, else NULL will be returned.

This function is related to the TDIST function in the following way:
If prob = TDIST(value, df ,2), then TINV(prob, df) = value.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?