This two-part interactive workshop series will introduce the fundamentals of quantitative data analysis with Excel using the recently released A*CENSUS II data. The series will take participants through the full process from understanding and organizing data to showcasing their analysis to highlight key insights. The first workshop will focus on understanding the data, exploring Excel’s functionality, and executing common statistical analyses. In preparation for the second workshop, participants will be given exercises to cement and enhance their understanding of the material. In the second workshop participants will use their analysis to create visually appealing dashboards to showcase significant data insights. At the conclusion of the second workshop, all participants should feel confident is using Excel with their own data to discover and communicate meaningful insights to colleagues and other sponsors.

Learning Objectives

• Identify key quantitative data types and associated common statistical techniques.
• Understand core features and functions available to organize and interpret data in Excel.
• Statistically summarize a real dataset to discover meaningful insights.
• Create a visually appealing dashboard to showcase major findings from the data analysis.