IDAX.ANOVA_RBD_TEST - Analyze variance by using randomized block design

Use this stored procedure to analyze variance by using randomized block design.

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role.

Syntax

IDAX.ANOVA_RBD_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(128
block: Mandatory.; The input column that identifies a block of treatments.; Data type: VARCHAR(128)
treatment: Mandatory.; The column of the input table that identifies a treatment.; Rows that contain the same treatment value correspond to the same group of patients.; Data type: VARCHAR(128)
incolumn: Mandatory.; The names of the numeric columns that contain the values of the observations, separated by semi-colons (;).; All columns must be numeric.; Data type: VARCHAR(ANY)
outtable: Optional.; The output table, which the information about variance statistics is written to.; Default: none; Data type: VARCHAR(128)
by: Optional.; The column of the input table that splits the data into groups for which variance statistics are gathered.; Default: none; Data type: VARCHAR(128)

Returned information

If the output table is specified, only the number of rows that are written to the output table as a result set.

If the output table is not specified, the content of the output table is returned as result set.

The result set columns are as follows:

Table 1. Result set columns for the IDAX.ANOVA_RBD_TEST procedure
Column name	Column type	Description
Name of column as specified by the by parameter	Type of column as specified by the by parameter	The group of treatments. This column is only shown if the by parameter is specified.
COLUMNNAME	VARCHAR(128)	The name of the observation column.
BLSSCBETWEEN	DOUBLE	The variance of observations around the overall mean between the blocks of treatments for this column.
BLDFBETWEEN	INTEGER	The number of degrees of freedom between the blocks of treatments for this column.
SSCWITHIN	DOUBLE	The sum of variance of observations within the treatments for this column.
DFWITHIN	INTEGER	The sum of number of degrees of freedom within each treatment for this column.
GRSSCBETWEEN	DOUBLE	The variance of observations around the overall mean between the treatments for this column.
GRDFBETWEEN	INTEGER	The number of degrees of freedom between the treatments for this column.
DFBETWEEN	INTEGER	The number of degrees of freedom between the treatments for this column.
FBL	DOUBLE	The F-Statistics for the blocks of treatments of this column.
PBL	DOUBLE	The probability that the true F statistics is lower or equal to the F value for this column as computed from the sample.
FGR	DOUBLE	The F-Statistics for the treatments of this column.
PGR	DOUBLE	The probability that the true F statistics is lower or equal to the F value for this column as computed from the sample.

Example

CREATE TABLE textiles(chemical NVARCHAR(4), bolt INT4, concentration DOUBLE, ph DOUBLE);
        INSERT INTO textiles VALUES('A',1,65,10.1);
        INSERT INTO textiles VALUES('A',2,50,12.2);
        INSERT INTO textiles VALUES('A',3,45,11.9);
        INSERT INTO textiles VALUES('B',1,42,11.4);
        INSERT INTO textiles VALUES('B',2,30,12.9);
        INSERT INTO textiles VALUES('B',3,22,12.7);
        INSERT INTO textiles VALUES('C',1,44,9.9);
        INSERT INTO textiles VALUES('C',2,80,12.3);
        INSERT INTO textiles VALUES('C',3,76,11.4);
        INSERT INTO textiles VALUES('D',1,79,12.1);
        INSERT INTO textiles VALUES('D',2,99,13.4);
        INSERT INTO textiles VALUES('D',3,86,12.9);

        CALL IDAX.ANOVA_RBD_TEST('intable=textiles, incolumn=ph;concentration, treatment=chemical, block=bolt, outtable=outtab');

        SELECT * FROM outtab ORDER BY columnname;