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.
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.
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.
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.
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.
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.
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.