Oct 20 Class

Discussion for Oct 20: Pivot Tables Part 1: Pivot tables Pivot tables are a powerful tool in Excel to analyze and tabulate complex spreadsheets. Follow the instructions on this NICAR tipsheet called pivot tables.. You will be using a practice dataset called worldbank....

Tuesday, Oct. 11

Homework for Wednesday, Oct 12: Pivot Tables, LaRoche Part 1: Pivot tables Pivot tables are a powerful tool in Excel to analyze and tabulate complex spreadsheets. Follow the instructions on this NICAR tipsheet called pivot tables.. You will be using a practice dataset...

Thursday, Oct 6

Research the Banks, Part 1 Build a Spreadsheet from the 2013 Book of Lists, Northwest Arkansas Business Journal. Use these fields: Rank/Lender/ City /2012 Mortgages /2011 Mortgages /% Change  Number /2012 Value /2011 Value /% Change Value Create New Calculated Field...

Tuesday Oct. 4

First Assignment Due Monday, Oct 10, 5 pm. So far in class, we have examined the mortgage lending issue from several perspectives so far. In this assignment, you will write a 500 word news analysis article, supply two graphics and underlying data that addresses these...

Thursday Sept 29

Announcements Guest Speaker: Tuesday, Oct. 11. Prof. Timothy Yeager, Walton College of Business, Arkansas Bankers Assn. Endowed Chair –Former economist at the St. Louis Federal Reserve Bank http://walton.uark.edu/directory/?id=tyeager Class Project From My...

Tuesday Sept. 27 Class

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....