These menu items change the attributes of factors in the spreadsheet.
Change Levels
Edit, permute, or amalgamate the levels or labels displayed for a factor column.
This allows the levels and labels of a factor to be
edited, reordered and amalgamated or removed.
This was Column Convert Factor Levels in the 3rd Edition.
Click here for more details.
Reorder Levels
This allows the order of labels or levels in a factor to be changed.
Click here for more details.
Calculate
This opens the Form Groups window, but any
factors formed in this window will be inserted as a column
into the spreadsheet. If a column of the same name already
exists, this will be replaced with the new factor created.
Product/Combine
Combined two or more factors into a new factor that indexes the
factorial combinations of the source factors.
Click here for more details.
Convert to
Convert the current column into a factor.
Recode
This opens the Recode a Column dialog, which provides
a small spreadsheet for creating a new structure from the current
factor, specifying new values (either numeric or text) for each group
in the factor. This menu can be used to group together items in
the factor.
Edit Levels & Labels
This opens the Edit Factor Levels and Labels dialog, which provides
a small spreadsheet for editing factor ordinals, levels and labels
in parallel.
Edit Levels
A direct link to the Edit Factor Levels dialog, without
going through the Column Attributes/Format dialog.
Edit Labels
A direct link to the Edit Factor Labels dialog, without
going through the Column Attributes/Format dialog.
Reference Level
This menu opens a dialog that allows you to change the reference level
for a factor. The reference level for a factor is used as the base
group for comparisons in regression analyses.
The reference level for a factor can also be set in the
Column Attributes/Format dialog.
Clear Levels
Delete the levels of the current column. The column is still a
factor but now just has ordinal values and perhaps labels.
Clear Labels
Delete the labels of the current column. The column is still a
factor but now just has ordinal values and perhaps levels.
Remove Unused Levels
This menu item removes levels & labels from a factor for groups
which have no occurrences in the data. For example if a factor
contained a single occurrence of a label, say 'A' and the row
containing 'A' was deleted, then the factor would still contain
a group 'A', and tables and analyses using this factor would still
refer to the group 'A'. This menu would remove the group associated
with A in the factor. It is possible to set this to happen automatically
when focus moves off a spreadsheet by setting the Remove Unused Factor
Levels on updates option on the Spreadsheet Conversions Options Tab dialog
Display Ordinals
Change the display of the column to be the ordinal values
of the factor (i.e. 1,2,3,... for the first, second, third
groups etc.).
Display Levels
Change the display of the column use the numerical values
(levels) associated with each group in the factor.
Display Levels
Change the display of the column use the text string
(labels) associated with each group in the factor.
Copy Labels to Clipboard
This puts the currently displayed factor levels, labels or
ordinals on the clipboard in the format that can be included
in GenStat directives (e.g. !T('A','B') or !(10,20)) and these
levels or labels can be pasted into factors in other columns
using the Paste Labels to Clipboard menu item below.
This menu and the one below provide a method of transferring
factor details from one column to another.
Paste Labels from Clipboard
This puts the text on the clipboard (as levels or labels) into the
current column if its a factor. If the text on the clipboard is
numerical, then it is placed in the factors levels, otherwise
it is placed in the factors labels.
See Also
Understanding Factors within a Spreadsheet
Spread Menu Commands
Spreadsheet Toolbar
Spreadsheet Column Menu
GenStat Spreadsheet Contents