Important Event next Tuesday and Extra Credit Opportunity:
https://wordpressua.uark.edu/datareporting/ethics-summit-2-p-m-tuesday-sept-29/
Review HMDA Master Spreadsheet into Tableau Public
Produce a graphic showing the mortgage rejection rate for all races and sexes.
How to Edit PDFs and embed images in WordPress
Review the questions your colleagues posted for the Sept. 19 assignment.
Select any two questions from another student that you think should be asked as we report out this story. Add two more new questions of your own, which can be based on your Tableau work or Excel work.
Be prepared to discuss your selections in class. We will map out a reporting game place and begin planning interviews based on this work.
NW Arkansas Data
http://www.nwacouncil.org/pages/data-summary-nwa/
Gather Demographic Data by Income, Race
American Fact Finder
http://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml
—Advanced Search
—Show Me All
TOPICS:
—People:
1)-Origins
—Race and Ethnic Origin
2)-Income and Earnings
—INCOME/EARNINGS HOUSEHOLDS
GEOGRAPHIES:
–Metropolitan Statistical Area/Micropolitan Statistical Area -310
Fayetteville Springdale Rogers AR-MO Metro Area
Tables B19113A-G: Median Family Income for past 12 months white, black etc.
Check the 8 files and download as Excel or Build Your Own Spreadsheet with the Data
Homework for Thursday
Due 5 pm Wednesday, Sept. 28: Visualize new demographic data with income by race using Excel or Tableau. Compare this to the rejection rate for mortgages and the application rates.
Upload a chart onto the blog. Post brief observations about this data and what it means going forward.