Calculate the arithmetic, geometric, and harmonic means of any data set. Perfect for statistical analysis, data science, academic research, and understanding central tendencies in your data.
Enter numbers to calculate all three means at once. Add as many values as you need. For geometric and harmonic means, all values must be positive.
Five students scored: 85, 92, 78, 95, 88 on a math test.
Arithmetic Mean = (85 + 92 + 78 + 95 + 88) รท 5 = 87.60
The average test score across all five students is 87.6 out of 100.
Annual returns: 1.10, 1.15, 1.08, 1.12 (10%, 15%, 8%, 12% growth factors).
Geometric Mean = (1.10 ร 1.15 ร 1.08 ร 1.12)^(1/4) = 1.1122 (11.22% average annual return)
The geometric mean gives the accurate average growth rate accounting for compounding.
A car travels at speeds 60, 45, 72, 55 km/h over four equal distances.
Harmonic Mean = 4 รท (1/60 + 1/45 + 1/72 + 1/55) = 56.25 km/h
The harmonic mean is the correct average when averaging rates over equal distances.
Five employees earn: $35K, $42K, $38K, $55K, $47K annually.
Arithmetic Mean = (35 + 42 + 38 + 55 + 47) รท 5 = $43,400
The arithmetic mean gives the typical salary, though outliers can skew it.
When your data doesn't have extreme outliers and you want the standard "average," use the arithmetic mean.
For investment returns, population growth, or any compounding data, the geometric mean gives the true average rate.
When averaging speeds, densities, or any rate over equal distances/units, the harmonic mean is mathematically correct.
Geometric and harmonic means require all values to be positive. Zero or negative values will result in undefined or imaginary results.
A mean is a measure of central tendency that represents a typical value in a data set. While most people are familiar with the arithmetic mean (the simple "average"), statisticians and data scientists use three different types of means โ arithmetic, geometric, and harmonic โ each suited to different types of data and applications.
The arithmetic mean is the sum of values divided by the count โ best for simple averages of raw data. The geometric mean is the nth root of the product of values โ essential for growth rates and ratios. The harmonic mean is the reciprocal of the average of reciprocals โ ideal for averaging rates. Understanding which mean to use is critical for accurate statistical analysis.
The type of mean you should use depends entirely on your data and what you're trying to measure. Use the arithmetic mean for simple averages where values are additive. Use the geometric mean for rates of change, investment returns, and any data that involves multiplication or compounding. Use the harmonic mean for rates like speed, density, or productivity where the data involves ratios with a common numerator. A useful rule: for any set of positive values, the harmonic mean is always the smallest, the geometric mean is in the middle, and the arithmetic mean is the largest.
Mean calculations are used across virtually every field. Here are some of the most common scenarios for each type of mean:
Arithmetic mean is used to calculate average test scores, GPA, and overall academic performance across multiple assessments.
Geometric mean calculates average annual returns, compound growth rates, and portfolio performance over multiple periods.
Harmonic mean is used to calculate average speed over multiple trips of equal distance, accounting for varying speeds.
All three means are used in different contexts โ arithmetic for measurement averages, geometric for growth rates, harmonic for rates and ratios.
Arithmetic mean for average revenue, geometric mean for average growth rates, harmonic mean for average productivity ratios.
Understanding when to use each mean is essential for feature engineering, normalization, and accurate statistical modeling.
=AVERAGE(range). Geometric mean = =GEOMEAN(range). Harmonic mean = =HARMEAN(range). For example, if your data is in cells A1:A10, use =AVERAGE(A1:A10) for the arithmetic mean. Note that GEOMEAN and HARMEAN in Excel will return errors if any values are zero or negative.
โ ๏ธ Important Note: While our Mean Calculator provides accurate mathematical results, always consider the nature of your data when choosing which mean to use. The geometric and harmonic means require all values to be positive. For data containing zeros, negative values, or outliers, the arithmetic mean may be the only valid option โ or you may need to consider the median instead. Verify critical statistical analyses with appropriate guidance.