Business StatisticsUnit 108 min read
Unit 10 – Index Numbers & Time Series Analysis (Basic Concepts)
Unit 10 of Business Statistics: introduces index numbers (price, quantity, composite) and basic time‑series concepts (trend, seasonality, decomposition, forecasting) with practical examples and real‑world applications.
Key points
- Index numbers convert varying quantities into comparable figures using a base year.
- Laspeyres, Paasche, Fisher and chain indices differ in weight allocation and bias.
- Time‑series data are decomposed into trend, seasonal, cyclical and irregular components.
- Moving averages and exponential smoothing are simple yet powerful forecasting tools.
- Index concepts underpin everyday tools such as CPI, NEPSE, eSewa transaction volume and Daraz price monitoring.
Introduction to Index Numbers
An index number is a dimensionless ratio that expresses the relative change in a variable (price, quantity, value) between two periods.
- Base year : the period against which all other periods are compared.
- Index value for period is usually expressed as a percentage of the base year (100).
where and are the summed values (prices, quantities, etc.) in period and the base year, respectively.
Types of Index Numbers
| Index Type | What it measures | Typical use |
|---|---|---|
| Price Index | Relative change in price of a basket | CPI, Producer Price Index |
| Quantity Index | Relative change in quantity sold | Agricultural output index |
| Composite Index | Combined measure of multiple variables | GDP deflator, NEPSE index |
Common Price Indices
- Laspeyres Index (fixed base‑year quantities)
- Paasche Index (fixed current‑year quantities)
- Fisher Index (geometric mean of Laspeyres and Paasche)
- Chain Index (sequential linking)
Worked Example – Laspeyres Price Index
Suppose a basket contains three goods: rice, wheat, and cooking oil.
| Good | Base‑Year Price (Rs) | Current‑Year Price (Rs) | Base‑Year Quantity (kg) |
|---|---|---|---|
| Rice | 30 | 35 | 100 |
| Wheat | 25 | 27 | 80 |
| Oil | 20 | 22 | 50 |
Step 1: Compute base‑year total value
Step 2: Compute current‑year total value using base‑year quantities
Step 3: Laspeyres index
Interpretation: Prices have risen by 12.67 % relative to the base year.
Index Number Comparison Table
| Index | Weighting | Bias | Use‑case |
|---|---|---|---|
| Laspeyres | Base‑year quantities | Over‑estimates inflation when new goods enter | CPI (historical) |
| Paasche | Current‑year quantities | Under‑estimates inflation when consumers shift to cheaper goods | CPI (current) |
| Fisher | Geometric mean | Balanced | Ideal CPI |
| Chain | Sequential | No base‑year bias | GDP deflator, NEPSE |
Time‑Series Analysis – Basic Concepts
A time series is a sequence of observations recorded at successive equally spaced time intervals.
Components of a Time Series
- Trend (T) – long‑term direction (upward, downward, or stationary).
- Seasonality (S) – regular pattern repeating within a fixed period (e.g., monthly sales peaks).
- Cyclical (C) – long‑term oscillations not fixed to a calendar period.
- Irregular (I) – random noise or unexpected shocks.
Mathematically, for an additive model:
For a multiplicative model:
Visualising a Time Series
The blue line shows observed sales, the red line the estimated trend, and the green line the seasonal component.
Decomposition Methods
- Additive decomposition is appropriate when seasonal fluctuations are roughly constant over time.
- Multiplicative decomposition is used when seasonal variations change proportionally with the level of the series.
Decomposition Process (Mermaid)
flowchart TD
"Observed Series" --> "Estimate Trend (Moving Avg)"
"Observed Series" --> "Detrend (Subtract Trend)"
"Detrend" --> "Estimate Seasonal (Average of Detrended)"
"Detrend" --> "Detrend Seasonal (Subtract Seasonal)"
"Detrend Seasonal" --> "Irregular Component"Forecasting Techniques
1. Moving Average (MA)
A simple method that smooths short‑term fluctuations by averaging a fixed number of past observations.
Worked Example – 3‑Month MA
| Month | Actual | 3‑Month MA |
|---|---|---|
| 1 | 10 | – |
| 2 | 12 | – |
| 3 | 15 | (10+12+15)/3 = 12.33 |
| 4 | 18 | (12+15+18)/3 = 15 |
| 5 | 20 | (15+18+20)/3 = 17.67 |
| 6 | 22 | (18+20+22)/3 = 20 |
2. Exponential Smoothing (ES)
Weights all past observations but assigns exponentially decreasing weights to older data.
where is the smoothing constant.
Worked Example –
| Month | Actual | Smoothed |
|---|---|---|
| 1 | 10 | 10 |
| 2 | 12 | 0.5×12 + 0.5×10 = 11 |
| 3 | 15 | 0.5×15 + 0.5×11 = 13 |
| 4 | 18 | 0.5×18 + 0.5×13 = 15.5 |
| 5 | 20 | 0.5×20 + 0.5×15.5 = 17.75 |
| 6 | 22 | 0.5×22 + 0.5×17.75 = 19.875 |
In the Real World
| Product / Company | Index Concept Used | How It Is Applied |
|---|---|---|
| NEPSE (National Stock Exchange) | Price Index (Composite) | NEPSE calculates a daily index of all listed stocks, using the Laspeyres formula with current‑year weights, to reflect overall market performance. |
| Daraz (e‑commerce) | Price Index for product categories | Daraz tracks price changes of electronics using a Fisher index to provide customers with real‑time inflation information for their purchases. |
| eSewa (digital wallet) | Transaction Volume Index | eSewa computes a monthly index of transaction counts (quantity index) to monitor growth and plan infrastructure scaling. |
| Ncell (telecom) | Subscriber Growth Index | Ncell uses a composite index (quantity + price) to assess market penetration and adjust tariff plans. |
| NEPSE | Time‑Series Forecasting | NEPSE analysts use moving averages and exponential smoothing to forecast short‑term index movements for traders. |
Concrete Example – Daraz Price Index
Daraz monitors the price of a flagship smartphone.
- Base year price: Rs 30,000 (January 2023).
- Current price: Rs 32,000 (January 2024).
Using a Fisher index (assuming equal weights for simplicity):
The index remains 100, indicating no net price change when considering both price and quantity adjustments. This informs Daraz’s dynamic pricing strategy.
Exam Tip
- Index Calculations – Practice computing Laspeyres, Paasche, Fisher, and chain indices. Memorise the formulas and the role of base‑year quantities.
- Time‑Series Decomposition – Be able to identify trend, seasonal, cyclical, and irregular components from a given plot. Know when to use additive vs. multiplicative models.
- Forecasting Methods – Understand the difference between moving averages and exponential smoothing, and when each is appropriate.
- Interpretation – Exams often ask for interpretation of index values or forecasted figures; practice explaining what a 112.5 index or a 3‑month MA of 17.7 means in context.
- Worked Example – Include all steps, show intermediate calculations, and label your figures clearly.
Consumer Price Index trend in Nepal (Image: Amitchell125, CC BY 4.0, via Wikimedia Commons)
Based on the TU BITM syllabus for Business Statistics (STT201), unit 10.
Discussion
Loading…