Additional Topics: Accessing MySQL from R & Linear Regression
Here are some materials for two additional topics. These are optional and will not be covered in the third exam.
1. Accessing MySQL from R. The MySQL-Example.r script demonstrates how to query the moviedb schema on our class server using R. It will work with your MySQL account. With this nice tool you can extract data directly from a database by using SQL-statements, so that data can be analyzed in R.
2. Linear Regression is a statistical method to analyze the relationship between an continuous outcome variable and one or more predictor variables.