T_INV_2T

Updated 2023-11-05 12:25:45.263000

Syntax

SELECT [westclintech].[wct].[T_INV_2T](
  <@Probability, float,>
 ,<@Degrees_freedom, float,>)

Description

Use the scalar function T_INV_2T to calculate the inverse of the two-tailed distribution of Student's t-distribution.

Arguments

@Probability

the probability to be evaluated. @Probability must be of a type float or of type that intrinsically converts to float.

@df

the number of degrees of freedom. @df must of a type float or of a type that intrinsically converts to float.

Return Type

float

Remarks

0 < @df.

0 < @Probability <= 1.

If @Probability = 1 then zero is returned.

Examples

In this example we calculate the value at 0.95 with 12 degrees of freedom.

SELECT wct.T_INV_2T(   0.95, --@Probability

                       12    --@Degrees_freedom

                   ) as T_INV_2T;

This produces the following result.

{"columns":[{"field":"T_INV_2T","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"T_INV_2T":"0.0640307698992605"}]}