Thursday, August 2, 2007

Dorchester Rental Stats

Working in the corporate world as part of the machinery that produced monthly sales and SIOP forecasts (for those of you foreign to the annoying acronyms commonly used in corporate America, it stands for Sales, Inventory & Operations Planning, I think. But then again many acronyms were made up by someone who wanted to keep their job functions somewhat secret)I became immensely familiar with Excel and all of it's wonderful functions. So today, after being interrogated by clients, both landlords and renters about the current rental market, I decided to put my analytical skills to good use.

Here is the data set- All rentals with the key word Dorchester posted on Craigslist-Boston. In addition I filtered out the mis-categorized apartments and removed any "rooms to share." I also had about 10-15 bad items that did not translate into Excel during the cut and paste function. That gave me approximately 280 records to manipulate. After texting to columns and cleaning it up I came up with the following. I love subtotals is the name of this game.

Average Price
1 Bed- $1097
2 Bed- $1354
3 Bed- $1448
4 Bed- $1804
5 Bed- $2200

Who is listing these?
By Owner- 149
By Broker fee- 69
By Broker no fee- 63

Number of X bedrooms apartments available
1 Bed- 48
2 Bed- 107
3 Bed- 96
4 Bed- 20
5 Bed- 10

Hopefully, I will get around to publishing this somewhat regularly.
Enjoy!

No comments: