Saves results from an analysis of variance in a spreadsheet (R.W. Payne).
Options
MEANS = pointer |
Pointer to tables to contain the treatment means; default means |
|---|---|
SEMEANS = pointer |
Pointer to tables to contain the effective standard errors of treatment means; default ese |
SEDMEANS = pointer |
Pointer to matrices to contain standard errors of differences of treatment means; default sed |
EFFECTS = pointer |
Pointer to tables to contain the treatment effects; default effects |
REPLICATIONS = pointer |
Pointer to tables of treatment replications; default replication |
RESIDUALS = variate |
Variate to save the residuals in the fittedvalues page; default residuals |
FITTEDVALUES = variate |
Variate to save the fitted values in the fittedvalues page; default fittedvalues |
AOVTABLE = pointer |
Pointer to a text and variates containing the information in the analysis-of-variance table; default aovtable |
COVINFORMATION = pointer |
Pointer to a text and variates containing the information about the estimated covariate regression coefficients; default cov |
MVINFORMATION = pointer |
Pointer to a text and variates containing the information the about estimated missing values; default missing |
EQFACTORS = factors |
Factors whose levels are to be assumed to be equal within the comparisons between means, when calculating effective standard errors |
RMETHOD = string token |
Type of residuals to form (simple, standardized); default simp |
LSDMEANS = pointer |
Pointer to matrices to contain least significant differences for means |
LSDLEVEL = scalar |
Significance level (as a percentage) for the least significant differences; default 5 |
SPREADSHEET = string tokens |
What to include in the spreadsheet (aovtable, covariates, effects, means, semeans, sedmeans, replications, fittedvalues, missingvalues); default aovt, cova, mean, sedm, repl, fitt, miss |
OUTFILENAME = text |
Name of Genstat workbook file (.gwb) or Excel (.xls or .xlsx) file to create |
SAVE = ANOVA save structure |
Specifies which analysis to save; default * i.e. most recent one |
No parameters
Description
ASPREADSHEET puts results from an analysis of variance into a spreadsheet. By default the results are from the most recent ANOVA, but you use the SAVE option to specify the save structure from some other analysis.
The SPREADSHEET option specifies which pages of the spreadsheet to form, with settings:
aovtable |
analysis of variance table, |
|---|---|
covariates |
estimated covariate regression coefficients and their standard errors (if any covariates in the analysis), |
effects |
tables of treatment effects, |
means |
tables of treatment means, |
semeans |
tables of effective standard errors of treatment means, |
sedmeans |
matrices of standard errors of differences of treatment means, |
lsdmeans |
matrices of least significant differences of treatment means, |
replications |
replication tables of treatment terms, |
fittedvalues |
y-variate, fitted values and residuals, |
missingvalues |
estimates for missing values (if any). |
By default, SPREADSHEET = aovt, cova, mean, sedm, repl, fitt, miss.
To help avoid clashes between the columns of the spreadsheets if you want to save results from more than one analysis, the parameters MEANS, SEMEANS, SEDMEANS, LSDMEANS, EFFECTS, REPLICATIONS, RESIDUALS, FITTEDVALUES, AOVTABLE, COVINFORMATION and MVINFORMATION allow you to specify identifiers for the columns (or sets of columns) that will store the corresponding results in the current spreadsheet.
The EQFACTORS option allows you to specify factors within the tables of means whose levels are assumed to be equal for the two means, when calculating effective standard errors.
The RMETHOD option controls whether the residuals are simple residuals (like those printed by ANOVA – the default) or whether they are standardized according to their variances.
The LSDLEVEL option specifies the significance level (as a percentage) for the least significant differences; default 5.
You can save the data in either a Genstat workbook (.gwb) or an Excel spreadsheet (.xls or .xlsx), by setting the OUTFILENAME option to the name of the file to create. If the name is specified without a suffix, '.gwb' is added (so that a Genstat workbook is saved). If OUTFILENAME is not specified, the data are put into a spreadsheet opened inside Genstat.
Options: MEANS, SEMEANS, SEDMEANS, EFFECTS, REPLICATIONS, RESIDUALS, FITTEDVALUES, AOVTABLE, COVINFORMATION, MVINFORMATION, EQFACTORS, RMETHOD, LSDMEANS, LSDLEVEL, SPREADSHEET, OUTFILENAME, SAVE.
Parameters: none.
Action with RESTRICT
If the Y variate is restricted, that restriction will carry over into the fitted-values spreadsheet.
See also
Directive: SPLOAD.
Procedures: ADSPREADSHEET, AUSPREADSHEET, RSPREADSHEET, VSPREADSHEET, FSPREADSHEET.
Commands for: Analysis of variance.
Example
CAPTION 'ASPREADSHEET example',\
'3x2 factorial experiment (Snedecor & Cochran 1980, p.305).';\
STYLE=meta,plain
FACTOR [NVALUES=60; LABELS=!T(beef,cereal,pork); VALUES=(1...3)20] Source
& [LABELS=!T(high,low); VALUES=3(1,2)10] Amount
VARIATE [NVALUES=60] Gain
READ Gain
73 98 94 90 107 49
102 74 79 76 95 82
118 56 96 90 97 73
104 111 98 64 80 86
81 95 102 86 98 81
107 88 102 51 74 97
100 82 108 72 74 106
87 77 91 90 67 70
117 86 120 95 89 61
111 92 105 78 58 82 :
TREATMENTSTRUCTURE Source*Amount
ANOVA [PRINT=aovtable; FPROBABILITY=yes] Gain
ASPREADSHEET