LOGISTICINV

Updated 2024-03-08 21:27:54.197000

Syntax

SELECT [westclintech].[wct].[LOGISTICINV] (
  <@P, float,>
 ,<@A, float,>
 ,<@B, float,>)

Description

Use the scalar function LOGISTICINV to calculate the inverse lower cumulative distribution of the logistic distribution.

The formula for the lower cumulative distribution function is:

F(x;\mu,s)=\frac{1}{2}+\frac{1}{2}\text{ tanh}\left(\frac{x-\mu}{2s}\right)

Arguments

@A

is the location parameter. @A is an expression of type float or of a type that implicitly converts to float.

@P

is the value of the lower cumulative distribution function. @P is an expression of type float or of a type that implicitly converts to float.

@B

is the scale parameter. @B is an expression of type float or of a type that implicitly converts to float.

Return Type

float

Remarks

@B must be greater than zero (B > 0).

@P must be greater than zero and less than one (0 < @P < 1).

Examples

Calculate the inverse of the lower cumulative distribution function:

SELECT wct.LOGISTICINV(0.731058578630005, 0, 1);

This produces the following result.

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