Geometric Mean Calculator

Calculate the geometric mean of any dataset — or find CAGR between a start and end value.

∏ Geometric Mean Calculator
Values (comma or line separated, all positive)

∏ What is Geometric Mean?

The geometric mean is a type of average that is calculated by multiplying all the values together and then taking the nth root (where n is the count of values). Unlike the arithmetic mean, which adds and divides, the geometric mean multiplies and takes a root — making it inherently suited for data that grows or compounds multiplicatively rather than additively.

The geometric mean is the correct average to use for percentage growth rates, investment returns, population growth, inflation compounding, and any quantity where you chain values by multiplication rather than addition. The classic example is investment returns: if a portfolio returns +50% in year 1 and −33.3% in year 2, the arithmetic average return is (+50 − 33.3) / 2 = +8.35%. But the actual result is 1.50 × 0.667 = 1.0, meaning the portfolio broke even. The geometric mean correctly gives 0% average growth: (1.50 × 0.667)^(1/2) − 1 = 0%.

A fundamental property of the geometric mean is the AM-GM inequality: the arithmetic mean is always greater than or equal to the geometric mean, which is always greater than or equal to the harmonic mean (AM ≥ GM ≥ HM). Equality holds only when all values are identical. This relationship is one of the most important inequalities in mathematics and appears in optimization problems, physics, and economics.

In finance, the geometric mean underpins CAGR — Compound Annual Growth Rate — which is the standard way to report long-term investment performance. In biology, it is used for antibody titres and microbial counts. In engineering, it appears in signal processing, noise calculations, and geometric progressions. This calculator handles both the general case (any list of positive values) and the specific CAGR application.

📐 Formula

GM = (x1 × x2 × … × xn)1/n
x1, x2, …, xn = the n positive values
n = the count of values
Equivalent form: GM = exp((ln x1 + ln x2 + … + ln xn) / n) — used computationally to prevent overflow
Example: GM of 4, 16, 64 = (4 × 16 × 64)1/3 = 40961/3 = 16
CAGR = (End Value ÷ Start Value)1/n − 1
n = number of years (or periods)
CAGR is the geometric mean of the annual growth factors minus 1.
Example: ₹1,00,000 grows to ₹1,61,051 in 5 years → CAGR = (1,61,051/1,00,000)1/5 − 1 = 1.10 − 1 = 10% per year

📖 How to Use This Calculator

Steps to Calculate Geometric Mean

1
Select a mode: "List of Values" for a general dataset, or "CAGR Mode" to find the compound annual growth rate between two investment values.
2
Enter your values. In list mode, type comma-separated positive numbers. In CAGR mode, enter the starting value, ending value, and number of years.
3
Click Calculate to see the geometric mean, arithmetic mean, and harmonic mean together. The AM-GM-HM relationship is shown as a verification note.

💡 Example Calculations

Example 1 — Geometric Mean of a Dataset

Find the geometric mean of 2, 8, 32

1
Product = 2 × 8 × 32 = 512  ·  n = 3
2
GM = 5121/3 = 8
Geometric Mean = 8  ·  AM = (2+8+32)/3 = 14  ·  HM = 3/(1/2+1/8+1/32) ≈ 4.92
Try this example →

Example 2 — CAGR of an Investment

Portfolio grows from ₹2,00,000 to ₹3,22,102 in 10 years

1
Total growth factor = 3,22,102 ÷ 2,00,000 = 1.611
2
CAGR = 1.6111/10 − 1 = 1.049 − 1 = 4.9% per year
CAGR = 4.9% per year  ·  Simple arithmetic average return = 4.8% (slightly different)
Try this example →

Example 3 — Average Annual Investment Return

Fund returns: +20%, −10%, +15%, +5% over 4 years (use growth factors as multipliers)

1
Growth factors: 1.20, 0.90, 1.15, 1.05
2
GM = (1.20 × 0.90 × 1.15 × 1.05)1/4 = 1.30410.25 ≈ 1.0686
3
CAGR ≈ 1.0686 − 1 = 6.86% per year  ·  Arithmetic average = (20−10+15+5)/4 = 7.5% — overestimates actual return
True average return = 6.86% (geometric). Arithmetic average of 7.5% is misleading.
Try this example →

