Quiz Due 5 pm Monday, Sept. 19
Sept. 19 Quiz: Turning Up The Heat
Important formatting note:
—Put your last name and date on the spreadsheet, ie “Wells Quiz 9-19”
—Upload the sheet as a blog post and click the category “Student Work”
–Clearly label your work with dates and a description of the data you have calculated.
Briefly…
Creating Tabs.
Data Diary.
Save Your Work. Iterative
filtering
formulas
Continue Work With HMDA Data:
https://www.ffiec.gov/hmda/
Combine the conventional and FHA mortgage data, Tables 4-1 and 4-2
–Total the mortgage data for all conventional and FHA/VA loans into a single spreadsheet. That would be Tables 4-1 and 4-2 of the HMDA data.
–Upload a summary table or spreadsheet with the following:
–Column A lists race / ethnicity
–Column B lists total applications
–Column C lists total loans originated
–Column D lists total loans declined
–Column E calculates the rejection rate (declined / applications).
Clearly label your work with dates and a description of the data you have calculated.
Homework for Tuesday:
Quiz Due 5 pm Monday, Sept. 19
Important Announcement Not Related To Class:
Come jam with @GalacticFunk on Sun. 11/13! It’s going to be a fun night! Get tickets at https://t.co/mOhVAhrgOF! pic.twitter.com/CkxRJUFY1x
— George’s Majestic (@georgesmajestic) September 14, 2016
Recent Comments