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

Variables

A variable is an attribute of an object. The value of a variable can vary from one thing to another.

There are two different types of variables:
  • Quantitative (or numeric) - data are numeric values of a quantity.
  • Qualitative (or categorical) - data differs only in kind.

Record quantitative data as the numeric value.

Record qualitative data as a numeric coding (for example, 0, 1, 2) or labels (for example, Low, Medium, High). Numeric codings are often preferred as they succinctly represent the values and allow quicker data entry. However, codings can be difficult to understand by anyone other than the person who assigned them. To make their meaning clear, you can also assign a label to each numeric coding.

Data are ordered based on numeric value, numeric coding, or if a numeric coding is not used into alphabetical label order. For some statistical tests, the sort order determines how observations are rank-ordered and can affect the results. Often alphabetic sort order does represent the correct ordering. For example Low, Medium, High is sorted alphabetically into High, Low, Medium which does not represent their correct, natural order. In such cases, you must explicitly set the order before analyzing the data.

Related concepts
Datasets
Measurement scales
Missing values
Related tasks
Ordering categorical data
Assigning labels to categories
Transforming variables

  •  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.