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.571
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.2 ≈ 6.787
3
HM = 5 ÷ (1/1 + 1/4 + 1/9 + 1/16 + 1/25) ≈ 3.416
AM (11) ≥ GM (6.787) ≥ HM (3.416) ✓ - 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.
Tags: Geometric Mean Geometric Average Geometric Mean Calculator CAGR Calculator Compound Annual Growth Rate Calculator Formula Free Math Statistics

🔗 Related Calculators

∑
Average Calculator
Math - Basic
⟨⟩
Harmonic Mean Calculator
Math - Basic
⚖️
Weighted Average Calculator
Math - Basic
💹
Compound Interest Calculator
Finance - Investment
📊
CAGR Calculator
Finance - Investment
📈
SIP Calculator
Finance - Investment

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. Equivalently: GM = exp(mean of ln(values)). 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 rates or growth factors - average annual investment returns, population growth rates, inflation rates; (2) ratios - price/earnings ratios across companies; (3) quantities spanning multiple orders of magnitude - biological measurements, sound intensities. Use arithmetic mean for direct quantities like temperature, height, test scores.

What is the geometric mean of 2 and 8?

GM = √(2 × 8) = √16 = 4. The arithmetic mean is (2+8)/2 = 5. The harmonic mean is 2/(1/2 + 1/8) = 2/(5/8) = 3.2. As expected, HM (3.2) ≤ GM (4) ≤ AM (5).

How is geometric mean used in finance?

In finance, the geometric mean is used to calculate CAGR - the compound annual growth rate. If an investment grows from ₹1,00,000 to ₹1,61,051 over 5 years, the CAGR = (1,61,051/1,00,000)^(1/5) − 1 = 1.1^1 − 1 = 10% per year. The geometric mean of the annual growth factors (1.10 each year) is 1.10.

What is CAGR and how is it related to geometric mean?

CAGR (Compound Annual Growth Rate) is the geometric mean of annual growth factors minus 1. If an investment returns +20%, −10%, +15%, +5% over four years, the CAGR = (1.20 × 0.90 × 1.15 × 1.05)^(1/4) − 1 ≈ 7.0% per year. The arithmetic average of 20%, −10%, 15%, 5% is 7.5% - higher than CAGR because it ignores the compounding effect of the loss year.

What is the difference between geometric mean and arithmetic mean?

Arithmetic mean adds values and divides; geometric mean multiplies and takes the root. Arithmetic mean is correct for additive quantities (scores, lengths). Geometric mean is correct for multiplicative quantities (growth rates, ratios). For identical values, both means are equal. For different values, AM > GM always (AM-GM inequality).

Can geometric mean be used for negative numbers?

No, not directly. The geometric mean requires all values to be positive because taking the nth root of a negative product can yield complex numbers. For data sets including zeros or negatives, either the geometric mean is undefined, or you must apply a shift (add a constant to make all values positive) before computing.

What is the geometric mean of 1, 2, 4, 8, 16?

GM = (1 × 2 × 4 × 8 × 16)^(1/5) = 1024^(1/5) = 4. This geometric sequence has a common ratio of 2, so the middle value (4) is also the geometric mean - a defining property of geometric sequences.

How do I calculate geometric mean in Excel?

Use =GEOMEAN(values_range). Example: =GEOMEAN(A1:A5) for five values. GEOMEAN ignores empty cells and text. For CAGR: =(End_Value/Start_Value)^(1/Years)−1. Example: =(B2/A2)^(1/5)−1 gives CAGR over 5 years.

What is the geometric mean used for in biology and medicine?

In biology, geometric mean is used for antibody titres (immune response levels), bacterial counts, and drug concentration data - all log-normally distributed quantities where values span orders of magnitude. A geometric mean titre of 200 for an antibody is more representative than an arithmetic mean that would be skewed by a few very high responders.

📌 Quick Tips

💡The geometric mean requires all values to be positive. If any value is zero or negative, the geometric mean is undefined (you cannot take the nth root of a negative product).
💡For investment returns expressed as multipliers (1.10 for 10% gain, 0.90 for 10% loss), the geometric mean of the multipliers gives the exact average annual growth factor.
💡The AM-GM inequality guarantees: Arithmetic Mean ≥ Geometric Mean ≥ Harmonic Mean. Equality holds only when all values are identical.
💡CAGR (Compound Annual Growth Rate) is exactly the geometric mean of the annual growth factors over the investment period.
💡For two values a and b, the geometric mean is √(ab) - the geometric mean of 4 and 9 is √36 = 6.