Median vs Average: Why We Use Medians for Valuation Analysis

The Problem with Averages

When analyzing index valuations, many investors instinctively think about averages. However, averages can be misleading, especially when dealing with financial data that includes outliers.

A Simple Example

Imagine 5 months of P/E data for an index:

• Month 1: 18
• Month 2: 19
• Month 3: 20
• Month 4: 21
• Month 5: 80 (market crash distortion)

Average: (18 + 19 + 20 + 21 + 80) / 5 = 31.6
Median: 20 (middle value when sorted)

Which better represents "normal" conditions? Clearly the median at 20, not the average at 31.6.

Why Financial Data Has Outliers

Financial markets experience extreme events:

1. Market crashes: COVID-19, 2008 financial crisis
2. Bubbles: Irrational exuberance periods
3. Earnings shocks: One-time write-offs or gains
4. Calculation errors: Data quality issues
5. Structural changes: Corporate actions, rebalancing

These outliers skew averages significantly but have minimal impact on medians.

How Median Protects You

Resistance to Outliers

The median is the "middle" value when data is sorted. Extreme values at either end don't affect it:

Data: 10, 12, 13, 14, 15, 16, 17, 18, 19, 500
Average: 61.4 ❌ (distorted by 500)
Median: 15.5 ✅ (represents typical value)

Better Historical Context

When comparing current valuations to historical norms:

• Averages get pulled by crisis/bubble periods
• Medians reflect what's "typical" over time
• Your decision is based on more reliable benchmarks

Real-World Example: NIFTY 50

Let's look at actual NIFTY 50 P/E data from 2015-2023:

Using Average

• Includes 2020 COVID crash (P/E spiked to 40+)
• Includes 2021 bull run peak (P/E at 35)
• Result: Average heavily influenced by extremes
• Problem: Current P/E of 22 might seem cheap when it's actually fairly valued

Using Median

• Focuses on typical trading ranges
• Extreme periods have less impact
• Result: Median P/E around 20-21
• Benefit: Current P/E of 22 accurately assessed as slightly above normal

When Averages Still Matter

Medians aren't always superior. Averages are useful for:

1. Calculating returns: Total return over time
2. Financial planning: Expected values for projections
3. Normal distributions: When data doesn't have outliers
4. Accounting: Revenue, profit averaging

But for valuation benchmarking, median is king.

IndexPE Methodology

On our platform, we calculate medians across multiple timeframes:

1-Year Median

• Use: Short-term sentiment
• Captures: Recent market conditions
• Warning: May reflect temporary factors

3-Year Median

• Use: Medium-term baseline
• Captures: Business cycle phases
• Sweet spot: Balances recency with stability

5-Year Median

• Use: Full business cycle
• Captures: Bull and bear markets
• Reliability: High for most purposes

7-Year Median

• Use: Long-term valuation anchor
• Captures: Multiple cycles
• Best for: Understanding historical extremes

Practical Application

When you see on IndexPE:

"Current P/E: 22 | 7Y Median: 20 | +10% vs Median"

This tells you:

1. Not distorted by COVID crash or previous bubbles
2. Represents typical valuation over business cycles
3. 10% premium is meaningful, not noise
4. Informed decision: You understand if it's expensive or cheap

Statistical Robustness

From a statistics perspective:

• Median = 50th percentile: Half values above, half below
• Resistant estimator: Robust to data quality issues
• No assumptions: Doesn't require normal distribution
• Easy interpretation: Simple to understand and explain

Combining Both Metrics

Advanced users can look at both:

If Median < Average:
→ Distribution skewed by high outliers
→ Past bubbles or extreme optimism periods

If Median > Average:
→ Distribution skewed by low outliers
→ Past crashes or pessimism dominated

If Median ≈ Average:
→ Relatively symmetric distribution
→ Fewer extreme events

Conclusion

Medians provide a more reliable foundation for valuation analysis because they:

• Resist outlier distortion
• Represent typical conditions
• Enable accurate comparisons
• Support better decisions

Next time you evaluate if a market is overvalued or undervalued, ask yourself: "Am I comparing to average or median?" The answer could change your entire perspective.

---

Ready to use median-based analysis? Explore our dashboard to see current valuations compared to historical medians across all major Indian indices.

Disclaimer: This article is for educational purposes only. It does not constitute financial advice. Please do your own research or consult with a qualified financial advisor before making investment decisions.