Week 2 Assignment 2A Approach

Introduction (Approach)

The goal of this assignment is to survey at least five people about six recent popular films and collect ratings (on a scale of 1-5). To begin, I created a Google Forms survey with five movies. While this was an anonymous survey, I can track individual raters based on the timestamp of survey completion giving me potential “users.” I will create a CSV directly from the survey results and then import into Postgres and later manipulate using R.

The first challenging aspect of this assignment is becoming familiar with Postgres, which I have installed and set up. The second challenge will be linking the SQL database with R. Then creating a compelling analysis with the collected data.