As a part of an economic development study conducted by the local government, 500 households in a middle-class neighborhood were recently surveyed. In particular, for each of the randomly selected households, the survey requested information on the following variables: family size, approximate location of the household within the neighborhood, an indication of whether those surveyed owned or rented their home, gross annual income of the first household wage earner, gross annual income of the second household wage earner (if applicable), monthly home mortgage or rent payment, average monthly expenditure on utilities, and the total indebtedness (excluding the value of a home mortgage) of the household. These data are provided in the file P2.6.XLS. Compute and interpret relevant numerical summary measures to complete the following.

a. Use these data to formulate a profile of the typical household residing within each of the four neighborhood locations. Consider such attributes as family size, home ownership status, gross annual income(s) of household wage earner(s), monthly home mortgage or rent payment, average monthly expenditure on utilities, and the total indebtedness (excluding the value of a home mortgage) of the household in formulating your profile.

b. Do differences arise in the mean or median income levels of those wage earners from households located in different quadrants of this neighborhood? If so, summarize these differences. 

c. Do differences arise in the mean or median monthly home mortgage or rent payment paid by households located in different quadrants of this neighborhood? If so, summarize these differences. 

d. Do differences arise in the mean or median debt levels of households located in different quadrants of this neighborhood? If so, summarize these differences.