The file S02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households. Use Excel filters to answer the following questions.
a. What are the average monthly home mortgage payment, average monthly utility bill, and average total debt (excluding the home mortgage) of all homeowners residing in the southeast sector of the city?
b. What are the average monthly home mortgage payment, average monthly utility bill, and average total debt (excluding the home mortgage) of all homeowners residing in the northwest sector of the city? How do these results compare to those found
in part a?
c. What is the average annual income of the first household wage earners who rent their home?
(House or apartment)? How does this compare to the average annual income of the first household wage earners who own their home?
d. What proportion of the surveyed households contains a single person who owns his or her home?