Geometric Mean Calculator

This calculator instantly computes the geometric mean of any set of numbers. While the geometric mean only works on positive values, this calculator also supports datasets with negative values. If you enter a dataset with negative values, the calculator automatically treats them as percentage changes, converts them into ratios, and then computes the correct geometric mean.

This makes this tool ideal for analyzing investment returns, growth rates, and percentage changes over time.

Want to learn how to calculate the geometric mean manually? The calculator also provides a step-by-step explanation showing you how the geometric mean was calculated for your dataset.

How to Use the Geometric Mean Calculator

Struggling to find the geometric mean using our calculator? Follow these simple steps for accurate results:

1. Select the calculation mode
   • Use the standard values mode when all the numbers are positive
   • Use the percentage changes/returns mode when all values in your dataset represent percentages.
2. Enter the dataset in the data input field.
   • You can either type the numbers while separating them by commas, spaces, or tabs.
   • If the data is too huge to type manually, you can copy and paste directly from Excel
3. Click Calculate

The calculator will instantly return the correct geometric mean based on the calculation mode you selected. You can also expand the step-by-step explanation section to see how the geometric mean was calculated for your dataset.

💡Tip. You’ll find yourself using the standard values mode since the geometric mean was designed to work for positive values.

What is the Geometric Mean?

The geometric mean is a type of average that is calculated by multiplying all values in a dataset and then taking the n^th root of the product. In this case, n is the number of observations in the dataset.

The geometric mean formula is $GM = \left( x_1 \times x_2 \times x_3 \times \cdots \times x_n \right)^{\frac{1}{n}}$

Where:

• n is the sample size (number of observations in the dataset)
• x₁, x₂,…, x_n are the data values in the dataset.

Unlike the arithmetic mean, which sums all the values and divides the results by the total number of observations, the geometric mean finds the product of all the values in the dataset and takes the n^th root of the results.

Therefore, the geometric mean is very useful for datasets that are multiplicative in nature. As such, it is popular when working with exponential growth, ratios, or compound interest rates.

Geometric Mean Formula

The geometric mean is calculated by multiplying all values in a dataset and then taking the nth root of the product. This approach makes it ideal for data involving growth, ratios, and compounding.

The standard geometric formula is $GM = \left( \prod_{i=1}^{n} x_i \right)^{\frac{1}{n}}$

Where:

• x_i​ = each value in the dataset
• n = total number of values in the dataset
• $\prod$ is the product symbol

The formula is sometimes written in expanded form as $GM = \left( x_1 \times x_2 \times x_3 \times \cdots \times x_n \right)^{\frac{1}{n}}$. This formula works perfectly when all the values in your dataset are positive.

However, for larger datasets or when dealing with very large or very small numbers, the geometric mean can be computed using the logarithmic geometric mean formula.

The formula is $GM = \exp\left( \frac{1}{n} \sum_{i=1}^{n} \ln x_i \right)$. This formula is widely used in statistics and computing because:

• It prevents overflow or underflow when multiplying many values
• It is computationally more stable for large datasets
• It simplifies calculations by converting multiplication into addition

How to Calculate the Geometric Mean For Positive Values

Want to learn how to compute the geometric mean manually? Follow these simple steps:

1. Multiply all the observations in the dataset
2. Count the total number of observations in the dataset to get n
3. Take the nth root of the product of all values in the dataset to get the geometric mean

Example 1

A researcher records the growth factors of a bacterial culture over four time periods: 3, 6, 12, and 24. Find the geometric mean.

Solution

Step 1. Multiply all values

3×6×12×24 = 5184

Step 2. Count the number of values

There are 4 observations in the dataset. Thus, n = 4

Step 3. Take the n^th root

Since n = 4, we need to take the 4^th root of the product.

Therefore, $GM =\sqrt[4]{5184}$

=$5184^{\frac{1}{4}}$

= 8.4853.

How to Calculate the Geometric Mean for Negative Values

The geometric mean is designed to work with positive values only. However, in real-world situations, you may encounter negative values, especially when working with percentage changes such as growth rates or investment returns.

In such cases, you need to first convert the values into ratios before computing the geometric mean. Here are the complete steps you should follow to find the geometric mean of a dataset with negative values:

1. Convert each percentage value into a ratio
2. Multiply all the converted ratios
3. Count the total number of observations to get n
4. Take the n^th root of the product
5. Convert the result back into a percentage

Example 2

A company records its monthly growth rates as: -5%, 12%, -8%, and 6%. Find the geometric mean growth rate.

Solution

Step 1. Convert percentages to ratios

To convert percentages to ratios, subtract negative values from 100% and add 100% to positive values. You should then convert the results into decimals. Here, you can do it manually or use the percentage to decimal calculator.

In our case, the results will be as follows:

• -5% → 0.95
• 12% → 1.12
• -8% → 0.92
• 6% → 1.06

Step 2. Multiply all values

The product of all values is: 0.95×1.12×0.92×1.06

=1.0352

Step 3. Count the number of values

There are 4 observations in the dataset. Thus, n=4

Step 4. Take the n^th root

Since n=4, take the 4th root.

Thus, $GM =\sqrt[4]{1.0352}$

=1.0087

Step 5. Convert back to a percentage

1.0087 suggests that there was a percentage increase. Thus, to convert back to the percentage increase, we subtract 1 from the results and multiply by 100.

That’s, 1.0087−1= 0.0087

= 0.87%

Therefore, the geometric mean growth rate is 0.87%

NOTE. You should always treat negative values as percentage changes and convert them into ratios. This ensures the geometric mean correctly reflects the true compounded growth rate.

When to Use the Geometric Mean

The geometric mean is the most appropriate average when your data involves growth or proportional change rather than simple addition.

As such, you should use the geometric mean when:

• You are analyzing investment returns over time
• You are working with percentage changes (e.g., growth rates)
• Your data represents growth or decay processes
• Values are expressed as ratios or index numbers
• You need a compounded average that reflects real change

In these situations, the geometric mean provides a more accurate result than the arithmetic mean because it accounts for compounding effects.

Advantages of the Geometric Mean

The geometric mean offers several important benefits:

• It accurately reflects compounded growth
• It reduces the influence of extreme values
• It provides a true average rate of change

Limitations of the Geometric Mean

Despite its usefulness, the geometric mean has some limitations, which include:

• It cannot include zero values (product becomes zero)
• It cannot directly include negative numbers
• It requires transformation for percentage data
• It is less intuitive than the arithmetic mean