PSIGNRANK

Updated 2023-11-06 16:41:23.307000

Syntax

SELECT [westclintech].[wct].[PSIGNRANK](
  <@X, float,>
 ,<@N, float,>
 ,<@Exact, bit,>)

Description

Use the scalar function PSIGNRANK to calculate the distribution function of the Wilcoxon Signed Rank statistic.

Arguments

@N

the number of observations in the sample. @Y is an expression of type float or of a type that can be implicitly converted to float.

@X

the Wilcoxon signed rank statistic. @X is an expression of type float or of a type that can be implicitly converted to float.

@Exact

tells the function whether or not to do the exact calculation or to calculate an approximate value using the normal distribution. @Exact is an expression of type bit or of a type that can be implicitly converted to bit.

Return Type

float

Remarks

If @N < 0 then an error is returned.

If @Exact IS NULL and @N > 50 then @Exact = FALSE.

IF @N > 1023 Then @Exact = FALSE.

Examples

SELECT x,

       n,

       wct.PSIGNRANK(x, n, NULL) as PSIGNRANK

FROM

(

    SELECT 2,

           4

    UNION ALL

    SELECT 5,

           6

    UNION ALL

    SELECT 22,

           10

    UNION ALL

    SELECT 27,

           15

) p(x, n);

This produces the following result.

{"columns":[{"field":"x","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"n","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"PSIGNRANK","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"x":"2","n":"4","PSIGNRANK":"0.1875"},{"x":"5","n":"6","PSIGNRANK":"0.15625"},{"x":"22","n":"10","PSIGNRANK":"0.3125"},{"x":"27","n":"15","PSIGNRANK":"0.0318603515625"}]}