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