Question

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. 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.



$1.99
Sales0
Views14
Comments0
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000