1.4 Classification of Data (Qualitative & Quantitative)

Level: 1 | Version: v1.1 | Author: Meptrasoft

Overview

Data can be classified not only by its format, but also by what the data represents.

There are two main categories:

DATA
│
├── QUALITATIVE
│   ├── Nominal
│   └── Ordinal
│
└── QUANTITATIVE
    ├── Discrete
    └── Continuous

The easiest way to remember the difference:

Qualitative data describes a quality or category. Quantitative data represents a quantity that can be counted or measured.

Quantitative Data

Quantitative data represents values that can be counted or measured using numbers.

It usually answers questions such as:

• How many?
• How much?
• How often?

Examples:

Number of students = 40
Orders placed = 125
Temperature = 36.7°C
Height = 172.5 cm

Quantitative data has two common types: Discrete and Continuous.

Discrete Data

Discrete data consists of separate, countable values.

It is usually obtained by counting.

Examples:

• Number of students in a class
• Number of website clicks
• Number of cars in a parking lot
• Number of orders

For example:

Students = 40

You can have 40 students, but not 40.5 students.

Discrete data is counted and normally represented using separate whole-number values.

Continuous Data

Continuous data is data that can take different values within a range.

It is usually obtained by measuring.

Examples:

• Height
• Weight
• Temperature
• Time
• Distance

For example:

Height = 172.5 cm
Temperature = 36.7°C

A measurement can often be made more precise:

172 cm
172.5 cm
172.53 cm
172.531 cm

Continuous data is measured and can take fractional or decimal values within a range.

Qualitative Data

Qualitative data describes qualities, characteristics, or categories rather than quantities.

It answers questions such as:

“What kind?”

Examples:

Department = CSE
City = Chennai
Feedback = Good
Product Color = Blue

Qualitative data has two common types: Nominal and Ordinal.

Nominal Data

Nominal data consists of categories that do not have a natural order or ranking.

Examples:

City:
Chennai
Mumbai
Delhi

There is no meaningful ranking such as Chennai > Mumbai > Delhi.

Other examples:

• Eye color
• Blood group
• Department
• Country
• Product category

Nominal = Names or categories without an order.

Ordinal Data

Ordinal data consists of categories that have a meaningful order or ranking.

Examples:

Poor → Average → Good → Excellent

There is a clear order from lower to higher satisfaction.

Other examples:

• Small → Medium → Large
• Beginner → Intermediate → Advanced
• Bronze → Silver → Gold

The important point is that the order matters, but the difference between categories is not necessarily equal.

For example, the difference between Poor → Average may not be the same as Good → Excellent.

Ordinal = Ordered categories.

Simple Comparison

Quick Memory Trick

QUALITATIVE → QUALITY / CATEGORY

QUANTITATIVE → QUANTITY / NUMBER

NOMINAL → NO ORDER

ORDINAL → ORDER

DISCRETE → COUNT

CONTINUOUS → MEASURE

How This Relates to SQL

These classifications help us understand what values a database column represents.

For example:

SQL can work with both categorical and numerical data.

For example, we can filter by a category:

SELECT *
FROM Students
WHERE Department = 'CSE';

Or calculate values such as an average:

SELECT AVG(Marks) AS Average_Marks
FROM Students;

The first query works with a categorical value, while the second performs a numerical calculation.

Data classification helps us understand what a value represents and how it can be analyzed.

Common Beginner Mistakes

Placement Quick Points

QUALITATIVE
→ CATEGORY / QUALITY
→ NOMINAL + ORDINAL

QUANTITATIVE
→ NUMBER / QUANTITY
→ DISCRETE + CONTINUOUS

NOMINAL
→ NO NATURAL ORDER

ORDINAL
→ MEANINGFUL ORDER

DISCRETE
→ COUNTED

CONTINUOUS
→ MEASURED

• Qualitative data describes categories or qualities.
• Nominal data has categories without a natural order.
• Ordinal data has categories with a meaningful order.
• Quantitative data represents numerical quantities.
• Discrete data is counted.
• Continuous data is measured and can take values within a range.
• SQL can filter, group, and analyze both categorical and numerical data.

Interview Questions

What is the difference between qualitative and quantitative data?

Qualitative data describes categories or qualities, while quantitative data represents numerical quantities that can be counted or measured.

What is nominal data?

Nominal data consists of categories with no natural order.

Example:

TEXT

City = Chennai, Mumbai, Delhi

What is ordinal data?

Ordinal data consists of categories with a meaningful order or ranking.

Example:

TEXT

Poor → Average → Good → Excellent

What is the difference between discrete and continuous data?

Discrete data is counted and consists of separate values, while continuous data is measured and can take values within a range.

Example:

TEXT

Discrete   → Number of students = 40
Continuous → Height = 172.5 cm

Is customer feedback such as Poor, Average, Good, Excellent nominal or ordinal?

It is ordinal because the categories have a meaningful order.

Can qualitative data be used in SQL?

Yes. SQL can filter, group, sort, and count categorical data.

For example:

SQL

SELECT Department, COUNT(*)
FROM Students
GROUP BY Department;

Why is the distinction between discrete and continuous data useful?

It helps us understand whether a value represents something that is counted or measured, which affects how the data is interpreted and analyzed.

Practice & Hands-On Exercises

Beginner Practice

1. Define qualitative data in your own words.
2. Define quantitative data in your own words.
3. Give two examples of nominal data.
4. Give two examples of ordinal data.
5. Give two examples of discrete data.
6. Give two examples of continuous data.

Classify the Data

Classify each as Nominal, Ordinal, Discrete, or Continuous:

7. Number of employees in a company
8. Customer feedback: Poor, Average, Good, Excellent
9. Temperature of a room
10. Blood group
11. Number of orders placed
12. T-shirt size: S, M, L, XL
13. Student height
14. Department: CSE, IT, ECE

SQL Connection

Consider a Students table with:

Name
Department
Marks
Height

15. Which column is categorical?
16. Which column contains a numerical score?
17. Which column can contain continuous measurements?
18. Write a query to find the number of students in each department:

SELECT Department, COUNT(*) AS Total_Students
FROM Students
GROUP BY Department;

19. Write a query to calculate the average marks:

SELECT AVG(Marks) AS Average_Marks
FROM Students;

💡 Tip: Test your queries using the in-browser interactive runner above.

Key Takeaway

DATA
│
├── QUALITATIVE
│   ├── NOMINAL → NO ORDER
│   └── ORDINAL → HAS ORDER
│
└── QUANTITATIVE
    ├── DISCRETE → COUNTED
    └── CONTINUOUS → MEASURED

Qualitative data describes categories, while quantitative data represents quantities. Nominal and ordinal describe the type of category; discrete and continuous describe the type of numerical value.

End of Classification of Data (Qualitative & Quantitative)