This menu allows you to specify analysis commands that can be applied to a selection of
variate columns within a spreadsheet. The analysis commands should include a dummy name to
represent the columns within the code. GenStat will run the analysis for each selected column where
the column names are automatically substituted for the dummy name in the code. This is equivalent
to using a DUMMY directive within a FOR
loop in the GenStat command language. You can also supply a set
of commands that are to be run before the main analysis. The analysis commands
are stored within a GenStat spreadsheet (GSH) or GenStat book (GWB) file and so can be
rerun on any further columns added to the spreadsheet at a later time. Text can be copied from the Input
window via the Copy and Paste clipboard commands.
Select Columns for Analysis
Specifies the columns within the spreadsheet that are to be used in the analysis commands. GenStat will
run the analysis for each selected column. Multiple selections can be made using the ctrl and/or shift
keys with the mouse.
| Select All | Select all columns within the list. |
| Clear Selection | Clear the selection from the list. |
| Setup | Opens a dialog where you can supply some setup commands to be run before the main analysis. |
Dummy
Name of the dummy used to represent the selected columns in the analysis commands.
| Replace | Replace some specified text in the analysis directives with the dummy text.
For example, if you have copied some commands from a text window, you might
want to replace the name of the variate analysed with the dummy name.. |
Analysis Directives
The GenStat commands to be run for each selected column. The commands must be specified so that the Dummy name represents the column names within the code.
Action Buttons
| Run | Run the analysis on selected columns and close the window. |
| Cancel | Close the window without making any changes. |
| Defaults | Save the selected analysis commands and close the menu. |
Example
A field trial was designed examining the effect of Nitrogen for different cultivars. Four measurements were recorded and stored in a spreadsheet with the following column names GreenWt, Moisture, Screen% and Yield. To analyse all four measurements separately using ANOVA the Spreadsheet Analysis can be used. To analyse these measurements the following code could be entered into the setup and analysis commands.
Setup Directives
TREATMENT Nitrogen*Cultivar
BLOCKSReplicates
Dummy
Y
Analysis Directives
ANOVA [Print=AOV,Means;PSE=LSD;FPROB=Yes] Y
DAPLOT Fitted,Normal,Histogram
By selecting the columns: GreenWt, Moisture, Screen% and Yield, and clicking on Run the analysis will be run for each column. In addition the following commands would appear in the Audit Trail:
TREATMENT Nitrogen*Cultivar
BLOCKS Replicates
FOR Y = GreenWt,Moisture,Screen%,Yield
ANOVA [Print=AOV,Means;PSE=LSD;FPROB=Yes] Y
DAPLOTFitted,Normal,Histogram
ENDFOR
When saving a spreadsheet to an Excel, if the spreadsheet contains analysis commands then these will be saved to the Excel file in a specially named column entitled $Analysis$.
See Also