Why is MSI overall higher than any single price bucket?
Eagle-eyed agents may see that sometimes the Months Supply of Inventory (MSI) for a total region, as defined by the time series, is greater than (or smaller than) the MSI for any of the different price buckets in the Price Distribution chart. It's subtle, but it can happen.
The Months Supply of Inventory is defined as the number of active listings at the end of the month divided by the number of closed listings for that month.
For the time series calculations, and thus for the main metric box in Market Insights, this includes all listings in all price bands for the active inventory, and divides that by all closed listings in all price bands.
For the Price Distribution chart, it does the same math---except by price band. It divides all listings that were active at the end of the month in a defined price band by all listings that closed in that month in that defined price band.
The difference occurs when there are no closed sales in a particular/multiple price bucket but there were Active listings. The overall MSI will use those active listings in its calculation, when obviously the individual price buckets ignore all other price buckets.
Mother Nature gets very upset if we try to divide by zero. It's basically undefined. And that's okay. In this example, the Price Distribution chart isn't showing an MSI when there's no closed sales; that column is by definition undefined. So the MSI of the price buckets won't add up to the overall MSI.
You can validate this keeping the same selection filters, and changing the metric to Active Inventory (or End of Month Inventory). You'll see those active units appear and show you where the undefined infinite-weight MSI calculations were hiding!
Related Articles
Real-Time Months Supply vs. Smoothed Months Supply of Inventory (MSI)
You may have noticed that the Domus MSI often differs from the MSI on other reports, and you're correct. There's a very good reason for that, and it has to do with differences in calculation methodology. Domus uses a single month of closed sales to ...How the overall median close price can be up when individual area prices are down
Have you come across a situation where the overall median sold price is up, but the sold prices by geographic areas are down? Well, sometimes data looks weird, even when it's correct. This is one of those cases. The issue is rooted in the definition ...What's the blue band on MSI charts?
When you're using Market Review, you may notice a blue band on the Months Supply of Inventory (MSI) sparkline. That blue band represents the NAR definition of a balanced Market, which is between 5 and 7 months' supply of inventory. That same blue ...The difference between Median Price and Average Price
Median Price and Average Price are commonly reported metrics in the real estate market, but they are very different. Let’s step back to college statistics class to revisit them both, and learn why Median is preferred for housing prices. Average: the ...Price bands and Buyer markets
A common way to view real estate is by geographical markets. A less common but equally important way to view markets is by price band. Most every market can be broken up into 4 submarkets. We refer to them as Entry, Core, High End, and Luxury. It's ...