1. Home
  2. G2AEXPORT procedure

G2AEXPORT procedure

Forms a dbase file to transfer ANOVA output to Agronomix Generation II (R.W. Payne).

Options

PRINT = strings Controls printed output (columns); default * i.e. none
REPLICATETERMS = formula Specifies the term or terms that define the replication in the design
METHOD = string How to form the means (loweststratum, combined); default lowe
ALPHALEVEL = scalar Alpha value to use when calculating least significant differences; default 0.05
TAIL = scalar Number of tails in the calculation of least significant differences (1, 2); default 1
SAVE = ANOVA save structure Save structure for the analysis from which the means &c are to be saved; default * takes the information from the most recent ANOVA analysis

Parameters

MEANTERM = formula Defines the treatment term whose means are to be saved; no default (must be specified)
OUTFILE = text Name of the output file (dbf) to form; default * i.e. file not formed

Description

G2AEXPORT can be used after a Genstat ANOVA analysis, to write a dbase file with a table of means and associated information to be loaded into the Agronomix Generation II system (see agronomix.com).

Printed output is controlled by the PRINT option, with settings:

    columns to print the columns of information to be saved.

By default the means and other information are taken from the analysis of the last y-variate to have been analysed by ANOVA. Alternatively, you can take the information from an analysis of another y-variate, by saving a save structure using the SAVE parameter of ANOVA when it is analysed, and then supplying this to G2AEXPORT using its SAVE option.

The MEANTERM parameter specifies a formula defining the term whose means are to be saved; note that only one table of means can be saved in each call of the G2AEXPORT. The OUTFILE parameter specifies the file (assumed to be a dbase file) where the information is to be stored. The means are usually constructed in the standard way of the ANOVA directive, namely by taking the treatment effects from the lowest stratum where they are estimated. However, you can set option METHOD=combined to obtain means that combine information from every stratum where the relevant treatment effects are estimated.

The ALPHALEVEL option specifies the alpha value to use in the calculation of least significant differences that accompany the table of means (default 0.05), and the TAIL option specifies whether this is to be for a 1 or 2-sided test (default 1).

The REPLICATETERMS option can supply a model formula to specify one or more model terms defining complete replications of the treatments: for example, blocks in a complete randomized block design, or rows and columns in a Latin square.

Options: PRINT, REPLICATETERMS, METHOD, ALPHALEVEL, TAIL, SAVE.

Parameters: MEANTERM, OUTFILE.

Method

The information is mainly obtained using AKEEP. The first column (called NAME) describes the contents of each row. Then there is a column for every factor in the table of means, indexing the column of means (called AVG) which comes next. The ranks of the means are in the subsequent column (called RANK), and the next column (called CV) saves the standard deviation of the observations on each combination of the levels of the mean factors, expressed as a percentage of their mean. Finally, if the means are unequally replicated there is a column saving the replication of each mean.

At the top of the columns, there is a row for each mean in the table. Then there are some extra rows with the following names (in the NAME column) and information (in the AVG column):

    GRAND MEAN the grand (i.e. overall) mean;
    CV the coefficient of variation for the lowest stratum in which the maximal model term in the table of means (e.g. A.B for an A-by-B table of means) is estimated;
    LSD saves the least significant difference for the table of means if this is the same for all comparisons of means within the table, otherwise this is replaced by three rows with the minimum, average and maximum LSD (Min LSD, LSD and Max LSD);
    Residual the residual mean square for the lowest stratum in which the maximal model term in the table of means is estimated;
    SED saves the standard error of differences for the table of means if this is the same for all comparisons of means within the table, otherwise this is replaced by three rows with the minimum, average and maximum SED (Min SED, SED and Max SED);
    Alpha level alpha level used in the calculation of the LSDs (ALPHALEVEL option);
    R Square the value of R-square for analysis down to the lowest stratum in which the maximal model term in the table of means is estimated (this ensures that any lower strata that represent within-cell replication are ignored);
    No. of Reps saves replication of the table of means if this is the same for every mean in the table, otherwise this is replaced by three rows with the minimum, average and maximum replication (Min no. of Reps, No. of Reps and Max no. of Reps);
    RE-RCBD the efficiency factor of the maximal model term in the table of means, expressed as a percentage;
    Rep-Msqr the mean square of the REPLICATIONTERMS;
    Heritability this row is include for compatibility with the output that G2VEXPORT constructs following REML, but cannot be calculated for ANOVA analyses;
    Prob. Entry the F probability of the variance ratio of the maximal model term in the table of means;
    Error d.f. the residual degrees of freedom for the lowest stratum in which the maximal model term in the table of means is estimated;
    Tail Number of tails in the calculation of the least significant differences (TAIL option).

Action with RESTRICT

If the Y variate in the ANOVA was restricted, only the units not excluded by the restriction will have been analysed.

See also

Directive: ANOVA.

Procedures: G2AFACTORS, G2VEXPORT.

Commands for: Analysis of variance.

Example

CAPTION 'G2AEXPORT example',\
        !t('Randomized block design to assess five strains of wheat',\
        '(Snedecor, Statistical Methods, page 209).');\
        STYLE=meta,plain
SPLOAD  '%gendir%/data/wheatstrains.gsh'
BLOCKSTRUCTURE     Blocks
TREATMENTSTRUCTURE Strains
ANOVA              [FPROBABILITY=yes] Yield
G2AEXPORT          [PRINT=columns; REP=Blocks] Strains
Updated on March 7, 2019

Was this article helpful?