Five people waited 4, 5, 6, 7 and 28 minutes. Put those waits in B2:B6. =MEDIAN(B2:B6) gives 6 and =AVERAGE(B2:B6) gives 10.

Read the middle position first

Sort a copy of the five numbers and find the third position. The 28-minute wait stays in the sample and affects the mean. In a short report, write “median 6 minutes, 5 waits, longest 28 minutes.”

The sorted waits are 4, 5, 6, 7 and 28 with median 6.

Illustrated odd-sample check.

Add an observation and recalculate

Put 8 in B7 and extend the median range. In order, the third and fourth values are 6 and 7, so the median is 6.5. Check that each input is a numeric measurement in minutes and that a recorded zero has a clear meaning.

After adding 8 minutes, the two middle waits are 6 and 7 and average to 6.5.

Illustrated even-sample check.

Related Microsoft Excel reference