From the archive

Task:

You handle market reports for a real estate office. Last month's closings in one neighborhood include a five-bedroom estate that sold for far more than anything else nearby, and averaging it in with the other four sales would overstate what a typical buyer actually paid there — so the report calls for the median price instead. It also wants the bedroom count that shows up most often among homes that sold, since that tells buyers what's actually on the market at that price point. In B7, use MEDIAN to find the typical closing price from B2:B6. In B8, use MODE to find the most common bedroom count from C2:C6.