Basic Data Handling – Study Notes
(Class 11–12 Commerce, Mathematics)
Goal: To provide a rigorous, first‑principles treatment of data handling that equips commerce students with the analytical tools needed for business research, market analysis, and decision making, while also laying a foundation for more advanced study (e.g., probability, statistics, econometrics).
1. Data and Variables
| Concept | Formal Definition | Example |
|---|---|---|
| Data | A collection of observations obtained from a measurement process. | Sales figures, price levels, customer ratings |
| Variable | A property or characteristic that can take on different values for different observations. | Quantitative variable: price; Qualitative variable: product category |
| Observation | A single record (row) in a data set, representing one unit (person, firm, time period). | The sales of Firm A in Q1 |
1.1 Types of Variables
| Type | Characteristics | Example |
|---|---|---|
| Qualitative (Categorical) | Non‑numeric, only classification | “Product type” – “Beverage”, “Snack” |
| Quantitative (Numerical) | Numeric values, arithmetic operations meaningful | “Price” – 5.50, 7.90 |
| Discrete | Countable values (integers) | Number of customers |
| Continuous | Any value in an interval | Temperature, time |
2. Measurement Scales – From First Principles
Measurement theory formalises how we assign symbols to observations. It is built on axioms that guarantee consistency.
2.1 The Four Classical Scales
| Scale | Metric Properties | Symbolic Representation | Example |
|---|---|---|---|
| Nominal | Order not meaningful; only sameness/difference | Labels | “Color”: red, green, blue |
| Ordinal | Order meaningful but not magnitude | Ranks | “Customer satisfaction”: 1 = Very Poor … 5 = Very Good |
| Interval | Order + equal intervals; zero is arbitrary | Numbers, additive | Temperature in Celsius |
| Ratio | Order + equal intervals + true zero | Numbers, additive & multiplicative | Weight, revenue |
Proof of Necessity:
For any scale to support arithmetic, it must satisfy transitivity (if (x>y) and (y>z) then (x>z)) and compatibility with operations (e.g., (x+z) preserves order). These axioms hold exactly for interval and ratio scales; they fail for nominal and ordinal, which explains why we cannot compute a mean of colors or of ranks.
2.2 Reliability & Validity
- Reliability: Consistency of measurement (e.g., repeated surveys give similar results).
- Validity: Whether the measurement captures what it intends to measure (e.g., does a “satisfaction” survey truly reflect customer contentment).
In commerce, construct validity is crucial: a variable like “brand equity” must be operationalised through proxies