MBA 6211 Managerial Decision Making (excel)

profiletenealewis21
FinalExam_BayouCityREIT_DataSet.xlsx

Source Data

Year Average Rent Vacancy Rate Renter Fraction Total property sales Average Home Sales Price Home Median Sales Price WTI_Crude Price Unemployment Rate
Avg_Rent Vac_Rate Renter_Frac Tot_Propty_Sale Avg_Home_Sale_Price Med_Home_Sale_Price WTI UnEmp Rate
2017 $1,091 9.73% 39.26% 94,818 $291,340 $229,900 50.8 5.8
2016 $1,084 7.28% 40.83% 91,530 $283,133 $221,000 43.29 4.8
2015 $1,069 6.46% 41.33% 88,764 $280,290 $212,000 48.66 4.6
2014 $1,020 7.13% 40.94% 91,439 $270,182 $199,000 93.17 5.5
2013 $964 8.39% 39.87% 88,080 $248,591 $180,000 97.98 6.6
2012 $956 10.17% 38.65% 74,116 $225,330 $164,500 94.05 7.2
2011 $941 11.64% 38.44% 63,606 $213,723 $155,000 94.88 8.3
2010 $961 13.76% 37.16% 61,005 $211,765 $153,990 79.48 8.7
2009 $984 12.27% 37.74% 63,803 $203,626 $153,000 61.95 6.2
2008 $971 12.55% 36.63% 69,336 $208,266 $152,000 99.67 4.5
2007 $924 13.57% 36.12% 83,736 $206,393 $152,000 72.34 4.6
2006 $913 10.91% 36.52% 87,574 $198,410 $149,079 66.05 5.7