Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
MEDIAN. MEDIAN(range) sorts the numbers and returns the middle one. With an even count it averages the two middle values. One very large value moves the AVERAGE a lot but barely moves the MEDIAN, so it describes a typical value better.
=MEDIAN(C2:C30) the middle delivery time in a shipments list
Priya Raman wants the typical order size for East in January. One big Oak Academy order pulls the average in G3 far above what most customers spend.
In G2, find the median of the order values in D2:D15. Don't round it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Value | East, January | |||
| 2 | 50005 | 2025-01-02 | River Dental | 207.03 | Median order | |||
| 3 | 50010 | 2025-01-03 | Maple Bakery | 194.50 | Average order | 353.28 | ||
| 4 | 50011 | 2025-01-03 | Beacon Hotels | 41.33 | ||||
| 5 | 50014 | 2025-01-06 | River Dental | 184.63 | ||||
| 6 | 50015 | 2025-01-06 | Harbor Labs | 42.75 | ||||
| 7 | 50027 | 2025-01-09 | Harbor Dental | 282.80 | ||||
| 8 | 50029 | 2025-01-09 | Maple Academy | 87.50 | ||||
| 9 | 50030 | 2025-01-10 | Oak Academy | 1,589.00 | ||||
| 10 | 50036 | 2025-01-13 | Atlas Realty | 829.85 | ||||
| 11 | 50057 | 2025-01-21 | Blue Motors | 930.75 | ||||
| 12 | 50069 | 2025-01-24 | Falcon Dental | 54.15 | ||||
| 13 | 50079 | 2025-01-28 | Harbor Studios | 138.00 | ||||
| 14 | 50081 | 2025-01-28 | Lakeside Studios | 237.70 | ||||
| 15 | 50082 | 2025-01-29 | Harbor Studios | 126.00 | ||||
| 16 | ||||||||
| 17 | ||||||||
| 18 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe