Change Factor Levels and Labels

This menu can be used to change the attributes of factor columns for the current spreadsheet. The different attributes of a factor are displayed: ordinals, levels, and labels. The corresponding ordinal value is displayed for levels and labels that are not defined. At the head of each column are editable fields that can be used to remap or merge ordinals or to change the associated levels or labels.

The Edit factor levels and labels menu provide an alternative way of changing individual level or label values. Similarly, the Edit factor levels and Edit factor labels can be used to change the levels and labels of a factor.

Factor Name

Lists all the factors within the current spreadsheet. Select the factor you want to modify.

Old Factor Levels/Labels

Lists the ordinals and, if defined, the associated levels and labels.

New

Specifies a new ordinal value for the highlighted entry. Used for merging or mapping ordinal values. After changing a value, you must press Enter for the change to take effect.

New Levels/Labels

Allows you to edit the numeric level or text label corresponding to the highlighted ordinal. After changing a value, you must press Enter for the change to take effect.

Recalculate Ordinals

Recalculates the ordinal values for the factor and updates the mapping displayed for levels and labels, without affecting the spreadsheet itself. This allows you to check the changes made and amend them if necessary before applying them to the spreadsheet. This function is called automatically if you select Apply or OK.

- Unused

This deletes unused levels from the factor definition. A level is said to be unused if that value does not appear in any cell within a column.

Apply

Applies the changes made, updating the displayed spreadsheet, without closing the dialog.