Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Real Estate & Property Intermediate

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.

8 lessons 8 labs 1.9 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Compare the mean and the median sale price of 20 Riverside sales and measure how two luxury sales skew the average.
  • Turn nine years of median prices into an index with 2020 = 100, calculate the year-over-year change and the annual growth rate, and chart the index.
  • Measure price growth from homes that sold twice: the log change of each pair, per year held, and the average annual growth rate.
  • Compare five regions by price-to-income ratio, monthly mortgage payment as a share of income, and the maximum price a median household could pay.
  • Calculate months of supply for each month, a smoothed figure using the 12-month sales pace, the absorption rate, and classify the market.
  • Measure how fast Hillcrest homes sell and how close they sell to the asking price.
  • Compare buying and renting in five regions with the price-to-rent ratio and a simple unrecoverable-cost rule.
  • Build the regional dashboard: price change, months of supply, the hottest region and a chart that compares the regions.

About this course

Housing headlines quote indices, affordability ratios and months of supply. This course shows how each one is calculated and what it really says. You see why reports prefer the median to the mean, build a simple price index with a base year and year-over-year change, and estimate price growth from homes sold twice using the repeat-sales idea. Affordability is measured with price-to-income and a mortgage payment ratio. Months of supply and absorption rate signal a seller's or buyer's market, and days on market and the sale-to-list ratio show buyer competition. You compare renting and buying across regions with price-to-rent and the unrecoverable-cost rule, and finish with a regional dashboard. For analysts, agents, journalists and students.

Curriculum

Course content

8 lessons · 8 labs · 1.9 h · final exam

  1. Median vs Mean Prices: Why Housing Reports Use the MedianLab12 min4 checked tasks
    Unlocked when you buy the course
  2. A Simple Price Index & Year-over-Year Change (Base Year = 100)Lab14 min4 checked tasks
    Unlocked when you buy the course
  3. The Repeat-Sales Idea: Same Home, Two Sales, Average Log ChangeLab15 min4 checked tasks
    Unlocked when you buy the course
  4. Price-to-Income & the Mortgage Affordability Ratio (PMT)Lab15 min4 checked tasks
    Unlocked when you buy the course
  5. Months of Supply & Absorption Rate: Seller's or Buyer's Market?Lab14 min4 checked tasks
    Unlocked when you buy the course
  6. Days on Market & the Sale-to-List RatioLab13 min4 checked tasks
    Unlocked when you buy the course
  7. Rent vs Buy across Regions: Price-to-Rent & the Unrecoverable-Cost RuleLab14 min4 checked tasks
    Unlocked when you buy the course
  8. Regional Housing Dashboard with a ChartLab15 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Real Estate & Property courses →
$9.99one-time payment
Buy course