How to Calculate the Median in Excel with MEDIAN

Open your Excel workbook (.xlsx) in Cue Office. Use =MEDIAN(B2:B7) to find the median delivery time and =AVERAGE(B2:B7) to compare it with the average. In this example, doubling the longest delivery time from 100 to 200 minutes leaves the median at 26 and raises the average from 40 to 60.

Calculate the median and average for five orders

Create a new spreadsheet in Cue Office, select cell A1, and paste the practice data. The delivery times for the five orders are in B2:B6, with B7 reserved for a sixth order. Cells E2 and E3 will hold the two formulas.

A blank spreadsheet with cell A1 selected in the top-left corner
Paste starting at A1 so the minute values land in column B.

Copy both lines below and paste them into E2. MEDIAN goes into E2 and AVERAGE goes into E3. Both formulas use B2:B7 and skip the blank B7 cell.

=MEDIAN(B2:B7)
=AVERAGE(B2:B7)

The five delivery times are 20, 24, 26, 30, and 100 minutes. In sorted order, 26 is the third value, so the median is 26 minutes. The five deliveries total 200 minutes. Divide by five to get an average of 40 minutes.

A five-order delivery sheet showing 26 in E2 and 40 in E3, with MEDIAN(B2:B7) displayed in the formula bar
Select E2 to check the range referenced by MEDIAN in the formula bar.

Change the longest time, then add a sixth order

Change B6 from 100 to 200. The middle value is still 26, and the average rises to 60. Here the median tells you how long the middle delivery took. The average tells you how much time each delivery would take if you divided the total time equally across them.

B6 displays 200, the median is 26, the average is 60, and the formula bar shows AVERAGE(B2:B7)
After changing the longest time, the median stays at 26 and the average rises to 60.

Enter D06 in A7 and 24 in B7. In the sorted list of six times, the middle two values are 24 and 26, so the median is their average, 25. The six deliveries total 324 minutes, giving an average of 54. Save and reopen the workbook. Check that E2 still shows 25 and E3 still shows 54.

Sheet including the sixth order D06 at 24 minutes, formula bar showing MEDIAN(B2:B7), with median 25 and average 54
Because the sixth order falls within the formula range, both formulas recalculate automatically.

Ask Cue AI to fill in E2 and E3

Start with a copy that contains the original five deliveries, including the 100-minute delivery. Leave E2 and E3 blank. On the Home tab, open Cue AI and send this prompt.

Cue AI is open on the Home tab. The five delivery times are in column B, and E2 and E3 are blank
Open Cue AI in a copy with the five original deliveries and blank cells E2 and E3.
Can you calculate the median and average delivery times for the data in column B? Put the median in E2 and the average in E3 so both update if I change a delivery time. Please leave the delivery data and labels unchanged.

Cue AI wrote formulas only in E2 and E3, using B2:B6, the range containing the five existing deliveries. Save and reopen the copy. Check that all five deliveries are still there and that the median is 26 minutes and the average is 40 minutes.

Reopened workbook with the original five deliveries and the MEDIAN formula for B2:B6. E2 is 26 and E3 is 40
After reopening the copy, the five original deliveries are still there. The median is 26 and the average is 40.

In the copy, change the existing 100-minute delivery to 200 minutes. Both cells recalculate: the median stays at 26 and the average rises to 60. If you add another delivery in B7, extend both formula ranges through B7.

Practice with the delivery records

Show the full example

Create a spreadsheet in Cue Office and paste the data into A1. B7 is blank, and E2 and E3 are ready for the formulas. Then return to the formula steps.

Delivery	Minutes		Metric	Minutes
D01	20		Median
D02	24		Average
D03	26
D04	30
D05	100

Explain the effect of the slowest delivery

In this example, changing D05 from 100 to 200 minutes left the median at 26 and raised the average to 60. Use both figures to show what changed. For your next batch, give Cue AI the time column, first and last rows, and the two result cells. Ask it to write the MEDIAN and AVERAGE formulas. Check that the range includes the last order. With an odd number of orders, verify the middle value. With an even number, average the middle two. If the median and average are far apart, start by checking the record for the longest delivery.

If you need to explain in a shift handoff why the slowest delivery raised the average, open the carrier’s PDF proof of delivery (.pdf) in Cue Office for free and compare the delivery confirmation time with your Excel log (.xlsx). Record the time you verified or the reason that still needs checking in a Word note (.docx). In the PowerPoint review deck (.pptx), put the median and average side by side with the slowest delivery time. Cue Office offers free spreadsheet, document, and presentation editing.

Download Cue Office for free