Exercise

Race and Ethnic Representation in the Mortgage Data

In this exercise, you'll get the race and ethnic proportions of borrowers in the mortgage data set, adjusted by the total number of borrowers. This will turn the race and ethnicity table you created before into a proportion. Later on, you'll use these values to adjust for the race and ethnic proportions of the US population.

Instructions

100 XP

The reference object mort is available in your workspace.

Create a table from the borrower_race column in the mortgage data (mort) using bigtable().
Where the race is known (first 7 values) find the proportion by dividing by the sum of the counts.