Geometric Mean Calculator
Calculate the geometric mean of any set of positive numbers. Enter how many values you have, type them in, and get the n-th root of their product instantly — ideal for growth rates, ratios, and returns.
Calculate the Geometric Average of Numbers
Geometric Mean Formula
Where:
- \(x_1, x_2, \ldots, x_n\) — the individual values (all must be positive and non-zero)
- \(n\) — the number of values
- \(GM\) — the geometric mean
The formula multiplies all \(n\) values together and takes the \(n\)-th root of the product. An equivalent form often used with logarithms is \( GM = \exp\!\left( \frac{1}{n} \sum_{i=1}^{n} \ln x_i \right) \), which is how spreadsheets compute it for large data sets.
Geometric Mean – Calculation Example
Example: find the geometric mean of 10 and 20 (the calculator's default values).
\[ GM = \sqrt[2]{10 \times 20} = \sqrt{200} \approx 14.14 \]
Result: the geometric mean is 14.14. Note that the arithmetic mean of the same numbers is 15 — the geometric mean is always less than or equal to it.
How to use the calculator
- Enter the Number of values you want to average (minimum 2). Additional input fields appear automatically.
- Type your numbers into the fields Number 1, Number 2, and so on. Every value must be positive and non-zero.
- Read the Average field — it shows the geometric mean of all entered values.
- Use the reset button to clear the form and start over with a new data set.
What is the geometric mean?
The geometric mean is a measure of central tendency based on multiplication rather than addition. Instead of adding the values and dividing by their count (as the arithmetic mean does), it multiplies the values together and takes the n-th root of the product. It answers the question: if all values were equal, what single value would produce the same product?
Because it works multiplicatively, the geometric mean is the correct average for quantities that compound: growth rates, interest rates, percentage changes, ratios, and index numbers. For example, if an investment grows by 10% one year and 20% the next, the equivalent constant annual growth rate is the geometric mean of the growth factors \(1.10 \times 1.20\), not the arithmetic mean of the percentages.
The geometric mean is always less than or equal to the arithmetic mean, and the gap widens as the data becomes more spread out. It also dampens the effect of a single extreme value: one very large number inflates an arithmetic mean dramatically, but pulls the geometric mean up far less. This makes it a standard tool in finance (portfolio returns over multiple periods), biology (population growth rates, bacterial cultures), and geometry (the altitude of a right triangle is the geometric mean of the segments it creates on the hypotenuse).
Geometric vs. arithmetic vs. other means
| Mean | Best for | Example (2, 8) |
|---|---|---|
| Arithmetic | Additive data: sums, counts, temperatures | 5 |
| Geometric | Multiplicative data: rates, ratios, growth | 4 |
| Harmonic | Rates over fixed distances: speeds | 3.2 |
| Quadratic (RMS) | Varying quantities: error, voltage | 5.83 |
If your data involves weights, use the Weighted Mean calculator; for rates and speeds, see the Harmonic Mean or Quadratic Mean (RMS) calculators.
Limitations and practical tips
- All values must be positive. The geometric mean is undefined for zero and negative numbers — the calculator will show an error if you enter one. If your data contains negative percentage changes, convert them to growth factors first (e.g. −5% becomes 0.95).
- Use it only for multiplicative data. For quantities that add up — prices, heights, test scores — the arithmetic mean is the appropriate choice.
- Convert percentages correctly. Never average the percentages directly. A 10% loss followed by a 10% gain is not break-even: the geometric mean of 0.90 and 1.10 is ≈ 0.995, a small net loss.
- Large data sets. The product of many values can overflow simple arithmetic; in such cases the logarithmic form of the formula is used, which is also handy for manual checks with the Nth Root calculator.
Frequently Asked Questions
How do I calculate the geometric mean by hand?
Multiply all your values together, then take the n-th root of the product, where n is how many values you have. For example, with 4, 10, and 25: \(4 \times 10 \times 25 = 1000\), and \(\sqrt[3]{1000} = 10\). For two numbers there is a shortcut: \(GM = \sqrt{ab}\), which is also the side length of a square with the same area as a rectangle \(a \times b\).
Can the geometric mean be calculated with negative numbers or zero?
No. Zero makes the whole product zero, and negative values produce roots that are undefined or meaningless in the real numbers. If your data are percentage changes, convert them to growth factors first: −5% becomes 0.95 and +10% becomes 1.10. If the underlying quantities are genuinely negative (like temperatures in °C), the geometric mean simply does not apply — use the arithmetic mean instead.
Why is the geometric mean always lower than the arithmetic mean?
This follows from the AM–GM inequality: for any set of positive numbers, \(\sqrt[n]{x_1 x_2 \cdots x_n} \le \frac{x_1 + x_2 + \cdots + x_n}{n}\). The two means are equal only when all values are identical. The more spread out your data, the bigger the gap — the arithmetic mean is pulled upward by large outliers, while the geometric mean stays closer to the typical value.
When should I use the geometric mean instead of the arithmetic mean?
Use the geometric mean when values multiply or compound: investment returns across periods, population growth rates, ratios, percentage changes, and index numbers. Use the arithmetic mean when values add up: prices, heights, test scores, or total quantities. A quick test: if doubling one value should double the result, the quantity is multiplicative and the geometric mean is the right choice.
How do I find the average annual growth rate (CAGR) with this calculator?
Convert each period's return to a growth factor (1 + rate), enter the factors, and the geometric mean gives the equivalent constant growth factor per period. Subtract 1 and multiply by 100 to express it as a percentage. For example, factors 1.10 and 1.20 give \(GM \approx 1.1489\), meaning an average growth rate of about 14.9% per year.
How do I calculate the geometric mean in Excel or Google Sheets?
Both spreadsheets have a built-in GEOMEAN function: type =GEOMEAN(A1:A10) for a range of positive numbers. Excel also offers GEOMEAN for weighted data via array tricks, but the standard function assumes equal weights. The spreadsheet internally uses the logarithmic method, computing \(\exp(\text{AVERAGE} \text{ of } \ln x)\), which avoids overflow when your data set is large.
What are common mistakes when averaging percentages or returns?
The biggest error is averaging percentages directly. A 50% loss followed by a 50% gain is not break-even: the factors 0.50 and 1.50 give \(GM = \sqrt{0.75} \approx 0.866\), a 13.4% net loss. Also avoid mixing signs — always convert to factors first. Finally, remember past performance does not guarantee future results; the geometric mean describes history, not what an investment will do next.