We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

PLEASE READ BEFORE POSTING: Hello Forumites! In order to help keep the Forum a useful, safe and friendly place for our users, discussions around non-MoneySaving matters are not permitted per the Forum rules. While we understand that mentioning house prices may sometimes be relevant to a user's specific MoneySaving situation, we ask that you please avoid veering into broad, general debates about the market, the economy and politics, as these can unfortunately lead to abusive or hateful behaviour. Threads that are found to have derailed into wider discussions may be removed. Users who repeatedly disregard this may have their Forum account banned. Please also avoid posting personally identifiable information, including links to your own online property listing which may reveal your address. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Housepricecrash.co.uk graph is an optical illusion

I saw this in a thread yesterday and thought I would highlight it.
The big blue graph on housepricecrash.co.uk starts at £50,000. Thus a quick glance at the blocks of blue make it look like the 2006 peak is twice as big as the 1990 peak. When in fact the 2006 peak is only 50% bigger.

Perhaps property is the correct price now, not everyone has been able to afford to buy a house. In the days of Maggie Thatcher houses were probably undervalued.
«13

Comments

  • zar
    zar Posts: 284 Forumite
    If you want to recreate that graph, go to http://www.nationwide.co.uk/hpi/historical.htm and select UK house prices adjusted for inflation, the data is provided as an excel spreadsheet and already has the graph on it. You can select the y axis and change the minimum to 0.

    The red trend line in nationwide's graph on the excel spreadsheet is a smoother determined by the data. It is very similar to an exponential growth model - you can see this for yourself by putting =GROWTH(C4:C131) into cell E4, then selecting cells E4 to E131 and pressing F2 followed by CTRL-SHIFT-ENTER (this is because it is an array formula). The numbers are pretty much the same as those in column C. (Maybe someone more geeky than me can tell me how they are really generated/why the numbers are slightly different.)

    That red trend line is £126k for Q4 2006, with the actual price £172k. But all this may mean is that exponential growth is a pretty rubbish model for real house prices. ;)
    :shhh: There's somewhere you can go and get books to read... for free!
    :coffee: Rediscover your local library! _party_
  • talksalot81
    talksalot81 Posts: 1,227 Forumite
    I assumed people in general would have checked that sort of thing - if you dont you havent much place making analysis of the data!

    In any case, whilst you are right that the severity of the graph is highlighted, the bottomline remains the same - current pricing is way above that which one would expect from models based on the long term.
    2 + 2 = 4
    except for the general public when it can mean whatever they want it to.
  • Paul_Herring
    Paul_Herring Posts: 7,484 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Photogenic
    Greed wrote:
    The big blue graph on housepricecrash.co.uk starts at £50,000. Thus a quick glance at the blocks of blue make it look like the 2006 peak is twice as big as the 1990 peak. When in fact the 2006 peak is only 50% bigger.
    http://faculty.washington.edu/chudler/stat3.html - Games with graphics section.
    Conjugating the verb 'to be":
    -o I am humble -o You are attention seeking -o She is Nadine Dorries
  • zar
    zar Posts: 284 Forumite
    Just because people should check things like that, doesn't mean that they do. Graphicacy and statistical literacy isn't as high as it should be - and not everyone who looks at HPC will be analysing the housing market in minute detail. Plotting the same data in a different way can be revealing, it can also be used to argue a different intention. For example, we could take that same nationwide data and plot the percentage overprice in the actual inflation-adjusted price to the exponential growth trend. (i.e. 100*(actualprice - trendprice)/trendprice)).

    graph-house-prices-1975-2006.gif

    4hsqgb4.jpg

    Now instead of dwarfing the last peak as presented in the HPC version, the current peak is a fairly similar height to the last one at the moment, and given the shape of the last trough it looks like it could stay flat or indeed get quite a bit higher (after all the previous peaks were quite a bit smaller than the 80s one). I would argue that the (real-price) crash doesn't look so imminent in the second graph as it does in the first, even though both are produced from the same data.
    :shhh: There's somewhere you can go and get books to read... for free!
    :coffee: Rediscover your local library! _party_
  • maninthestreet
    maninthestreet Posts: 16,127 Forumite
    Part of the Furniture
    It's known as 'Supressing the Zero' - the Y axis starts at 50,000 instead of 0.
    Often used with graphs, but at University I was taught this should never be used, at least not for anything science related.
    "You were only supposed to blow the bl**dy doors off!!"
  • Alan_M_2
    Alan_M_2 Posts: 2,752 Forumite
    zar wrote:
    Just because people should check things like that, doesn't mean that they do. Graphicacy and statistical literacy isn't as high as it should be - and not everyone who looks at HPC will be analysing the housing market in minute detail. Plotting the same data in a different way can be revealing, it can also be used to argue a different intention. For example, we could take that same nationwide data and plot the percentage overprice in the actual inflation-adjusted price to the exponential growth trend. (i.e. 100*(actualprice - trendprice)/trendprice)).

    graph-house-prices-1975-2006.gif

    4hsqgb4.jpg

    Now instead of dwarfing the last peak as presented in the HPC version, the current peak is a fairly similar height to the last one at the moment, and given the shape of the last trough it looks like it could stay flat or indeed get quite a bit higher (after all the previous peaks were quite a bit smaller than the 80s one). I would argue that the (real-price) crash doesn't look so imminent in the second graph as it does in the first, even though both are produced from the same data.

    I only see one graph, should there be something else there?

    Or am I being blinded by statistics again?

    EDIT: Oh another graph has snuck in since I last looked
  • talksalot81
    talksalot81 Posts: 1,227 Forumite
    zar wrote:
    Just because people should check things like that, doesn't mean that they do. Graphicacy and statistical literacy isn't as high as it should be - and not everyone who looks at HPC will be analysing the housing market in minute detail.

    Now instead of dwarfing the last peak as presented in the HPC version, the current peak is a fairly similar height to the last one at the moment, and given the shape of the last trough it looks like it could stay flat or indeed get quite a bit higher (after all the previous peaks were quite a bit smaller than the 80s one). I would argue that the (real-price) crash doesn't look so imminent in the second graph as it does in the first, even though both are produced from the same data.

    My concern is that if you are not statistically literate, you shouldnt be trying to discuss it! There are so many people out there spreading misinformation which is not intentional but is done out of ignorance.

    As for the graphs - it is not the y-axis shift which is making the difference to the arguement, it is the baseline (i.e. you translate it to be exponential). Without the baseline change, the £50k start pt makes little difference to the look.

    I think your interpretation is hopeful. The data itself shows no real evidence. This is of course not to say you are wrong, just it should not be predicted from that chart.

    Another point you should note. If we saw the same fall today as we did in the late 80s on the exp plot, prices would not decrease by £40k odds as they did back then, they would drop by more like £70k. So whilst the adjusted chart is much better for analysis, the real effects do need to be considered in terms of the initial chart.
    Often used with graphs, but at University I was taught this should never be used, at least not for anything science related.

    Never is far too strong. You shouldnt be doing it if you dont understand it. But if one never did it, we would never have entered the electronic age. Sciene particularly requires its use all the time. It is exceptionally common that the data of interest would be hidden with full scale.
    Alan_M wrote:
    I only see one graph, should there be something else there?

    Or am I being blinded by statistics again?

    I see two graphs... :confused:

    Admitted they are the same data mind you!

    I am pleased to read this thread because it confirms that some people do have an idea of good analytical technique!
    2 + 2 = 4
    except for the general public when it can mean whatever they want it to.
  • zar
    zar Posts: 284 Forumite
    My concern is that if you are not statistically literate, you shouldnt be trying to discuss it! There are so many people out there spreading misinformation which is not intentional but is done out of ignorance.

    As for the graphs - it is not the y-axis shift which is making the difference to the arguement, it is the baseline (i.e. you translate it to be exponential). Without the baseline change, the £50k start pt makes little difference to the look.

    I think your interpretation is hopeful. The data itself shows no real evidence. This is of course not to say you are wrong, just it should not be predicted from that chart.

    Another point you should note. If we saw the same fall today as we did in the late 80s on the exp plot, prices would not decrease by £40k odds as they did back then, they would drop by more like £70k. So whilst the adjusted chart is much better for analysis, the real effects do need to be considered in terms of the initial chart.

    I am pleased to read this thread because it confirms that some people do have an idea of good analytical technique!

    Thanks for your comments. :)

    I am a statistics student, so I'm not exactly the average ;) man in the street - and I'm pleased to see the thread too, although its probably not the people who wouldn't be able to analyse the graph who are reading, but never mind! :D

    I was just having a go at playing devils advocate with a different spin on the same data - I'm just starting my statistical career after all, and am still learning the ropes on how to mislead/influence people. :p I agree the pattern looks like there will be large falls in real terms, and also that the implied time span will be at least 10 years until prices are at their cheapest - if it is an inverted version of the 90s. But none of the previous booms and busts matched the previous one in scale or timeframe so predicting a bigger, longer boom (and a bigger bust?) this time is not a terrible prediction either.

    All the exponential model has done is tried to explain what has happened in the past as best it can. It isn't an economic or mathematical model considering household income, interest rates, number of property shows on TV and that kind of thing. And the blue HPC graph - like in the video on the HPC site where it asks what happens next <fall in real prices> vs <stagnation in real prices> - also invites you to assume the pattern will continue... look up a little, down a little, up a bit more, down a bit more, up a lot...

    If you are pretty sure you know what will happen next, you are using past statistics to make a prediction, something that many statisticans are reluctant to do. I'm actually pretty bearish on property, although I hestitate to say it as I don't want to invite the usual "oh no not another will there won't there be a HPC thread" comments. I'm as guilty as anyone of looking at these graphs and thinking I know what will happen next. That's the non-statistican in me though - the statistician in me would go "mmm" and "ahh" and say "weell... we don't really like to extrapolate you know..." and then scurry off before any more awkward questions are asked. :whistle:

    So returning to the OP... yes the graph may be misleading at a glance, but the information needed to interpret it is all there (y axis labels etc.) and there is nothing really wrong with zooming in on the area of interest if it is appropriate to do so. It is presented in a way that complements the site's views, as are any graphics in the media. The importance of people being able to cope with this is why the Royal Statisical Society campaigns for statistical literacy education in schools as something that all people need in modern day-to-day life.

    Being armed with such a graph without knowing how to use it can be dangerous. _pale_
    :shhh: There's somewhere you can go and get books to read... for free!
    :coffee: Rediscover your local library! _party_
  • cordial
    cordial Posts: 542 Forumite
    As far as this 'statistically illiterate' observer can see, house prices are definitely continuing to crash... upwards...
  • mystic_trev
    mystic_trev Posts: 5,434 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Combo Breaker
    cordial wrote:
    As far as this 'statistically illiterate' observer can see, house prices are definitely continuing to crash... upwards...

    Yep - good old House prices - always go up - never down!
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.1K Banking & Borrowing
  • 253.5K Reduce Debt & Boost Income
  • 454.2K Spending & Discounts
  • 245.1K Work, Benefits & Business
  • 600.7K Mortgages, Homes & Bills
  • 177.4K Life & Family
  • 258.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.