Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • User's Guide
  • Preparing data for analysis

Ordering categorical data

Set the order of categories for data analysis and output in the analysis report.

  1. Activate the dataset worksheet.
  2. On the Analyse-it ribbon tab, in the Dataset group, click Dataset.
    The dataset task pane opens.
  3. In the Variables list, select the variable.
  4. Click Nominal or Ordinal to set the measurement scale.
    The Categories grid shows the numeric coding and labels used in the data.
  5. Clear the Sort Categories check box to allow you to reorder the categories manually.
  6. Arrange the categories into order:
    • Using drag and drop, click and hold the mouse button down over a category until the drag insertion cursor appears, drag it to reposition it in the list and then release the mouse button.
    • Using the arrows, click a category to select it and then use the up and down arrow buttons to reposition it in the list.
  7. Click Apply.
    The changes are saved and will be used in future analyses.

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Getting to know Analyse-it
  •  Preparing data for analysis
  •  Datasets
  •  Variables
  •  Measurement scales
  •  Missing values
  •  Case and frequency form data
  •  Setting the measurement scale of a variable
  •  Setting the minimum, maximum and units of a variable
  •  Ordering categorical data
  •  Setting the number format of a variable
  •  Labeling cases
  •  Assigning labels to categories
  •  Assigning colors/symbols to categories
  •  Transforming variables
  •  Transform functions
  •  Analyzing a subset of the data
  •  Working with analyses
  •  Feedback and crash reports
  •  Statistical Reference Guide



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

Statistical analysis and method validation software for Microsoft Excel.

We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.