Interviews: Due Monday, Nov. 7, 11:59 PM

See Assignment #2 in Blackboard

1. Bring a Digital SLR Camera and a Audio Recorder to the Interviews.
2. Tell the people we will be using a fact-check process and someone will be calling back to double-check facts from this interview before we publish. Obtain the email address and cell number of each person you interview and put that on the interview sheet.
3. I need a FULL VERBATIM TRANSCRIPT of each interview. I need the audio files. No exceptions. Upload transcript, audio and images to Google Drive space for our class: https://drive.google.com/drive/folders/0B9N10qKqBa2zVGtWbVctNU9kZTQ?usp=sharing

Trupp, Monk and Ball: Marshallese community

Flores, Messina, Lyster, Billmyre:  Hispanic community

Dobrin,Thomas, Taylor Pratt: Bankers in the Northwest Arkansas area

Taylor Pray, Eley, Ward:  Asian community
–Quincy includes questions based on his immigration & salary research for Asians.

For each group, gather the data and information to ask the following questions:

–Rejection rate for combined conventional and FHA mortgages in 2014 and how that compares to whites.
–Median household income for these groups vs whites
–What is the trend for these groups prior to 2014.
–How the banks perform outreach or marketing to their communities.
–Additional questions based on your research.
–A specific game plan telling me when and how you are going to conduct these interviews and divide up the labor.
Options could be your group picks one person to make the calls and the others will do background research to prepare for the interview or will transcribe the recording afterwards. Another option is the entire group goes to the interview. Another option is two people do the interview and a third person does charts or some new data work.

This page will have some useful background for the assignment.

Review Homework:

Examine Flat Files, Determine Discrepancies

#1: Resume Where We Left Off in Class
–Use the 2014 Flat Files —> THIS ONE  FLAT FILES   <—– and Calculate the Denial Rate for All Loans
–Compare the Denial Rates To the Earlier and Smaller Subset of Loans.
—WHY? Using Excel, Find Out Why Some Groups Now Have a Higher Rejection Rate with the larger dataset than with the smaller data. Was it because of refinancing? Was it because of farm loans? Run the different scenarios using Excel pivot tables.

More Questions for HMDA Flat Files

We are continuing work with the FLAT FILES and the Aggregate Table 4-2.

Here are the base results for the Conventional, FHA, VA mortgages

Produce individual charts from the 2014 Flat Files in Tableau for the following:
Team 1: Analyze denial reasons by race, ethnicity
Team 2: Loan Approvals and Denials by Minority Population %
Team 3: Loan amount by race
Team 4: Loan Approvals and Denials by sex and race

Background:
https://www.ffiec.gov/hmda/hmdarawdata2015.htm#by_msa

See CODING SHEETS
“File Formats & Documentation (PDFs)”
See Code Sheet, Inst Record Format, LAR Record Format, MSA Office, Reporter Panel

Tableau Tuneup

Put Dollar Signs on Labels

Insert Legends in Graphs

Filter Data in Graphs

Label the Horizontal Axis Properly

Basic labeling and graph

Relational Databases: How They Work

Link on Common Fields
Inner, Left, Right joins
http://www.tableau.com/learn/tutorials/on-demand/join-types-union

Basic background

visualization-and-tableau-introduction-9-22

Homework due Wednesday, Nov. 2, 11:59 pm

Analyze 2014 Flat Files and produce a single graphic for each of the following: