Housing Market Analytics: Price Indices, Affordability & Supply
Analyse a housing market like a research analyst: median vs mean prices, a price index with YoY change and CAGR, the repeat-sales idea, price-to-income and payment-to-income affordability, months of supply, days on market, sale-to-list, rent vs buy and a regional dashboard with charts: 8 graded labs on synthetic data. Educational only, not investment advice.
The first lesson is free — no account needed.
About this course
A housing market analytics course that reads a housing market the way a research analyst does, on synthetic sales data in a spreadsheet, for real estate analysts, economics students and homebuyers who read market reports. You compare the mean and the median sale price and measure how two luxury sales skew the average, turn nine years of median prices into an index with 2020 = 100, the year-over-year change and the annual growth rate, estimate growth from homes that sold twice with the average log change, compare regions by price-to-income ratio, mortgage payment as a share of income with PMT and the maximum affordable price, calculate months of supply and the absorption rate, measure days on market and the sale-to-list ratio, weigh renting against buying with the price-to-rent ratio and the unrecoverable-cost rule, and build a regional dashboard. Educational only, not investment advice. The first lab is free.
Lessons
- Median vs Mean Prices: Why Housing Reports Use the MedianFree
- A Simple Price Index & Year-over-Year Change (Base Year = 100) Pro
- The Repeat-Sales Idea: Same Home, Two Sales, Average Log Change Pro
- Price-to-Income & the Mortgage Affordability Ratio (PMT) Pro
- Months of Supply & Absorption Rate: Seller's or Buyer's Market? Pro
- Days on Market & the Sale-to-List Ratio Pro
- Rent vs Buy across Regions: Price-to-Rent & the Unrecoverable-Cost Rule Pro
- Regional Housing Dashboard with a Chart Pro