You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.

---

Open topic with navigation

Setting group order

Ordinal scale variables differ from nominal scale data because the groups have a predefined order. If numeric codes are used to represent the groups, the order is inferred from the ascending value of the numeric codes. When group names are used the order must be manually set, by mapping group names to numeric codes. The groups will then be ordered based on the ascending value of the numeric codes.

For nominal scale variables the numeric codes can be used to change how the groups are presented, from the default alphabetical name order, on output .

To set the mapping between group names and codes:

1. Select a cell in the range of the data of the variable to modify.
2. Click Variable on the Analyse-it tab/toolbar to show the Variable properties dialog box.
3. Ensure Measurement scale is set to Nominal or Ordinal.
4. In the Categories list assign numeric codes alongside the group names identified in the data for the variable.
5. Click OK.

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.