Loading the sales data…

Question 1

Which city has the highest median sale price?

Calculating city medians from valid sale prices…

Median sale price by city

Valid prices only: $10,000-$5,000,000, inclusive

Question 2

Using all rows, which city's mean sale price is furthest above its median?

Calculating means and medians from all sale prices…

Mean and median sale price by city

Every recorded sale price is included; bars share one dollar scale

The gap percentage is (mean − median) ÷ median × 100. Dollar amounts are shown to the nearest cent where needed.