Question: The file S02 35 xlsx contains fictional data from a survey of

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.

View Solution:

Sale on SolutionInn
  • CreatedApril 01, 2015
  • Files Included
Post your question