SQL Server PSIGNRANK Function

Updated 2023-11-06 16:41:23.307000

Description

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

Syntax

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

Arguments

@X

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

@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.

@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.