Purchased mortgages data

A team of researchers wants to use data about a borrower and the location of a property to predict the amount of a mortgage. Variables include the income, race, and gender of the borrower as well as the census tract location of the property, and other information about the borrower and the type of property.

You can use this data to demonstrate TreeNet^® Regression.

The second data set includes a small number of new data points for the same variables. You can use this data set to demonstrate Predict for TreeNet^® Regression.

Worksheet column	Description
Loan Amount	The loan amount in whole dollars
Annual Income	The borrower's annual income in whole dollars
Income Ratio	The ratio of a borrower's debts to income
Front End Ratio	The ratio of mortgage payments to income
Back End Ratio	The ratio of debt payments to income
Number of Borrowers	The number of borrowers
Age	The borrower's age in years
Co-Borrower Age	The co-borrower's age in years
Tract Minority Percent	The Census tract's minority percentage
Tract Income	The Census tract's median family income in whole dollars
Local Income	The local area median income in whole dollars
Area Income	The area's median family income in whole dollars
First Time Home Buyer	Whether the borrower is a first-time home buyer: 1 = Yes or 0 = No
Occupancy Code	The occupancy code: 1 = Principal residence or owner-occupied, 2 = Second home, or 3 = Investment property or rental
Self-Employed	Whether the borrower is self-employed: 1 = Yes or 2 = No
Co-Borrower Race 4	The co-borrower's fourth race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, 7 = Information not provided, or 8 = No co-borrower
Co-Borrower Race 5	The co-borrower's fifth race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, 7 = Information not provided, or 8 = No co-borrower
Loan Purpose	The loan purpose: 1 = Purchase, 2 = Refinancing, 3 = Second mortgage, 4 = New construction, or 5 = Rehabilitation
Gender	The borrower's gender: 1 = Male, 2 = Female, or 3 = Information not provided
Number of Units	The number of units on the property: 1–4
Ethnicity	The borrower's ethnicity: 1 = Hispanic or Latino, 2 = Not Hispanic or Latino, or 3 = Information not provided
Co-Borrower Race 3	The co-borrower's third race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, 7 = Information not provided, or 8 = No co-borrower
Co-Borrower Gender	The co-borrower's gender: 1 = Male, 2 = Female, 3 = Information not provided, or 4 = No co-borrower
Race 2	The borrower's additional race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, or 7 = Information not provided
Co-Borrower Ethnicity	The co-borrower's ethnicity: 1 = Hispanic or Latino, 2 = Not Hispanic or Latino, 3 = Information not provided, or 4 = No co-borrower
Credit Score	The borrower's credit score categorized by range: 1 = less than 620, 2 = 620 to less than 660, 3 = 660 to less than 700, 4 = 700 to less than 760, 5 = 760 or greater, or 9 = missing
Co-Borrower Credit Score	The co-borrower's credit score categorized by range: 1 = less than 620, 2 = 620 to less than 660, 3 = 660 to less than 700, 4 = 700 to less than 760, 5 = 760 or greater, or 9 = missing or no co-borrower
Race	The borrower's race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, or 7 = Information not provided
Co-Borrower Race 2	The co-borrower's second race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, 7 = Information not provided, or 8 = No co-borrower
Co-Borrower Race	The co-borrower's race or national origin: 1 = American Indian or Alaskan Native, 2 = Asian, 3 = Black or African American, 4 = Native Hawaiian or other Pacific Islander, 5 = White, 7 = Information not provided, or 8 = No co-borrower
Property Type	The property type: 1 = Single family detached, 2 = De minimus planned unit development, 3 = Single family attached, 4 = Two family, 5 = Townhouse, 6 = Low-rise condominium, 7 = Planned unit development, 8 = Duplex, 9 = Three family, 10 = Four family, 11 = Hi-rise condominium, or 12 = Manufactured home
Federal District	The name of the federal home loan bank district
State Code	A code that represents the state where the property is located
County Code	A code that represents the county where the property is located
Core Based Statistical Area	A code that represents the state, county, and census tract where the property is located. A missing value represents a state, county, and tract combination that is not located in a core based statistical area

Download PurchasedMortgages.MTW

Download PurchasedMortgagesPredictions.MTW

Reference

These data were adapted based on a public data set containing information on federal home loan bank mortgages. Original data from fhfa.gov.