Assignment:
The file contains data from a survey of 500 randomly selected households. Use Excel filters to answer the following questions.
a. Identify households that own their home and have a monthly home mortgage payment in the top quartile of the monthly payments for all households.
b. Identify households with monthly expenditures on utilities that are within two standard deviations of the mean monthly expenditure on utilities for all households.
c. Identify households with total indebtedness (excluding home mortgage) less than 10% of the household's primary annual income level.
Attachment:- Contains data households.rar