Navigation:  Formula Reference > Spreadsheet Formula Functions >

T.INV.2T

Previous pageReturn to chapter overviewNext page

 

This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom.

Syntax

T.INV.2T(prog,deg)

Arguments

This function has these arguments:

Argument

Description

prog

Probability of the two-tailed student’s t-distribution

deg

Number of degrees of freedom to characterize the distribution; if not an integer, the number is truncated

Remarks

The #VALUE! error value is returned if any argument is nonnumeric.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

T.INV.2T(A4,2)

T.INV.2T(0.68,4) gives the result 0.44400612800394834