Wednesday, November 7, 2007

Mining for Data - Part 7

We have gone to a lot of trouble to this point to gather sales data and massage it to provide some statistical picture of how the neighborhood market has been performing. The data from Realist.com can be summarized like this [apology for the massive white space]:




















Summary of Data from Realist.com
Year# SoldMin SPMax SPMean SPMedian SPModeStd. Dev.
200139$30,000$129,000$60,619.23$59,000$62,000$17,967.33
200242$23,000$118,500$62,476.19$59,550$35,000$20,502.13
200356$12,003$157,500$67,249.98$67,100$55,000$23,168.68
200484$15,000$175,000$72,363.56$75,000$80,000$30,403.45
200571 $8,900$147,700$74,739.11$75,500$75,000$27,609.10
200689$21,525$116,500$72,970.78$75,000$80,000$19,934.08



So what does this seem to tell us? It appears that the mean and median sales prices in this neighborhood have increased by roughly 25% over a six year period. This fits the general trend that has been trumpeted through the land with respect to rising property values. The data from the MLS needs to be added to provide some information about average market times :




















Summary of Data from CRIS MLS
Year# SoldAvg DOMMin SPMax SPMean SPMedian SPPred. Price Range
20014262$19,000$129,000$56,957$50,200$30,000-$39,999 (8)
20024286$20,000$131,000$53,146$39,500$20,000-$29,999 (11)
20036075 $7,000$157,500$42,365$31,550$30,000-$39.999 (18)
20046677 $8,000$130,880$49,339$35,125$20,000-$29,999 (19)
20056983$11,000$139,900$40,506$32,000$20,000-$39,999 (18)
20068085 $9,500$109,900$39,343$30,500$20,000-$29,999 (24)



WAIT A MINUTE!! THAT CAN'T BE RIGHT!!!!

Tune in next time for another exciting adventure with Top-Notch Appraiser, and we will try to make some sense of this. In the meantime, go back and think about those assumptions that had to be made with respect to the data from Realist.com.

No comments:

Post a Comment