{"id":3642,"date":"2008-12-10T14:52:46","date_gmt":"2008-12-10T22:52:46","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=3642"},"modified":"2008-12-10T14:52:46","modified_gmt":"2008-12-10T22:52:46","slug":"declining-appreciation-closely-tied-to-sales-volume","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/","title":{"rendered":"Declining Appreciation Closely Tied to Sales Volume"},"content":{"rendered":"

I was going back and updating some of my lesser-used spreadsheets today when I came upon one that I thought was particularly interesting. The graph below is an updated version of something I presented originally in the post Home Buying Demand vs. Price Changes<\/a> back in April.<\/p>\n

The chart below takes the year-to-year change in the single-family median home price as reported by the NWMLS and compares it to the persons per closed (SFH) sale, using the monthly Civilian Labor Force series from Workforce Explorer<\/a>. All of the data is for King County as a whole.<\/p>\n

\"YOY<\/a><\/p>\n

The green dots represent the period of increasing home price appreciation from July 2003 through January 2006, while the red dots are the data from January 2006 through November 2008, when home price appreciation has been on the decline. The unfilled white dots represent January 2000 through June 2003, when appreciation was in a state of fluctuation.<\/p>\n

There is no time-shifting in this chart, just the rolling averages to smooth out the noisy data sets. Here’s a plot of the raw data (thin dashed lines) and the rolling averages for each set:<\/p>\n

\"YOY<\/a><\/p>\n

To be honest, I’m not entirely sure what to make of this data. I realize that the last time I posted charts similar to these some folks railed into me (rightly so) for some statistical nonsense in a few of the charts. This time I have attempted to keep things simple, and I think the results are quite interesting.<\/p>\n

From what I can tell, there seems to be a very close relationship between the number of sales as a percentage of the population and the change in price. The strange thing to me is how different the slopes are on the red and green lines.<\/p>\n

I would postulate that the closely clustered white dots represent the relationship between sales volume and price changes in a “normal” or “balanced” market, while the dramatically-sloped green dots are a result of the out-of-whack mentality of the bubble market, and the red dots are the result of a correcting post-bubble market.<\/p>\n

So what do you think? I know there are quite a few readers out there that are more statistically-inclined than myself, and I’d love to have some of you download the data for yourself<\/a> and give me your take on it.<\/p>\n","protected":false},"excerpt":{"rendered":"

I was going back and updating some of my lesser-used spreadsheets today when I came upon one that I thought was particularly interesting. The graph below is an updated version of something I presented originally in the post Home Buying Demand vs. Price Changes back in April. The chart below takes the year-to-year change in…<\/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],"tags":[48,6,78,200],"coauthors":[],"class_list":["post-3642","post","type-post","status-publish","format-standard","hentry","category-stats","tag-demand","tag-nwmls","tag-population","tag-statistics"],"yoast_head":"\nDeclining Appreciation Closely Tied to Sales Volume \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\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Declining Appreciation Closely Tied to Sales Volume \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"I was going back and updating some of my lesser-used spreadsheets today when I came upon one that I thought was particularly interesting. The graph below is an updated version of something I presented originally in the post Home Buying Demand vs. Price Changes back in April. The chart below takes the year-to-year change in...\" \/>\n<meta name=\"twitter:image\" content=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/\",\"name\":\"Declining Appreciation Closely Tied to Sales Volume \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png\",\"datePublished\":\"2008-12-10T22:52:46+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage\",\"url\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png\",\"contentUrl\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Declining Appreciation Closely Tied to Sales Volume\"}]},{\"@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":"Declining Appreciation Closely Tied to Sales Volume \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\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/","twitter_card":"summary_large_image","twitter_title":"Declining Appreciation Closely Tied to Sales Volume \u2022 Seattle Bubble","twitter_description":"I was going back and updating some of my lesser-used spreadsheets today when I came upon one that I thought was particularly interesting. The graph below is an updated version of something I presented originally in the post Home Buying Demand vs. Price Changes back in April. The chart below takes the year-to-year change in...","twitter_image":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/","url":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/","name":"Declining Appreciation Closely Tied to Sales Volume \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage"},"thumbnailUrl":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png","datePublished":"2008-12-10T22:52:46+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#primaryimage","url":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png","contentUrl":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2008\/12\/price-change-vs-popsales_2008-11-600x435.png"},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2008\/12\/10\/declining-appreciation-closely-tied-to-sales-volume\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Declining Appreciation Closely Tied to Sales Volume"}]},{"@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-WK","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/3642","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=3642"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/3642\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=3642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=3642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=3642"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=3642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}