mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > Math

Reply
 
Thread Tools
Old 2017-09-26, 17:21   #1
Bundu
 
Bundu's Avatar
 
Jul 2004
Mid Calder, Scotland

5×37 Posts
Default Normalising rent levels

Hi all,

I work in social housing. We have 13,000 properties. Over several decades for various reasons rents for properties have moved giving slightly different values for properties in some cases by a few pence to a few pounds. Across the properties this means there are hundreds of variations. My goal is to normalise rents based on number of bedrooms with the least possible movement.

Is there a mathematical way to solve this? Are there any formulas or methodologies that are geared towards this problem? I can write VBA so do the work once I know where to start (I think!). As this is social (low income) housing the least possible change to a single figure is the ideal outcome. While doing this I would need to ensure that the total weekly rent collected changes very little (no more than +3%) so we could achieve this during a rent increase period. Moving rent downwards would have less of a limitation.

Thank you in advance for any help you can give.
Bundu is offline   Reply With Quote
Old 2017-09-26, 17:58   #2
Uncwilly
6809 > 6502
 
Uncwilly's Avatar
 
"""""""""""""""""""
Aug 2003
101×103 Posts

271E16 Posts
Default

Can you supply some (fake) data and a small sample of what the outcome of the adjustments might look like? Are there other considerations other than rooms designed for sleeping (like total floor space, appliances provided, income levels of the occupants, number and type of bodies dwelling within, etc.)?

I suspect that you can define the variables and then seek to cluster those that share the same factors, then proceed to the adjustments. I would use looking at median and mean functions along with standard deviations to examine the groups and set the numbers.

This might be an iterative process over 2 or 3 rent increase periods.

Edit:
Does the local or national "poverty level" of income or "living wage" play into this? Taking that into consideration might also be worthwhile.

Last fiddled with by Uncwilly on 2017-09-26 at 18:02
Uncwilly is online now   Reply With Quote
Old 2017-09-26, 19:14   #3
Bundu
 
Bundu's Avatar
 
Jul 2004
Mid Calder, Scotland

B916 Posts
Default

Yes I can even post real rent values with anonymised identifiers. To answer your questions:

No the size of the actual rooms is not counted. Just the number of bedrooms (1,2,3,4 bedrooms. At this stage I don't think type of property would be a factor although if I can get a handle on an approach then I might factor in whether a property is flat / detached.. etc.

Local or customer incomes would not be relevant as the maximum rents are still within the scope of benefits designed for the most disadvantaged.

Should be able to post data in the next hour or two.
Bundu is offline   Reply With Quote
Old 2017-09-26, 19:56   #4
Bundu
 
Bundu's Avatar
 
Jul 2004
Mid Calder, Scotland

2718 Posts
Default

So I have isolated the set of 2 bedroom properties which is the largest at 5697 properties. All of the data has been stripped to the bare minimum and anonymised.

So in this set there are 696 unique rent values with a minimum of £55.96 and a max of £89.14
Attached Files
File Type: csv Book2.csv (97.6 KB, 109 views)
Bundu is offline   Reply With Quote
Old 2017-09-27, 06:14   #5
Uncwilly
6809 > 6502
 
Uncwilly's Avatar
 
"""""""""""""""""""
Aug 2003
101×103 Posts

2×3×1,669 Posts
Default

What if you follow the following basic idea?

If the rent is >1σ below the mean you exercise the max allowable increase.
For rents 1σ to 0.5σ below the mean, 1/2 of the max increase.
For rents 0.5σ above and below the mean, 1/3 or 1/4 max.
For rents >2σ above the mean, lower them to 2σ above the mean. (Drop this step for all following iterations.)

Those bottom few will take 10-15 periods to catch up. You can tune the values as you go. Start all new rentals (for a while) at 1σ above the mean.
By using σ you will draw the lower ones along.

Every period you can run the values and make adjustments to the zones and the proportion of the max allowable increase. Later on, it might just be that if they are below the average, they get moved up to the current average or a set figure. At some point they will all be close enough that you can just set them all to the same value.
Uncwilly is online now   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Racism or low light levels or...? jasong jasong 2 2016-09-25 05:07
Missing bit levels? NBtarheel_33 Data 6 2016-05-31 15:27
skipped bit levels tha PrimeNet 151 2016-03-17 11:38
Moving, need a house to rent flashjh Lounge 23 2013-03-05 15:28
Recommended TF bit levels for M(>10^8) NBtarheel_33 Math 19 2008-11-03 17:19

All times are UTC. The time now is 14:14.


Sun Oct 24 14:14:22 UTC 2021 up 93 days, 8:43, 0 users, load averages: 1.37, 1.31, 1.22

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.