• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Sacramento Appraisal Blog | Real Estate Appraiser

Real estate appraisals for divorce, estate settlement, loans, property tax appeal, pre-listing and more. We cover Sacramento, Placer and Yolo County. We're professional, courteous and timely.

  • About
  • Appraisals
  • Order
  • Ask Ryan
  • Areas
  • Classes
  • Press
  • Trends
  • Share
  • Contact

How to spot shady real estate graphs

July 22, 2014 By Ryan Lundquist 8 Comments

If you don’t like what the numbers say, make them say what you want. That’s not okay, but it’s something that happens in politics, the business world, and even real estate. Do you know how to spot some of the shady tactics used to stretch the truth about numbers? Let me show you a few examples to help illustrate how small tweaks on a graph can make a big difference. I hope this will be interesting, but most of all I hope for some it will forever change the way you look at graphs. Comments and stories are welcome below.

1) SHADY TACTIC: The Y-Axis does not start at zero

fake trends - manipulated graph to show false trend - by sacramento appraisal blog

TRUTH: The market has seen a normal seasonal uptick this year, but overall it’s very flat right now – unlike what the graph above shows. Notice how I began the Y-axis at 250 instead of zero. There may be some good reasons to do that on occasion, but otherwise it’s a common tactic used when trying to make a trend look more dramatic than it actually is. Keep in mind the graph below shows the same data, but with a proper Y-axis.

median price trend - by sacramento appraisal blog

2) SHADY TACTIC: Compacting the second Y-Axis changed the trend

inventory in sacramento county 2 - by sacramento appraisal blog

TRUTH: Inventory actually increased by 10% during this time period, but it only looks flat because I included 20 months of housing supply on the Y-axis, which essentially flattened the trend. When you manipulate the Y-axis, it can help information look much more dramatic or change the trend altogether. The image below shows that inventory is actually increasing.

inventory in sacramento county - by sacramento appraisal blog

3) SHADY TACTIC: The X-axis only has a few months of data (too narrow)

sales volume in sacramento county - fake graph - manipulated to show false trend - by sacramento appraisal blog

TRUTH: Technically sales volume has increased since January, so this is sort of a half-truth. Rather than saying volume is increasing though, the real trend is seen when we compare last year with this year because sales volume is actually down by 14% this year. When we limit the X-axis to only a few months, it can really change what we see about the market.

sales volume in Sacramento County since 2008

4) SHADY TACTIC: Data without a context can look more powerful

REO Fake Trends - manipulated graph  in Sacramento County

TRUTH: It’s true the number of REO sales has seen an increase over the past three quarters as shown with the graph above, but we’re talking about an increase of 1.3% over 9 months when looking at the total percentage of REOs vs traditional sales. This underscores how important it is to look at numbers in context of the entire market. It’s easy to think REO sales have seen a dramatic increase when viewing them in isolation, but then we see the increase only constitutes 1.3% of the market, which isn’t much to write home about.

REOs and Short Sales Percentage and Volume in Sacramento County

5) SHADY TACTIC: Using quarterly or annual data to hide current trends

median price by quarter in sacramento county

Median Price in Sacramento County Annual

TRUTH: It’s definitely a good thing in real estate to look at quarterly and annual figures, and I do this all the time. But if we’re not careful, we can use larger sets of data to help obscure current trends. In the case above, the quarterly chart makes it look like values have increased the entire year in 2014, and the year-end annual stats makes it look like the market has done nothing but increase for a few years. However, when looking at monthly data below, we see a recent trend that the market has been flat for the past two months and it definitely had a lull at the end of 2013. This isn’t just about presenting data on graphs though because it’s easy to say things like, “We’ve seen incredible increases in value since 2013”, or “The median price has increased by 68% since we hit bottom in 2012”. Both statements are true and can be useful, but sometimes statements using older data are designed to help the market sound more glamorous than it is currently. Again, quarterly and annual stats are extremely valuable, but if monthly data is ignored because larger sets of data tells a more positive story, that’s not good.

median price by quarter in sacramento county 2

Ask yourself these questions when looking at a graph:

  1. Does the Y-axis start at zero? If not, why not?
  2. Does the X-axis show enough time or is it too limited?
  3. Does the Y-axis crunch data too tightly or broaden it too much?
  4. Is there enough data on the graph to be meaningful?

Action Step: Pay very close attention to graphs you see in newspapers, on television, and online. Ask the questions above so you can think critically about the way the numbers are being presented.

Question: Any insight, questions, or stories to share? I’d love to hear your take.

If you liked this post, subscribe by email (or RSS). Thanks for being here.

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related

Filed Under: Market Trends Tagged With: crunching numbers, examples of inaccurate data, Home Appraiser, interpretation, liar graphs, misleading graphs, real estate graphs gone wild, Sacramento Real Estate Market, using data to lie, X-axis, Y-axis

Reader Interactions

