{"id":1705,"date":"2008-03-13T14:06:10","date_gmt":"2008-03-13T21:06:10","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/"},"modified":"2014-09-09T07:33:00","modified_gmt":"2014-09-09T14:33:00","slug":"revisiting-the-median-price-sales-breakdowns","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/","title":{"rendered":"Revisiting the Median Price Sales Breakdowns"},"content":{"rendered":"<p>I think it&#8217;s a good time to revisit the median price discussion that <a href=\"http:\/\/seattlebubble.com\/blog\/2007\/08\/14\/median-price-not-telling-the-whole-truth\/\" title=\"Median Price Not Telling the Whole Truth\">I first brought up last August<\/a>.<\/p>\n<p>The median price is a decent indicator of the general direction of home prices, but it definitely has shortcomings.  The biggest problem is that the median is largely influenced by the mix of sales between high and low-value houses.  In a relatively stable housing market, when the mix stays somewhat constant, the median gives a fairly accurate picture of what&#8217;s going on with prices.  However, when sales of houses on one end of the price spectrum begin to drop or increase at a rate considerably faster than other price tiers, the median gets all screwed up.<\/p>\n<p>In order to investigate this phenomenon, we can break King County into three regions.  For a more in-depth explanation of this breakdown, refer to <a href=\"http:\/\/seattlebubble.com\/blog\/2007\/08\/14\/median-price-not-telling-the-whole-truth\/\" title=\"Median Price Not Telling the Whole Truth\">the original median price post<\/a>.<\/p>\n<ul>\n<li><strong>low end:<\/strong> South King<\/li>\n<li><strong>mid range:<\/strong> Seattle \/ North King \/ Vashon<\/li>\n<li><strong>high end:<\/strong> Eastside<\/li>\n<\/ul>\n<p>When <a href=\"http:\/\/seattlebubble.com\/blog\/2007\/08\/14\/median-price-not-telling-the-whole-truth\/\" title=\"Median Price Not Telling the Whole Truth\">we last checked in on this data<\/a>, sales on the expensive Eastside had surged up, leading to a misleadingly high county-wide median price.  Of course, that was July&#8217;s data, which was just before the tightening in the jumbo loan market.  As you would expect, starting in September, sales in the predominantly jumbo Eastside market dropped back down to normal and below-normal levels.<\/p>\n<p>Here&#8217;s the chart showing the percentage of county-wide monthly sales that each of the three regions has accounted for since January 2006:<\/p>\n<p style=\"margin: 5px auto; width: 600px; font-size: 0.8em; text-align: center\"><a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02.png\" title=\"Percentage of Sales by NWMLS Area - Click to enlarge\" rel=\"lightbox[1705]\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png\" style=\"border: 1px solid #000000; margin: 5px\" title=\"Percentage of Sales by NWMLS Area - Click to enlarge\" alt=\"Percentage of Sales by NWMLS Area\" height=\"436\" width=\"600\" \/><\/a><br \/>\ndashed line: 6 month rolling average | <a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02.png\" title=\"Percentage of Sales by NWMLS Area - Click to enlarge\" rel=\"lightbox[1705]\">Click to enlarge<\/a><\/p>\n<p>As a percentage of total county-wide sales, sales on the Eastside have dropped back down slightly, while sales in South King County have made a slight recovery from their lows of last summer.  Meanwhile, Seattle continues to grab a larger and larger percentage of sales, as the slowdown hits the outlying areas first (this can be observed in the <a href=\"http:\/\/seattlebubble.com\/blog\/category\/neighborhoods\/\" title=\"Seattle Bubble: Neighborhoods\">neighborhood breakdown posts<\/a> as well).<\/p>\n<p>You can also see that in recent months, there are a lot more dramatic spikes in the graph, as the mix of sales fluctuates somewhat rapidly.  Here&#8217;s a graph showing how far each region is deviating each month from its average share over the last six months:<\/p>\n<p style=\"margin: 5px auto; width: 600px; font-size: 0.8em; text-align: center\"><a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-deviation_2008-02.png\" title=\"Percentage of Sales by NWMLS Area: Deviation from 6-month Average - Click to enlarge\" rel=\"lightbox[1705]\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-deviation_2008-02-tn.png\" style=\"border: 1px solid #000000; margin: 5px\" title=\"Percentage of Sales by NWMLS Area: Deviation from 6-month Average - Click to enlarge\" alt=\"Percentage of Sales by NWMLS Area: Deviation from 6-month Average\" height=\"436\" width=\"600\" \/><\/a><br \/>\n<a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-deviation_2008-02.png\" title=\"Percentage of Sales by NWMLS Area: Deviation from 6-month Average - Click to enlarge\" rel=\"lightbox[1705]\">Click to enlarge<\/a><\/p>\n<p>I added the total YOY sales as a bar graph referenced to the right axis to demonstrate how much the declining sales volumes overall seems to be influencing the severe swings in the sales mix.  As the decline in sales becomes more severe, the mix is more volatile, which leads to a less meaningful median price.<\/p>\n<p>Here&#8217;s one more visual example of the problem with the median.  The pie charts below show the breakdown in sales in February 2007 and February 2008.<\/p>\n<p style=\"margin: 5px auto; width: 600px; font-size: 0.8em; text-align: center\"><a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/feb07-08-sales-shares.png\" title=\"Feb '07 &amp; Feb '08 Sales Breakdown - Click to enlarge\" rel=\"lightbox[1705]\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/feb07-08-sales-shares-tn.png\" style=\"border: 1px solid #000000; margin: 5px\" title=\"Feb '07 &amp; Feb '08 Sales Breakdown - Click to enlarge\" alt=\"Feb '07 &amp; Feb '08 Sales Breakdown\" height=\"276\" width=\"600\" \/><\/a><br \/>\n<a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/feb07-08-sales-shares.png\" title=\"Feb '07 &amp; Feb '08 Sales Breakdown - Click to enlarge\" rel=\"lightbox[1705]\">Click to enlarge<\/a><\/p>\n<p>In February 2007 the median price was $429,925, and was calculated from a pool of roughly 28% Eastside, 33% Seattle \/ N. King, and 39% S. King.  In February 2008, the median price was virtually unchanged at $429,900, but the pool was noticeably changed to 27% Eastside, 38% Seattle \/ N. King, and 35% S. King.  The Eastside made up nearly the same amount of the mix, but sales in low-priced South King County dropped faster than in Seattle, leading to an increase of five percentage points in Seattle&#8217;s share of the mix.<\/p>\n<p>I point all this out just to remind readers that the median price is deceiving.  Most likely, the price of homes in most parts of King County was not flat from February 2007 to February 2008 as the median price suggests, but was actually dropping.  However, with Seattle making up a larger percentage of the total homes sold, that fact is being masked.<\/p>\n<p>Unfortunately, looking at median prices for individual NWMLS areas (like we do for months of supply and inventory) wouldn&#8217;t be very instructive, since most areas have such a small number of sales and the median tends to fluctuate pretty wildly.  The only real way to get around this problem is to look at resales of the same houses, and compare the price to the previously sold price.  This is of course exactly what the Case-Shiller Home Price Index does, and again, I believe that February&#8217;s Case-Shiller data will indeed show a larger YOY decrease than the median.  I&#8217;m predicting it will show around -2% YOY.<\/p>\n<p>The bottom line here is that median prices are moderately useful as a broad gauge of market direction, but you shouldn&#8217;t put too much stock in the specific numbers.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I think it&#8217;s a good time to revisit the median price discussion that I first brought up last August. The median price is a decent indicator of the general direction of home prices, but it definitely has shortcomings. The biggest problem is that the median is largely influenced by the mix of sales between high&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,217],"tags":[841,149,6,200],"coauthors":[],"class_list":["post-1705","post","type-post","status-publish","format-standard","hentry","category-stats","category-neighborhoods","tag-king-geographic-sales","tag-median","tag-nwmls","tag-statistics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"I think it&#8217;s a good time to revisit the median price discussion that I first brought up last August. The median price is a decent indicator of the general direction of home prices, but it definitely has shortcomings. The biggest problem is that the median is largely influenced by the mix of sales between high...\" \/>\n<meta name=\"twitter:image\" content=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png\" \/>\n<meta name=\"twitter:creator\" content=\"@The_Tim\" \/>\n<meta name=\"twitter:site\" content=\"@SeattleBubble\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Tim\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/\",\"name\":\"Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png\",\"datePublished\":\"2008-03-13T21:06:10+00:00\",\"dateModified\":\"2014-09-09T14:33:00+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage\",\"url\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png\",\"contentUrl\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Revisiting the Median Price Sales Breakdowns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\",\"url\":\"https:\/\/seattlebubble.com\/blog\/\",\"name\":\"Seattle Bubble\",\"description\":\"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\",\"name\":\"The Tim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"caption\":\"The Tim\"},\"description\":\"Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer \/ internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.\",\"sameAs\":[\"http:\/\/SeattleBubble.com\/\",\"http:\/\/facebook.com\/is.totally.pointless\",\"https:\/\/x.com\/The_Tim\"],\"url\":\"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/","twitter_card":"summary_large_image","twitter_title":"Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble","twitter_description":"I think it&#8217;s a good time to revisit the median price discussion that I first brought up last August. The median price is a decent indicator of the general direction of home prices, but it definitely has shortcomings. The biggest problem is that the median is largely influenced by the mix of sales between high...","twitter_image":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/","url":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/","name":"Revisiting the Median Price Sales Breakdowns \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage"},"thumbnailUrl":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png","datePublished":"2008-03-13T21:06:10+00:00","dateModified":"2014-09-09T14:33:00+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#primaryimage","url":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png","contentUrl":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/03\/king-sales-breakdown_2008-02-tn.png"},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2008\/03\/13\/revisiting-the-median-price-sales-breakdowns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Revisiting the Median Price Sales Breakdowns"}]},{"@type":"WebSite","@id":"https:\/\/seattlebubble.com\/blog\/#website","url":"https:\/\/seattlebubble.com\/blog\/","name":"Seattle Bubble","description":"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f","name":"The Tim","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70","url":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","caption":"The Tim"},"description":"Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer \/ internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.","sameAs":["http:\/\/SeattleBubble.com\/","http:\/\/facebook.com\/is.totally.pointless","https:\/\/x.com\/The_Tim"],"url":"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6wh0F-rv","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/1705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/comments?post=1705"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/1705\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=1705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=1705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=1705"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=1705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}