The WILCOXON_TEST stored procedure runs the Wilcoxon test on paired numeric input columns
to evaluate the significance of the difference of their mean values.
Syntax
IDAX.WILCOXON_TEST(in parameter_string varchar(32672))
Parameter descriptions
- parameter_string
- Mandatory one-string parameter that contains pairs of
<parameter>=<value> entries that are separated by a comma.
- Data type: VARCHAR(32672)
- The following list shows the parameter values:
-
- intable
- Mandatory.
- The name of the input table.
- Data type: VARCHAR(256)
- incolumn
- Mandatory.
- The two numeric columns of the input table that are separated by a semicolon (;).
- Data type: VARCHAR(ANY)
- by
- Optional.
- The column of the input table that splits the data into groups for which the stored procedure is
to be done.
- Default: none
- Data type: VARCHAR(128)
- outtable
- Optional.
- The name of the output table to which the Spearman rank correlation is written.
- The output table contains the following columns:
- N
- SSTAT
- WSTAT
- ZSTAT
- PP
- LOWER
- If the by parameter is specified, an extra BY column is added to indicate
for which group the WILCOXON test is calculated.
- Only those records for which both columns are not null are considered.
- Data type: VARCHAR(ANY)
Returned information
A string as VARCHAR(200) that contains the test results or the number of rows in the output
table.
Example
CALL IDAX.WILCOXON_TEST('intable=IRIS,incolumn=sepalwidth;petalwidth');
CALL IDAX.WILCOXON_TEST('intable=IRIS,incolumn=sepalwidth;petalwidth, by=class, outtable=WILCOXON_TEST_RESULT')