Level 1Summarizing DataPractice, 2 min
MEDIAN
The task
One house is pricey enough to skew the average. In B7, find the median sale price.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Address | Sale price |
| 2 | 12 Elm | 310000 |
| 3 | 4 Oak | 275000 |
| 4 | 88 Ridge | 450000 |
| 5 | 9 Birch | 298000 |
| 6 | 31 Cedar | 330000 |
| 7 | Median |