Saves results from an analysis of an unbalanced design (by AUNBALANCED
) 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 standard errors of treatment means; default sem |
SEDMEANS = pointer |
Pointer to matrices to contain standard errors of differences of treatment means; default sed |
ESEMEANS = pointer |
Pointer to matrices to contain effective standard errors of treatment means; default ese |
EFFECTS = pointer |
Pointer to contain the estimated effects, their standard errors, t-statistics and probabilities; 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 |
COMBINATIONS = string token |
Factor combinations for which to form predicted means (present , estimable ); default esti |
ADJUSTMENT = string token |
Type of adjustment to be made when predicting means (marginal , equal , observed ); default marg |
AOVTABLE = pointer |
Pointer to a text and variates containing the information in the analysis-of-variance table; default aovtable |
RMETHOD = string token |
Type of residuals to form (simple , standardized ); default simp |
SPREADSHEET = string tokens |
What to include in the spreadsheet (aovtable , effects , means , semeans , sedmeans , esemeans , replications , fittedvalues ); default aovt , mean , sedm , repl , fitt |
OUTFILENAME = texts |
Name of Genstat workbook file (.gwb) or Excel (.xls or .xlsx) file to create |
SAVE = identifier |
Save structure (from AUNBALANCED ) containing details of the analysis for which further output is required; if omitted, output is from the most recent use of AUNBALANCED |
No parameters
Description
AUSPREADSHEET
puts results from an analysis, by AUNBALANCED
, of an unbalanced design into a spreadsheet. By default the results are from the most recent analysis by AUNBALANCED
, 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, |
---|---|
effects |
estimates of effects, with their standard errors, t-statistics and probabilities, |
means |
tables of treatment means, |
semeans |
tables of standard errors of treatment means, |
sedmeans |
symmetric matrices of standard errors of differences of treatment means, |
esemeans |
tables of effective standard errors of treatment means, |
replications |
replication tables of treatment terms, |
fittedvalues |
y-variate, fitted values and residuals. |
By default, SPREADSHEET
= aovt
, mean
, sedm
, repl
, fitt
.
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
, ESEMEANS
, EFFECTS
, REPLICATIONS
, RESIDUALS
, FITTEDVALUES
and AOVTABLE
allow you to specify identifiers for the columns (or sets of columns) that will store the corresponding results in the current spreadsheet.
Tables of means are obtained from the AUKEEP
procedure which uses the PREDICT
directive. The first step (A) of the calculation forms the full table of predictions, classified by every factor in the model. The second step (B) averages the full table over the factors that do not occur in the table of means. The COMBINATIONS
option specifies which cells of the full table are to be formed in Step A. The default setting, estimable
, fills in all the cells other than those that involve parameters that cannot be estimated, for example because of aliasing. Alternatively, setting COMBINATIONS=present
excludes the cells for factor combinations that do not occur in the data. The ADJUSTMENT
option then defines how the averaging is done in Step B. The default setting, marginal
, forms a table of marginal weights for each factor, containing the proportion of observations with each of its levels; the full table of weights is then formed from the product of the marginal tables. The setting equal
weights all the combinations equally. Finally, the setting observed
uses the WEIGHTS
option of PREDICT
to weight each factor combination according to its own individual replication in the data.
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
, ESEMEANS
, EFFECTS
, REPLICATIONS
, RESIDUALS
, FITTEDVALUES
, COMBINATIONS
, ADJUSTMENT
, AOVTABLE
, RMETHOD
, 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
, ASPREADSHEET
, RSPREADSHEET
, VSPREADSHEET
, FSPREADSHEET
.
Commands for: Regression analysis.
Example
CAPTION 'AUSPREADSHEET example',\ 'Data from Genstat 5 Release 1 Reference Manual, page 340.';\ STYLE=meta,plain FACTOR [NVALUES=36; LEVELS=3; VALUES=12(1...3)] Block FACTOR [NVALUES=36; LABELS=!t(baresoil,emerald,emergo)] Leachate & [LABELS=!t('1','1/4','1/16','1/64')] Dilution VARIATE [NVALUES=36] Nhatch,Nnohatch READ Leachate,Dilution,Nhatch,Nnohatch 1 2 109 318 3 4 54 350 3 1 * 415 2 2 783 212 3 3 652 1375 2 4 490 816 1 3 95 1219 2 1 1012 66 1 4 166 943 3 2 1059 313 1 1 257 1006 2 3 1058 234 2 4 507 1119 1 2 194 840 1 3 175 1707 1 1 326 609 3 4 142 980 2 3 286 230 3 2 546 313 2 2 * 301 2 1 2471 112 3 3 76 489 1 4 208 503 3 1 * 325 1 1 322 913 1 2 255 2246 3 2 1774 1446 2 2 999 193 2 4 388 1836 3 4 221 1800 1 3 220 1902 2 1 2821 187 3 1 1486 463 3 3 717 1473 1 4 143 941 2 3 968 550 : CALCULATE Logit%h = LOG(Nhatch/Nnohatch) BLOCKSTRUCTURE Block TREATMENTSTRUCTURE Leachate*Dilution AUNBALANCED [PRINT=aovtable,effects,means,residuals; FPROBABILITY=yes;\ PSE=differences,alldifferences,means,ese] Logit%h AUSPREADSHEET [SPREADSHEET=aovtable,effects,fittedvalues,\ means,sedmeans,replications]