Map Extract
Free tool

Average calculator

Drop in a set of figures and see the four common averages side by side. Switch modes when some figures should count for more than others.

Runs in your browser. Nothing you enter is uploaded.

Example: what does a typical job really cost?

A kitchen fitter looks at the last six invoices to set a sensible starting quote: £1,250, £980, £1,430, £980, £2,100 and £1,175. Pasted as 1250 980 1430 980 2100 1175, the calculator returns a mean of 1,319.17 and a median of 1,212.5.

The one large job of £2,100 pulls the mean up. The median, the middle of the sorted list, is a fairer picture of a normal job. The mode is 980 because it appears twice, and the range of 1,120 shows how much the jobs vary.

Input
1250 980 1430 980 2100 1175
Result
Mean 1,319.17
Median 1,212.5
Mode 980
Range 1,120

Finding the averages

  1. Pick the type

    Mean, median and mode suits an ordinary set of figures; Weighted average is for pairs where each value has its own importance.

  2. Enter the numbers

    Put the figures on separate lines, or space them out; a comma counts as a divider when a space follows it. A comma followed by three digits is treated as a thousands separator, so 1,250 counts as one number, and symbols such as £ are ignored.

  3. Read the results

    The top row gives mean, median, mode and range; the second gives count, sum, smallest and largest. A note lists the numbers in order and says how often the mode appears.

Which average to use

AverageHow it is foundBest when
MeanAdd everything, divide by the countValues are fairly even with no extreme outliers
MedianThe middle value once sorted (or the midpoint of the middle two)A few very large or small values would distort the mean
ModeThe value that occurs most oftenYou want the most common figure, such as the usual order size
Weighted meanEach value times its weight, divided by the total weightSome items matter more, such as modules worth more credits

Questions people ask

How do I calculate a weighted average?

Multiply each value by its weight, add those products, and divide by the sum of the weights. In weighted mode, enter one pair per line, such as 65, 20. For 65 weighted 20, 72 weighted 30 and 58 weighted 50, the weighted average is 63.6, slightly lower than the plain mean because the lowest value carries the most weight.

What if there is no mode?

When every value appears exactly once, nothing repeats, so no mode is reported and the tool tells you that plainly. When two or more values tie for the most appearances, it lists them all under Modes, so a list can be bimodal or have several modes.

Will it read figures copied out of Excel?

Yes. Copying a column from Excel or Google Sheets gives one number per line, which the calculator reads directly. Currency signs and words around the figures are skipped, because the tool picks out the numbers themselves, but check that the count matches the rows you copied.

Where your data goes

All the arithmetic is carried out by this page in your browser. The figures you paste, such as prices or invoice values, are not transmitted or saved.

Checked against the tool on

Top