To simplify I want to assume the top 1% of earners will consider the top 1% of houses and so forth down to the bottom 1% of earners who will be assumed to pay the bottom 1% of house prices. To approximate this I compare the percentiles of the two distributions. Of course, this is all a gross oversimplification but it does provide a tractable starting point and the results are certainly interesting.
For the income data I used the ready prepared figures from an excellent Guardian article published last year. The data is available here. The details on how the data is 'equivalised' are all on the Guardian site and in the original source. Let's take a quick look at the percentiles of the income data:
The house prices took a little more work but fortunately the Land Registry has a complete record of house transaction prices. Here are the percentiles of their distribution between 2010-2011 (with the period chosen to match the income data):
To the naked eye the distributions look fairly similar and pretty much as we'd expect. To get a better sense of things we need to look at the ratios:
|Note: The 1% point is out of view at c. 23.|
As always, thanks for reading and I'd be grateful for your opinions!
For those interested please find the R code below or on github.