Sample Case with a report
Dawit Zerom, Instructor
Case Study: Ft. Myers Home Sales
Due to a crisis in subprime lending, obtaining a mortgage has become difficult even for
people with solid credit. In a report by the Associated Press (August 25, 2007), sales of
existing homes fell for a 5th consecutive month, while home prices dropped for a record
12th month in July 2007. Mayan Horowitz, a research analyst for QuantExperts, wishes to
study how the mortgage crunch has impacted the once booming market of Florida. He
collects data on the sale price (in $1, 000s) of 25 single-family homes in Fort Myers,
Florida, in January 2007 and collects another sample in July 2007. For a valid
comparison, he samples only three bedroom homes, each with 1,500 square feet or less of
space on a lot size of 10, 000 square feet or less.
Excel data are available in Titanium page.
Use the sample information (appropriate descriptive statistics) to address the following
aspects. Your report should not exceed one page.
Compare the mean and median in each of the two sample periods.
Compare the standard deviation and coefficient of variation in each of the two sample
periods. Also incorporate quartiles.
Discuss significant changes in the housing market in Fort Myers over the 6-month
period.
Sample Case with a report
Dawit Zerom, Instructor
Sample Report
The steady stream of dismal housing market statistics lately is a clear indication that the national
real estate market is in a serious crisis. The uncertainty is also forcing lenders to slow down on
their lending, and as a result obtaining a mortgage is becoming increasingly difficult even for
people with solid credit. In light of this situation, Mayan Horowitz conducts a small study to
learn if the national trend also affects the once booming market of Florida by focusing on Fort
Myers, Florida. To see the trend of the housing market over a 6-month period, he obtains price of
25 single family homes in January 2007 and another comparable 25 single family homes in July
2007. Table 1 below shows the most relevant descriptive analysis.
The average home price in January of 2007 was $231, 080 versus $182, 720 in July of the same
year. That is about a 21% drop in the average home price. Also in January, half of the homes
sold for more than $205,000, versus only $180,000 in July (see the median). Since the mean is
more effected by outliers (in this case, a few relatively high prices), the median is an appropriate
measure of central location.
While measures of central location typically represent where the data clusters, these measures do
not relay information about the variability in the data. Both the standard deviation and the
coefficient of variation are higher in January indicating that home prices were more dispersed in
January. Further, while 25% of the houses were sold at the price of $158, 000 or less in January,
the first quartile for July is only $133, 000. The third quartile is also larger in January.
In summary, the above statistical analysis shows Fort Myers is no different from the national
trend, and is well affected by the housing crisis. On a positive note, over the 6-month period,
Fort Myers became a buyers’ market; of course for people who can borrow.
Sample Case with a report
Dawit Zerom, Instructor
Table 1: Summary measures for January 2007 and July 2007
2007 Home Sale Prices in Fort Myers, FL
January
July
Mean
231.08
182.72
Median
205.00
180.00
Mode
220.00
210.00
Sample Variance
12926.08
4813.88
Standard Deviation
113.69
69.38
Coef. of Variation
0.49
0.38
Range
510.00
314.00
Minimum
100.00
86.00
Maximum
610.00
400.00
1st Quartile
158.00
133.00
3rd Quartile
256.00
215.00
I have attached sample report on how to do the assignment