This course is designed to familiarize students with core skills in data access, manipulation, analysis, and presentation using Excel (and Excel-like alternatives). Spreadsheet programs remain an important part of professional life, and this course will prepare students for basic and intermediate use of aspects of the program in that setting. Students will learn about data import, formatting, and management. You will also learn about producing tables (including summarization), visualizations, varieties of analysis (ANOVA, regression, etc.), and basic programming. No prior knowledge of Excel is expected, but familiarity with basic concepts of statistics is recommended.
Combined w/ PubPol 647.
This course meets during the second half of the semester: 10/21/19 - 12/11/19.