Bull Run Tallahassee PictureIf you haven’t taken part in our real estate web site survey, we’d love to get your feedback. To do so, please click on this link to take the survey. It takes about 1 minute and you can help us redesign this site to be more useful.

One reader provided an interesting observation about our graphing and charting techniques here on the Tallahassee Real Estate Web Site. This reader wanted to know why we relied so heavily on real estate one-year trend charts, as opposed to non-trended data graphs.

Specifically, the reader asked

So much of your data focuses on 365-day analysis. Given the dynamics of real estate today, it would be nice to have monthly information as well. I understand seasonality makes it hard to compare between months. But sometimes it’s just nice to know what is actually selling and what isn’t in the current market.

I am envisioning something like your inventory report, showing for the past month the number of condos/THs that sold and the number of single-family detached homes that sold. Sales data by price range and region (e.g. NE, NW, SE, SW) would be helpful too.

By the way, keep up the good work. In my opinion, this is the best RE site covering any metro region…at least the best free one.

This is great feedback and I will get more non-trended reports embedded into future blogs. But I also want to demonstrate the value of these trended results, with a real-world Tallahassee neighborhood report.

Bull Run Subdivision Home Sales Report

In order to demonstrate my perception of the value of the trend report, let’s take a look at arms-length home sales in the Bull Run Subdivision in Tallahassee, Florida. The graph below shows the number of homes sold each month, and the corresponding average prices of the homes sold that month.

Bull Run Subdivision Real Estate Graph

The information in this real estate graph shows the recent sales and prices, but do you get a real feel for what is occurring from this? Are sales up in Bull Run? Are sales down in Bull Run? What do you really see? If anything, I see a general downward trend on home prices, with a nice little “spike up” in the past three months. What do you see?

Home Prices Still Dropping In Bull Run Subdivision

This next real estate graph removes the seasonal bumps and jumps in the graph above by annualizing every point in the graph. To me, the results tell a much more focused picture.

Bull Run Subdivision Real Estate Graph In Tallahassee Florida

When I created these two real estate graphs, I had to look at them several times because I thought I had made a mistake. The first graph of Bull Run home sales seems to show a much more stable picture, while the second graph makes it appear as if Bull Run home prices are still dropping.

The problem with the first graph is that your mind (at least my mind) cannot do the math and factor in weighted averages of unit counts and average prices. For example, looking at the first graph, there were five sales of homes in Bull Run in July 2009 for less than $300,000. There was one sale for more than $300,000 in September of 2009.

On the first graph, it doesn’t really seem to catch your eye, but when we trend it, we realize what is really occurring in the Bull Run Subdivision. The average price trend has dropped 25% ($100,000) since the peak of the market! That message hits me right between the eyes in the trend graph, yet I would not have even noticed it in the first graph.

 

HousingReporter On Twitter Is The Top Twitter Real Estate Broker

Please click here to tweet this to your friends!

 

Historical Arms Length Home Sales In Bull Run Subdivision


[click to view list of past Bull Run Home Sales…]

 
This post has been included in Florida Information Leon County, FL Information Tallahassee, FL Information
Post is included in group: Realtors®
Post is included in group: Real Estate Trends
Post is included in group: Posts to Localism
Post is included in group: Market Reports
Post is included in group: Local Expert

10 Comments on A "No Bull" Approach To Real Estate Trends

OCT
21
327,438 Points 5 Featured Posts Outside Blog

Awesome stats and a one glance market snapshot. I wish you have one for the whole USA 

5:50am • #1
219,563 Points 8 Featured Posts Outside Blog

Thanks Fernando. Me too! One day I'll work towards that.

5:54am • #2
213,127 Points 34 Featured Posts Outside Blog

Joe,  Can you explain in more detail how you come up with the second graph?  Exactly what is the calculation you use to annualize each point?

6:51am • #3
219,563 Points 8 Featured Posts Outside Blog

Hey Tim, annualized just means that each point on the graph represents 365 days worth of information. For example, when we look at the unit sales figure for April 2009, it actually is showing the average number of monthly home sales from May 2008 through April 2009.

When we move to the next month, May 2009, it is showing the average number of sales from June 2008 through May 2009. In this way, we know that seaonality is not a factor, for each point shows all 12 months of the calendar year.

6:57am • #4
213,127 Points 34 Featured Posts Outside Blog

Thanks Joe,  So I guess it's the same as a 12 month moving average?

Just to be clear, for the annualized average price, do you take the average of the monthly averages?  Or do you multiply the number of units times the average price, add those values and divide by the total number of units for the past 12 months.  I would think you'd have to do the latter in order to give the high volume months more weight than the low volume months.

10:41am • #5

Thanks Joe.  Your 2nd graph is more appealing giving viewers an immediate recognizable trend.  I've been moving away from the polynomial form and running with a linear format instead. I especially like the overlay effect.  There's a slight uptick here also.  Next quarter should be the telltale.

3:27pm • #6
OCT
22
219,563 Points 8 Featured Posts Outside Blog

Hey Tim, great questions. Yes, "annualized" is a 12 month moving average. On many of my graphs, I have daily information (as opposed to weekly or monthly) so "annualized" gets the moving average to 365 days.

I absolutely do the real math to make sure high volume months (and days and transactions, etc.) are proporotionally represented in the results.

Your questions make me think you do these kinds of things as well!

5:12am • #7
219,563 Points 8 Featured Posts Outside Blog

Thanks Kevin. I'm hoping they get to see one, because they are doing much worse than the overall market.

5:13am • #8
213,127 Points 34 Featured Posts Outside Blog

Joe,  I do graphs like your first one for various areas around Atlanta.  Even with larger numbers, there's always a lot of "noise" in the numbers. With smaller number of sales in specific subdivisions it's very difficult to see trends.  I never thought above doing a moving average and also weighting for number of transactions for the various months.

What graphing software do you use?

10:00am • #9
219,563 Points 8 Featured Posts Outside Blog

Hey Tim. I do it all in Microsoft Excel.

3:18pm • #10

Leave a response…



(optional)
What does the graphic say?
 
Joefinal-withname Rainmaker_large

Joe Manausa - Tallahassee Real Estate

Tallahassee, FL

More about me…

Century 21 First Realty

Address: 1140 Capital Circle SE, Suite #12, Tallahassee, FL, 32301

Office Phone: (850) 386-2001 x 142

Cell Phone: (850) 508-1544

Email Me



Links

Archives

RSS 2.0 Feed for this blog

Find FL real estate agents and Tallahassee real estate on ActiveRain.