Problem 2: Household Income ( 80 points) Consider the data below from an economic development study. Create three separate pivot tables to answer to each of the following questions: a. What percentage of households within each of the four locations owns their homes? b. What are average utilities paid in each of four locations and which location has the highest average first income? c. What is the percentage of household who lives in location 1 and owns a home? Problem 2: Household Income ( 80 points) Consider the data below from an economic development study. Create three separate pivot tables to answer to each of the following questions: a. What percentage of households within each of the four locations owns their homes? b. What are average utilities paid in each of four locations and which location has the highest average first income? c. What is the percentage of household who lives in location 1 and owns a home