Example 4 — AM-GM Inequality Demonstration

Values: 1, 4, 9, 16, 25 — verify AM ≥ GM ≥ HM

1
AM = (1+4+9+16+25) / 5 = 55 / 5 = 11
2
GM = (1 × 4 × 9 × 16 × 25)1/5 = 144000.26.87
3
HM = 5 ÷ (1/1 + 1/4 + 1/9 + 1/16 + 1/25) ≈ 3.00
AM (11) ≥ GM (6.87) ≥ HM (3.00) ✓ — AM-GM-HM inequality confirmed
Try this example →

❓ Frequently Asked Questions

What is the formula for geometric mean?+
Geometric Mean = (x₁ × x₂ × ... × xₙ)^(1/n). Take the product of all n values, then take the nth root. Computationally, it is equivalent to exp(mean of natural logs): GM = e^(Σln(xᵢ)/n). Example: GM of 4, 16, 64 = (4×16×64)^(1/3) = 4096^(1/3) = 16.
When should I use geometric mean instead of arithmetic mean?+
Use geometric mean for: (1) percentage growth rates and investment returns — chaining returns by multiplication; (2) ratios and index numbers; (3) data spanning many orders of magnitude (biological counts, sound levels). Use arithmetic mean for additive quantities — test scores, heights, temperatures. If in doubt: if your data combines by multiplication, use geometric mean.
What is the geometric mean of 2 and 8?+
GM = √(2 × 8) = √16 = 4. For two values, the geometric mean is always the square root of their product. The arithmetic mean is (2+8)/2 = 5, and the harmonic mean is 2/(1/2+1/8) = 3.2, confirming HM (3.2) ≤ GM (4) ≤ AM (5).
How is geometric mean used in finance?+
The geometric mean calculates CAGR (Compound Annual Growth Rate), the standard measure of long-term investment performance. If ₹1,00,000 grows to ₹1,61,051 over 5 years, CAGR = (1,61,051/1,00,000)^(1/5) − 1 = 10% per year. It correctly accounts for compounding, unlike arithmetic average return which can be misleading when returns vary year to year.
What is CAGR and how is it related to geometric mean?+
CAGR is the geometric mean of annual growth factors minus 1. If a fund returns +20%, −10%, +15%, +5% over 4 years, the geometric mean of (1.20, 0.90, 1.15, 1.05) = 1.0686, so CAGR = 6.86% per year. The arithmetic average of 7.5% is misleading — it ignores how the loss year compounds against a reduced base.
What is the difference between geometric mean and arithmetic mean?+
Arithmetic mean = sum ÷ count. Geometric mean = product^(1/n). AM is for additive data; GM is for multiplicative data. AM ≥ GM always (AM-GM inequality). For rates of return: +50% year 1, −50% year 2: AM = 0%, but GM = √(1.5 × 0.5) − 1 = √0.75 − 1 = −13.4% — you've lost money, which the arithmetic mean fails to show.
Can geometric mean be used for negative numbers?+
No. Geometric mean requires all values to be strictly positive. A zero makes the product zero; a negative makes the nth root complex. For investment returns expressed as percentages, convert to growth factors first (add 1: −10% → 0.90) — these are always positive, so geometric mean works correctly.
What is the geometric mean of 1, 2, 4, 8, 16?+
GM = (1 × 2 × 4 × 8 × 16)^(1/5) = 1024^(0.2) = 4. This is a geometric sequence with first term 1 and ratio 2. The geometric mean of a geometric sequence always equals the middle term — here the middle (3rd) value is 4. This is a fundamental property of geometric progressions.
How do I calculate geometric mean in Excel?+
Use =GEOMEAN(values_range). Example: =GEOMEAN(A1:A10). For CAGR: =(End/Start)^(1/Years)−1, e.g. =(B2/A2)^(1/C2)−1. GEOMEAN automatically handles large products using logarithms and ignores empty cells and text values.
What is the geometric mean used for in biology?+
Biology uses geometric mean for log-normally distributed data: antibody titre levels, microbial colony counts, and drug concentration-response data. When one patient has a titre of 20 and another has 2,000, the arithmetic mean of 1,010 is misleading. The geometric mean of √(20 × 2,000) = √40,000 ≈ 200 better represents the typical level on a multiplicative scale.