F IL E (Use Excel) While the housing market has not recovered, real estate investment in college towns continues to promise good returns (The Wall Street Journal, September 24, 2010). With rents holding up, this is good news for investors but the same cannot be said for students. There also tends to be significant variability in rents. Consider m onthly rents of tw o bedroom apartments in tw o campus towns: Ann Arbor, Michigan, and Davis, California. A portion of the data is shown in the accompanying table; the complete data, labeled Rentals, can be found on the text website.

Ann Arbor Rent Davis Rent

$850 $744 929 850

⋮ ⋮

1450 1810 Source: w w w .zillow .com .

a. Use Excel to calculate the standard deviation o f rent fo r Ann Arbor, M ichigan, and Davis, California.

b. C onstruct and in terpret 95% confidence intervals fo r the standard deviation o f rent fo r both Ann Arbor, M ichigan, and Davis, California.

c. For each campus tow n, determ ine if the standard deviation o f rent differs from $200; use α = 0.05.