Code a Column to Groups

This dialog splits a numerical column into groups based on specified limits or break points and creates a factor to index these groups.

Groups Column Name

The name of the new factor to be created. This may be the name of an existing column, in which case this column is overwritten (after a warning).

Number of Groups

The number of groups for the new factor. The number of Break Points that need to be specified should be one less than the number of groups, but at least 2.

Limits are lower boundaries

When selected, the first group will be defined by the values less than the first Break Point (specified in the second row). The first group label is then automatically specified as < this break point. However, you can change the label if required.
When this option is not selected, the last group will be defined by the values greater than the last Break Point (specified in the second to last row). The last group label is then automatically specified as > this break point.

Break Points

The break points or limits that are used to divide the values up into groups.

Levels

The levels that are given to each group. Default values are 1...n.

Labels

The labels that are given to each group. Default values are generated from the Break Points.

Counts

The number of values that will coded to each groups with the current break points. The Counts column is provided for information and cannot be changed.

Reset

Set the Break Points, Levels and Labels back to their default values.

= Ranges

Calculate a set of break points that are equally spaced over the range of the data.

=Counts

Calculate a set of break points that divide the values into groups of equal size as close to equal counts as possible.

Copy and Paste

The cursor key movement for this menu is slightly different to a standard spreadsheet, in that the right/left arrow moves with a cell. Use the Tab and Back Tab (Shift+Tab) keys to move from column to column. The Shift key + up/down arrow & page up/down can be used to select individual cells. Alternatively, to select a group of cells, move the mouse to the top left of a cell, so that the cursor changes to the + icon, click down and drag to the end of the selection. A whole column can be selected by clicking on the column name.
The new values can be entered from the clipboard using the Ctrl+V shortcut key. The selected cells can be copied to the clipboard with the Ctrl+C shortcut key.

OK

Use the limits to code a columns into a new factor and close the dialog.

Cancel

Close the dialog without making any changes.