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 earmer, 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. The data are in the file P2_6.XLS. Use Excel to construct pivot tables or other descriptive graphs to answer the following questions: 

a. What proportion of households in each of the four locations within this neighborhood own their homes?

b. What relationship, if any, exists between the primary household income level and family size?

c. What relationship, if any, exists between the primary household income level and the household’s location within the neighborhood? d What relationship, if any, exists between the primary household income level and whether the household owns or rents their home?