Chapter 8 Ann Arbor Rental Project and Quiz 40 points While

Chapter 8 Ann Arbor Rental Project and Quiz (40 points).

While the housing market is in the tank and is not likely to emerge anytime soon, real estate investment in college towns continues to promise good returns( The Wall street Journal, September 24,2010). Marcela Treisman works for an investment firm in Michigan. Her assignment is to analyze the rental market in Ann Arbor, which is home to the University of Michigan. She gathers data on monthly rents for 2011 along with the square footage of 40 homes. (Reference Chapter 8 to complete this assignment). All Excel print outs must have your name, student identification number and class section in the heading. Use Excel to calculate the mean and standard deviation for monthly rent.

Use Excel to calculate the mean and standard deviation for square footage.

Use Excel to construct 90% confidence intervals for the mean rent and the mean square footage of all homes in Ann Arbor Michigan.

Link to Chapter 8: http://higheredbcs.wiley.com/legacy/college/cortinhas/1119993660/manual/ExcelManualCh08.pdf

Solution