IDAX.ANOVA_CRD_TEST - Analyze variance by using completely randomized design

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

Authorization

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

Syntax

IDAX.ANOVA_CRD_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)
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.; The number of observations per treatment must be identical for all treatments.; 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_CRD_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.
TOTNO	DOUBLE	The number of observations for this column.
TOTSU	DOUBLE	The sum of observations for this column.
TOTMEAN	DOUBLE	The mean value of the observations for this column.
TOTSS	DOUBLE	The sum of squares of the observations for this column.
SSCTOT	DOUBLE	The population variance of the observations of this column.
SSCBETWEEN	DOUBLE	The variance of the observations around the overall mean between the treatments for this column.
DFBETWEEN	INTEGER	The number of degrees of freedom between the treatments for this column.
SSCWITHIN	DOUBLE	The sum of variance of the observations within the treatments for this column.
DFWITHIN	INTEGER	The number of degrees of freedom within the treatments for this column.
F	DOUBLE	The F statistics for the treatments of this column.
P	DOUBLE	The probability that the true F statistics is lower or equal to the F value for this column.

Example

CREATE TABLE wheattest(fieldId INTEGER, variety CHAR(1), yield DOUBLE, barrels INTEGER);
        INSERT INTO wheattest VALUES(1,'A',80, 4);
        INSERT INTO wheattest VALUES(2,'A',65, 3);
        INSERT INTO wheattest VALUES(3,'A',50, 2);
        INSERT INTO wheattest VALUES(4,'B',100, 5);
        INSERT INTO wheattest VALUES(5,'B',85, 4);
        INSERT INTO wheattest VALUES(6,'B',70, 3);
        INSERT INTO wheattest VALUES(7,'C',60, 2);
        INSERT INTO wheattest VALUES(8,'C',75, 3);
        INSERT INTO wheattest VALUES(9,'C',90, 5);

CALL IDAX.ANOVA_CRD_TEST('intable=wheattest, incolumn=yield;barrels, treatment=variety, outtable=outtab');
SELECT * FROM outtab ORDER BY columnname;