Housing Costs Follow the link at www.mhhe.com/waitley5e to a U.S. Housing and Urban Development Web site that provides information on the median cost of apartments in various U.S. cities and counties. Open the data in Excel spreadsheet format. What is the average monthly rent for a one-bedroom apartment in your city or county? For a twobedroom apartment? Organize the spreadsheet so that the cities in each state are arranged in order of apartment rental cost (from most expensive to least expensive). Which city in your state has the lowest average rent for a one-bedroom apartment? Which has the highest?