Average Calculator

Paste or type your numbers – from Excel, a table or a list – and the average calculator shows the mean, median, mode and range. For weights, choose “weighted average”.

Source: 1.3.5.1, NIST/SEMATECH e-Handbook – Measures of location: mean, median, mode, trimmed mean. Updated: .

separated by commas, spaces or new lines
My ToolboxYour inputs are saved in this browser only.

Result

Average (mean)
15.166667
Median
15
Mode (most frequent)
15
Minimum, maximum, range
11 to 20 (range 9)
Count and sum
6 values, sum 91
Geometric mean
14.842595
Harmonic mean
14.523227
Root mean square
15.486553
Working
  • Mean = sum ÷ count = 91 ÷ 6 = 15.166667
  • Sorted: 11, 12, 15, 15, 18, 20
  • Median = average of the two middle values = 15
Frequency table
ValueFrequencySharecumulative
11116.7%16.7%
12116.7%33.3%
15233.3%66.7%
18116.7%83.3%
20116.7%100%

How it is calculated

To calculate the average (mean), add all the numbers and divide by how many there are: (12 + 15 + 11 + 18 + 15 + 20) ÷ 6 = 91 ÷ 6 ≈ 15.17. The median is the middle value of the sorted list (15) and the mode is the most frequent value (15).

Mean, median or mode?

Weighted average

When values count differently, multiply each by its weight, add the products and divide by the sum of the weights: Σ(value × weight) ÷ Σ weights. Example: 3 lb at $2/lb and 1 lb at $6/lb average (3 × 2 + 1 × 6) ÷ 4 = $3/lb, not $4. For grades with credits use the GPA calculator.

Geometric and harmonic mean

Growth rates need the geometric mean (see the CAGR calculator); average speed over equal distances needs the harmonic mean: 60 mph out and 40 mph back average 48 mph, not 50. For positive numbers, harmonic ≤ geometric ≤ arithmetic ≤ root mean square. To see how spread out the data are, use the standard deviation calculator.

In Excel: =AVERAGE(A1:A10), =MEDIAN(…), =MODE.SNGL(…); weighted: =SUMPRODUCT(values,weights)/SUM(weights).

Missing value for a target average

Which number is still missing to reach a certain average? Choose “Missing value for a target average” above. The tool computes: target sum = target × new count, missing value = target sum − sum so far. Example: 12, 15, 11, 18, 15 and 20 add up to 91. For an average of 16 with a seventh value, the sum must be 16 × 7 = 112 – so 112 − 91 = 21 is missing. With several further values, the tool spreads the remainder evenly across them.

In list mode the frequency table shows every value that occurs with its count, share and cumulative share, so you can read off the mode and the median directly. For the middle between the smallest and the largest value, use the midrange calculator.

Frequently asked questions

How do you calculate the average?

Add all the values and divide by the number of values. For 4, 8 and 9: (4 + 8 + 9) ÷ 3 = 21 ÷ 3 = 7.

What is the difference between mean and median?

The mean is the arithmetic average; the median is the middle of the sorted list. For 1, 2, 3, 4, 100 the mean is 22 but the median is 3.

How do I calculate a weighted average?

Multiply each value by its weight, add the results and divide by the total weight: (2 × 1 + 3 × 2) ÷ 3 ≈ 2.67.

How do I find the mode?

Count how often each value appears; the one that appears most is the mode. A list can have several modes or none at all.

When should I use the geometric mean?

For factors and growth rates – investment returns or price increases over several years. It is the nth root of the product of the values.

What number do I need to reach a certain average?

Multiply the target average by the new number of values and subtract the sum you already have. For 80, 90 and 70 and a target of 85 with a fourth value: 85 × 4 − 240 = 100.

Sources and legal basis

As of: · Editorial policy

Related tools