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.


TINV(prob, degrees_freedom)

Return data type: number


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.


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?

