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).
-2-1.5-1-0.50.511.5295100105110yIndex Value (I_t) for x = year (base year = 0)Base Year (B)Current Year (t)
Index number formula: I_t = (S_t / S_B) × 100, where S_B = 100 (base year)

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

  1. Laspeyres Index (fixed base‑year quantities)
  2. Paasche Index (fixed current‑year quantities)
  3. Fisher Index (geometric mean of Laspeyres and Paasche)
  4. 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
03.176.339.512.67Rice12.67Wheat8Cooking Oil10Percentage Change (%)
Percentage price increase for each item (Laspeyres method)

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

  1. Trend (T) – long‑term direction (upward, downward, or stationary).
  2. Seasonality (S) – regular pattern repeating within a fixed period (e.g., monthly sales peaks).
  3. Cyclical (C) – long‑term oscillations not fixed to a calendar period.
  4. 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.

11.522.533.544.555.5610121416182022Actual Sales3-Month Moving Average
3-month moving average smoothing actual sales data

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

  1. Index Calculations – Practice computing Laspeyres, Paasche, Fisher, and chain indices. Memorise the formulas and the role of base‑year quantities.
  2. 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.
  3. Forecasting Methods – Understand the difference between moving averages and exponential smoothing, and when each is appropriate.
  4. 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.
  5. Worked Example – Include all steps, show intermediate calculations, and label your figures clearly.

CPI chartConsumer 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…