Ever want to know how to communicate with a database? You need to know SQL, a standard programming language for working with relational database management systems in data warehouses or just Microsoft Access. This workshop will cover the basic syntax of SQL. Material will focus mainly on how to query databases. A web-based tool will […]

This workshop will cover regression analysis using linear models and least squares in Python.  We will discuss the goals and main use-cases for linear regression, and how to interpret a fitted linear model.  We will then discuss methods for fitting more complex models with larger data sets, including the use of interactions, dummy-coding of categorical […]

Topics: By the end of the workshop, participants will be able to: Work with Stata, including using Do-files and using the help system. Get data into Stata and manage your data files Establish familiarity with your data Clean the data to prepare it for analysis Check for basic errors in the data Generate new variables […]

This workshop will cover fitting generalized linear models (GLMs) in Python, using the Statsmodels package.  We will cover logistic regression, but the majority of the time we will focus on other GLMs including Poisson, negative binomial, and gamma regression.  We will provide an overview of the underlying foundation for GLMs, focusing on the mean/variance relationship […]

In this session, we will discuss fitting traditional regression models in Stata, including linear regression, logistic regression, and time-allowing, poisson regression. We'll briefly introduce the theory behind the models, discuss choosing an appropriate model, fitting the model, checking assumptions and some post-hoc analysis. Participants are expected to have some basic familiarity with Stata.