Analyse Spreadsheet Columns

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 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 the GSH file and so may 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.

Dummy

Name of the dummy used to represent the selected columns in the analysis commands.

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.

Select All

Select all columns for analysis.

Clear Selection

Clear the columns selected for analysis.

Setup

Opens a menu where you can supply some setup commands to be run before the main analysis.

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.

Run

Run the analysis on selected columns and close the window.

Cancel

Close the window without saving the directives.

Save and Close

Save the selected analysis directives 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