Lies, Damn Lies, And Statistics: What Mark Twain and Benjamin Disraeli Would Say About Menlo Park’s Median Price Numbers
January 16, 2008
Mark Twain, it seems, merely popularized, but did not actually coin the phrase Lies, Damn Lies, and Statistics. That honor belongs to none other than the British statesman Benjamin Disraeli, the first Earl of Beaconsfield, KG, PC, FRS. (With all these acronyms after his name, one wonders if he may have been the first Realtor!)
I’ve ranted not infrequently about how real estate is local, local, local. What nationwide, statewide, or countywide prices are doing may or may not reflect your city. The overall trends in your city may not be a good indicator of your particular neighborhood.
And that’s where Benjamin Disraeli’s famous quote come in. You can make numbers tell whatever story your bias prefers.
The story I’m about to tell is hyperlocal if ever there was one. If you’re not in this immediate area, the lesson for you is not in these specific numbers, but in the notion that you have to understand your local market.
Here, for instance, is a pretty bad story to tell, and it appears that the story, as told by the great numerical storytellers of Altos Research, is quite simple: home prices in Menlo Park are in freefall, with the median having dropped from an all-time high of $1.65M in mid-2005 to a current $875K-ish. 2007 prices have — apparently — dropped by 30%:

That story just doesn’t make sense to me, however. The marquee towns up and down the Peninsula — those with good schools and their associated high prices — have actually done quite well over the last year. Why would Menlo Park be any different?
Palo Alto: Median prices mostly up last year, with a retreat in the latter part of the year, and signs of another season upsurge upon us…
Los Altos: An incredible run-up in prices, again with a dip last year, and again with a sign of a revival this year…
Los Gatos: A rise last year, though not as much as the other towns, and a pullback in prices in the latter part of the year…

You get the picture. Why then is Menlo Park so different? Have prices really dropped by 30%?
The answer? Most emphatically not!
In fact, take a look at these numbers, pulled from our local MLS. Of the twelve Menlo Park neighborhoods, only two of them had median prices go down in 2007 — and then only by 2-3%. Other neighborhoods saw medians rise from 5.6% (Flood Park) to 35.6% (Alpine Road Area.) The following graph shows the percentage change in median prices from 2006 to 2007.

How can both of the following two facts be true?
- Median home prices in Menlo Park have dropped by 30%
- Median home prices in 10 of 12 Menlo Park neighborhoods have risen, while median home prices in the remaining 2 neighborhoods have fallen, but only modestly.
The answer, Mssrs. Disraeli and Twain, lies in a different statistic: the amount of inventory on the market. Take a look at the story told in this graph, which shows the number of homes sold per year by neighborhood:
The sheer amount of data in this graph, and its size, makes it hard to read. The key points: the number of home sales in Menlo Park in 2007 was just over 400 — significantly lower than the wild years of 1999, 2004, and 2005. The number of homes in the “East of US 101″ neighborhood — the least expensive one – however, increased dramatically. The average number of annual sales in that neighborhood is 36, but last year there were fully 69 — just about double — the number of sales. In the higher-priced neighborhoods, on the other hand, there were fewer sales than normal.
Another graph…this one showing how many sales typically happen in a year in each neighborhood, followed by how many sales happened in 2007:

The lowest-priced neighborhood — East of 101 — had a dramatic increase in the number of transactions; almost every other neighborhood — in particular the expensive ones had fewer sales.
So this, ladies gentlemen is the key story that Mssrs. Disraeli and Twain — not to mention my stats professors — would want us to understand:
- The median price of homes in Menlo Park has indeed dropped in 2007.
- The price of most individual homes in Menlo Park, however, has actually increased in 2007: that is, most homes were worth more at the end of 2007 than they were at the end of 2006.
- The anomoly between the above two points is explained simply by the mix of the homes that were sold: 2007 saw a much higher than normal proportion of less expensive homes.
Comments
7 Responses to “Lies, Damn Lies, And Statistics: What Mark Twain and Benjamin Disraeli Would Say About Menlo Park’s Median Price Numbers”
Got something to say?





Subscribe

Kevin - You make an excellent point, and one that I underscore in my Statistics for Realtors class at Keller Williams. Because of the large variation in property values in geographically similar neighborhoods, and the very low number of data points (sales), the median and mean trendlines and be very misleading.
Your Realtor is the best source for interpreting this data.
Higher prices are good for whom and bad for whom?
Lower prices are good for whom and bad for whom?
All in all, what is best for the community as a whole?
[...] WordPress.org ← Lies, Damn Lies, And Statistics: What Mark Twain and Benjamin Disraeli Would Say About Menlo Park… [...]
Kevin,
Great post! We’re seeing a similar trend in Mountain View where prices continue to rise in the neighborhoods with Los Altos Schools. These neighborhoods are also having fewer transactions so (if you were looking from the outside in) the overall real estate picture for Mountain View doesn’t look as good. If you’re buying get those local stats to make sense of what you’re doing. Local, local, local!
Nice post. We constantly have to manage our clients expectations after our local newspapers botch up the statistics to create their “doom and gloom” headlines that helps them sell more newspapers. Basically when someone says “How is the market”. Any educated real estate professional’s response should be, “Well let me check on your neighborhood of interest.”
[...] my earlier rant about how real estate statistics don’t always tell an accurate story, let’s look at what Menlo Park’s numbers seem to indicate for our ongoing robust spring [...]
Statistics can be interpreted any way you want them to be. Like Andrew, we also have to manage our client’s expectations. Our local publications don’t always paint the best picture using stats.