Comments

  1. riricardo says

    July 22, 2014 at 9:01 AM

    Excellent post. Makes me wonder why medians are used insted of averages for sales price.

    Reply
    • Ryan Lundquist says

      July 22, 2014 at 9:13 AM

      Thanks Ricardo. I had fun with this one. I hope it resonates with others too. Average price per sq ft and average sales price are also worth looking at. When we get locked into only one metric like median price, it can limit our view of the market.

      Reply
  2. Paul Crawford says

    July 23, 2014 at 3:38 PM

    One other important factor that’s very often left out of the discussion is sample size. If the sample is too small, data can be easily manipulated and misunderstood.

    Good post! This should help those who are reading and relying up appraisal reports to better understand the data that’s presented. When looking at graphs and data, context is key.

    Reply
    • Ryan Lundquist says

      July 23, 2014 at 5:01 PM

      Very true, Phil. I agree and I’m glad you brought that up. Sample size matters greatly. This is exactly why the median price in specific neighborhoods can be so sporadic from month to month. If there aren’t enough data points, it might look like the market was changing rapidly if someone took the figures to heart. Thanks for the comment and your kind words.

      Reply
  3. Ralph Valencia says

    July 25, 2014 at 10:19 AM

    I agree; I will actually look at ALL measures of central tendency, and even add a weighted average as opposed to just a straight average (arithmetic mean). Each stat by itself only has a limited meaning… when looking at the whole… things become much clearer.

    Medians will meausure whats right in the middle; so you have highs and lows on both ends.

    Means can be seriously affected by outliers. Imagine an area of $200k homes (say… 6) and you get that one low ball 7th sale at $100k. Your average is now ~$185k just by one outlier… your median would be $200k…

    Mode: The number that happens most frequently… this can be somewhat beneficial if you have a general sales price occurring a lot. This is usually better looked at as a range.

    Weighted Mean(Avg): Utilizing a range for mode.. you can see where most sales prices are occuring… giving primary weight there… it will lead you more toward the direction you should be trending.

    The science is above… but our judgement and ability to weigh in on trends and tendencies is what makes us appraisers, right?

    Great article Ryan… but you cant be giving away our secrets… lol

    Reply
    • Ryan Lundquist says

      July 25, 2014 at 11:13 AM

      Thanks so much. Your comments are always so thoughtful. I completely agree with your statement, “when looking at the whole… things become much clearer.” Hope you’re well.

      Reply
  4. Tom Horn says

    July 27, 2014 at 3:28 PM

    You do awesome graphs of your market Ryan and I’m glad you pointed out things that can skew the results. It is easy to make them say what you want to. Thanks for sharing your expertise.

    Reply
    • Ryan Lundquist says

      July 28, 2014 at 5:51 AM

      Thanks so much Tom. It’s amazing how easy it can be to skew the results by simply changing the parameters. One little fudge can create an entirely different trend. Keep up the great work on your blog!

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Instagram

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (407)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (476)
  • Photos from the Field (126)
  • Property Taxes (70)
  • Random Stuff (231)
  • Resources (566)
  • Videos (161)

Blog Archives: 2009 – 2021

Lundquist Appraisal Links

  • Appraisal Order Form
  • Appraisal Website
  • Rancho Cordova Appraiser Website
  • Sacramento Appraisal Blog Sitemap
  • Sacramento Real Estate Appraiser Facebook Page
  • Twitter: Sacramento Appraiser (@SacAppraiser)
  • YouTube: Sacramento Appraiser Channel

Most Recent Posts

  • My new sewer line adds huge value, right?
  • The housing market nobody predicted
  • Real estate trends to watch in 2021
  • You carried me & a spreadsheet for Christmas
  • Real estate drama (and a market update)
  • Goodbye California. Is everyone leaving?
  • How much are buyers paying above the list price?
  • What would happen to the housing market if we went on lockdown again?
  • Overpricing, multiple offers, & hot ranges
  • Why your home isn’t worth 16% more today

Disclaimer

First off, thank you for being here. Now let's get into the fine print. The material and information contained on this website is the copyrighted property of Ryan Lundquist and Lundquist Appraisal Company. Content on this website may not be reproduced or republished without prior written permission from Ryan Lundquist.

Please see my Sharing Policy on the navigation bar if you are interested in sharing portions of any content on this blog.

The information on this website is meant entirely for educational purposes and is not intended in any way to support an opinion of value for your appraisal needs or any sort of value conclusion for a loan, litigation, tax appeal or any other potential real estate or non-real estate purpose. The material found on this website is meant for casual reading only and is not intended for use in a court of law or any other legal use. Ryan will not appear in court in any capacity based on any information posted here. For more detailed market analysis to be used for an appraisal report or any appraisal-related purpose or valuation consulting, please contact Ryan at 916-595-3735 for more information.

There are no affiliate links on this blog, but there are three advertisements. Please do your homework before doing business with any advertisers as advertisements are not affiliated with this blog in any way. Two ads are located on the sidebar and one is at the bottom of each post. The ads earn a minor amount of revenue and are a simple reward for providing consistent original content to readers. If you think the ads interfere with your blog experience or the integrity of the blog somehow, let me know. I'm always open to feedback. Thank you again for being here.

Copyright © 2021 Sacramento Appraisal Blog