PiscesLogoSmallerStill Age classed data

Top  Previous  Next

If File|New|Classed is selected, an empty grid will be formed with two titles, Age and Length, in place.

 

 

new classed table

 

 

These titles can be changed and others added by clicking in the top cell of another column and selecting a suitable title from the drop-down list.

 

choice of variable types

 

Alternatively, you can simply type in one of the following titles:

 

Age identifies the column as holding the ages (time since birth) of the animals. Ages can be input as integer or real numbers. Age can either be the age of an individual animal, or refer to an age class.

Length identifies the column as holding length at age data. These data can be either measurements for individual animals or the mean for an age class.

Weight identifies the column as holding weight at age data. These data can be either measurements for individual animals or the mean for an age class.

Length SD identifies the column as holding the standard deviations of length at age data. When age classed data are used this column gives a measure of the variation in length between the individuals in a single age class.

Weight SD identifies the column as holding the standard deviations of weight at age data. When age classed data are used this column gives a measure of the variation in weight between the individuals in a single age class.

 

Please note that the column title should be added exactly as given above.

 

You should avoid adding duplicate column titles; these are likely to cause the program to malfunction. If you add a duplicate title, the program will give a warning message to alert you. To delete a column title, click into the title cell, so that the text is highlighted, (see below) and press the Delete key on your keyboard.

ColTitleRem

Once you have the correct titles for the columns you can type in values in the grid by clicking on a cell and entering a number.

 

The typical structure of age classed data in an Excel spreadsheet is as follows:

 

Example Excel G2

 

 

To insert a new row, use the Up / Down arrows to highlight any cell in the bottom row of the grid so that it turns blue - as shown below - then press the Down arrow key on your keyboard.

 

RowAdd

To delete a row, highlight any cell in that row, so that the cell itself is highlighted blue, rather than its contents, and press the Delete key on your keyboard. Please note that the Undo function does not apply to row deletion; once a row has been deleted, it cannot be restored.